MySQL learning note _ How to choose the appropriate storage engine MyISAM: suitable for use with select and insert-based, with only a few updates and delete, and transaction integrity,
Concurrency requirements are not very high. MySQL is one of the most commonly used storage engines in the Web, data warehouse, and other application environments. Www.2cto.com InnoDB: used for transaction processing applications. It supports foreign keys. If the application has high requirements on transaction integrity,
Data Consistency is required under concurrent conditions. In addition to insert and select, data operations also include many update and delete operations,
Therefore, the InnoDB Storage engine should be a suitable choice. In addition to effectively reducing the locking caused by deletion and update, the InnoDB Storage Engine,
It can also ensure the complete Commit and Rollback of transactions, and ensure data accuracy for similar billing systems or financial systems.
For systems with high requirements, InnoDB is a suitable choice. In addition, note that the select count (*) query efficiency of the InnoDB type table is very poor.
MEMORY: stores all data in RAW and provides extremely fast access in environments where you need to quickly locate records and other similar data.
MEMORY has a limitation on the table size. A large table cannot be cached in the MEMORY. The second is to ensure that the table data can be recovered,
The data in the table can be recovered after the database ends abnormally. MEMORY tables are usually used to update small tables that are not frequently updated for quick access.
Author: Acacia Forest