Php-note 0214 1. MyISAM tables (mysql) cannot process transactions, so there is no additional overhead required by the transactional storage engine (such as InnoDB. Applicable to the following situations:
1> select intensive tables.
MyISAM filters a large amount of data quickly, even in high-traffic environments.
2> Insert intensive tables.
The concurrent MyISAM insert feature allows you to select and insert data at the same time. For example, you can manage mail or WEB server log data.
2. the static TABLE structure (xBLOB, xTEXT, or VARCHAR are not used) has high performance, but it must be at the cost of space. If dynamic TABLE structure is used, optimize table statements are often used, it sorts out the fragments of the table caused by moving variable-length fields.
3. INNODB is a robust transactional storage engine that uses dedicated buffer management (configurable) to introduce row-level locking and foreign key constraints. Applicable to the following situations:
1> update intensive tables.
Suitable for processing multiple concurrent update requests.
2> transactions.
3> automatic disaster recovery.