How to speed up the MySQL database

[Kalanidhi]

Hi all,

MySQL the native engine is certainly good enough for us, but in some cases, other engines may be used in hand is more suitable than the job done. I want create my own database engine, like punch through the cylinder fitted with its own carburetor. Now let's want to know that how to choose the engine, and how to switch between the available engines. Please suggest. Thanks in advance.

[Katty]

You can use the MySQL database engine depends on how the time of the installation was compiled. To add a new engine, you must re-compile MySQL. Just to add a feature and compile apply the concept of process Windows Developers who may be very strange, but in the Unix world, it has become the standard. By default, MySQL supports three engines: ISAM, MyISAM, and HEAP. The other two types of InnoDB and Berkley (BDB), also often can be used. All the best.

[kelfro]

ISAM is a well-defined and the data tables after the test of time management method, it design the time to consider the number of queries to the database have been updated to be much larger than the number of times. Therefore, ISAM implementation of the fast read operations, but do not take up a lot of memory and storage resources. ISAM two main shortcomings is that it does not support transactions, nor can it fault-tolerant. If your hard drive crashes, then the data File can not be restored. If you are the ISAM used in mission-critical applications where, it must always back up all of your real-time data replication, through its properties, MySQL can support such a backup application.

[Zecho]

You can use MySQL + + to create your own database engine. This API gives you the operation fields, records, forms, databases, connectivity, security, account features, and the establishment of such a DBMS such as MySQL need all the other numerous features. API has been explained in depth beyond the scope of this article, but you need to know about the existence of MySQL + + and its exchangeable engine, the technology behind it and this is very important. It is estimated that the model of plug-in database engine or MySQL can be used to create a local XML provider. All the best.

[Reegan]

InnoDB and Berkley DB database engine is the flexibility to create MySQL Technology Direct products, this technology is that MySQL + + API. The use of MySQL, you are facing almost every challenge from ISAM and MyISAM database engine does not support the transaction does not support foreign keys. Although slower than the ISAM and MyISAM engine, a lot, but the InnoDB and BDB includes a transaction processing and foreign keys to support them, are the first two engines do not have. If you need these features in the design of a person or both, then you have to be forced to use after only one of two engines. Check and reply.

[opaper]

HEAP is also allow to reside in memory temporary table. Reside in memory for HEAP faster than the ISAM and MyISAM, but it manages the data is unstable, and if not carried out prior to the shutdown to save, then all data will be lost. In the data row is deleted when, HEAP will not waste a lot of space. HEAP forms you need to use the SELECT expressions to select and manipulate data on the time very useful. Remember to delete the run out table after table. Let me repeat: after you run out of form, do not forget to delete the form. Check and reply.