=fa>本文将讲述服务器创建个逻辑数据库十分适合于分布式环境或数据集市环境

◆ Cluster/NDB:MySQL簇式数据库引擎尤其适合于具有高性能查找要求应用这类查找需求还要求具有最高正常工作时间和可用性

◆ Other:其他存储引擎包括CSV(引用由逗号隔开用作数据库表文件)Blackhole(用于临时禁止对数据库应用输入)以及Example引擎(可为快速创建定制插件式存储引擎提供帮助)

请记住对于整个服务器或方案你并不定要使用相同存储引擎你可以为方案中每个表使用区别存储引擎这点很重要

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 | +------------+---------+----------------------------------------------------------------+





TAG: mysql MySQL Mysql MYSQL MySQl 选择 引擎