Introduction: For specific forms of the engine will need to re-compile and track, taking into account the additional complexity of this, why do you still want to use non-default database engine do? The answer is simple: to adjust the database to meet your needs. U.S. Server Alliance ...
MySQL database engine quick guide
If you are a racer and the click of a button will be able to immediately replace the engine without the need to drive to the garage go for, that would be how the feel? MySQL database developers has done is like press the button for the engine; it allows you to select the database engine, and give you a simple way to switch it.
MySQL's own 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. If you prefer, you can even use MySQL + + API to create your own database engine, like punch through the cylinder fitted with its own carburetor. Now let's take a look at how you choose the engine, and how to switch between the available engines.
Choose your engine
You can use the MySQL database engine depends on how the time of the installation was compiled. To add a new engine, we must re-compile MySQL. Just to add a feature to compile the application and the concept of Windows developers who might be 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.
ISAM
ISAM is a well-defined and the data tables after the test of time management methods, it is taken into account when designing the database is the number of queries to be much larger than the number of updates. 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 files 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.
You can use the SHOW TABLE command (which is another MySQL extension to the ANSI standard) to determine which engines in the management of a specific form. SHOW TABLE returns with a multi-column result set, you can use this result set to query access to all types of information: the name of the database engine in the Type field in years. The following sample code illustrates the usage of SHOW TABLE:
SHOW TABLE STATUS
