如何选择合适的MySQL存储引擎

mysql> show engines;+------------+---------+----------------------------+| Engine     | Support | Comment                                                        |+------------+---------+----------------------------+| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance         | | MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables      | | InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys     | | BerkeleyDB | NO      | Supports transactions and page-level locking                   | | BLACKHOLE | NO      | /dev/null storage engine (anything you write to it disappears) | | EXAMPLE    | NO      | Example storage engine                                         | | ARCHIVE    | NO      | Archive storage engine                                         | | CSV        | NO      | CSV storage engine                                             | | ndbcluster | NO      | Clustered, fault-tolerant, memory-based tables                 | | FEDERATED | NO      | Federated MySQL storage engine                                 | | MRG_MYISAM | YES     | Collection of identical MyISAM tables                          | | ISAM       | NO      | Obsolete storage engine                                        | +------------+---------+----------------------------+

【编辑推荐】