mysql show engines;+------------+---------+----------------------------------------------------+| Engine | Support | Comment |+------------+---------+-----------------------------------------------------+| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance || HEAP | YES | Alias for MEMORY || MEMORY | YES | Hash based, stored in memory, useful for temporary tables || MERGE | YES | Collection of identical MyISAM tables || MRG_MYISAM | YES | Alias for MERGE || ISAM | NO | Obsolete storage engine, now replaced by MyISAM || MRG_ISAM | NO | Obsolete storage engine, now replaced by MERGE || InnoDB | YES | Supports transactions, row-level locking, and foreign keys || INNOBASE | YES | Alias for INNODB || BDB | NO | Supports transactions and page-level locking || BERKELEYDB | NO | Alias for BDB || NDBCLUSTER | NO | Clustered, fault-tolerant, memory-based tables || NDB | NO | Alias for NDBCLUSTER || EXAMPLE | NO | Example storage engine || ARCHIVE | NO | Archive storage engine || CSV | NO | CSV storage engine |+------------+---------+-------------------------------------------------------+
16 rows in set (0.01 sec) 这个表格显示了可用的数据库引擎的全部名单以及在当前的数据库服务器中是否支持这些引擎。
对于MySQL 4.1.2以前版本,可以使用mysql show variables like "have_%"(显示类似“have_%”的变量):
(本文来源于图老师网站,更多请访问http://m.tulaoshi.com/mysql/)mysql show variables like "have_%"; +------------------+----------+ | Variable_name | Value | +------------------+----------+ | have_bdb | YES | | have_crypt | YES | | have_innodb | DISABLED | | have_isam | YES | | have_raid | YES | | have_symlink | YES | | have_openssl | YES | | have_query_cache | YES | +------------------+----- 展开更多 (50%)分享猜你喜欢
下拉加载更多内容 ↓