The storage engine for MySQL database

The storage engine for MySQL database

The storage engine is a unique feature of the MySQL database, and other databases do not have such functionality. The so-called storage engine is the way the database stores data at the bottom. Here is a brief summary of the storage engines that were previously exposed.

MySQL default storage engine is the INNODB,INNODB feature has the following points:

1.InnoDB Storage Engine supports data recovery after database crash;2. TheInnoDB storage engine supports foreign key constraints, supports cascading updates and cascade deletions, and3. InnoDB storage Engine supports things.

Because the InnoDB storage engine supports things, it is a highly secure storage engine, but the storage engine is slightly less efficient.

There is also a storage engine called the MyISAM storage Engine, which has a slightly more efficient storage engine. This storage is stored by three files together, and these three files are in. frm/. Myd/. Myi end of the file, respectively, representing the format file, data file, index file. It is because of these three files that the data is stored together, which makes the storage efficiency of the MyISAM storage engine slightly higher. But this storage engine does not support things, so it is less secure than the InnoDB storage engine.

In addition, there is a more efficient storage engine called memory. This storage engine keeps the data in memory, so it is very efficient because it does not require an IO stream, but because it keeps the data in memory, it has the lowest security.

Welcome to Exchange Mr. Zhang [email protected]

The storage engine for MySQL database