MySQL search engine and its differences

Common MySQL engines commonly used are: Isam,myisam,heap,innodb and Berkley (BDB).

The ISAM:ISAM performs read operations quickly and does not consume a large amount of memory and storage resources, and the disadvantage is that transactions are not supported, foreign keys are not supported, and fault tolerance is not possible.

MyISAM: On ISAM basis, provides a number of functions that ISAM does not have for index and field management, and uses a table locking mechanism to optimize multiple concurrent read and write operations, but a waste of space and the need to run commands (OPTIMIZE TABLE) to restore space wasted by the updated mechanism.

HEAP: Allows temporary tables that reside only in memory to be faster than ISAM and MyISAM, but the data it manages is also unstable, and if not saved before shutdown, all data is lost. The heap does not waste a lot of space when the data is deleted, and the heap table is useful when you need to select and manipulate data in a practical select expression. But remember, delete the table after you have finished using the form!

InnoDB and BDB: Although much slower than ISAM and MyISAM engines, it includes support for transactional and foreign keys.