如何查看mysql支持的存储引擎

来源：互联网发布：三星手机怎么备份数据编辑：程序博客网时间：2024/05/17 07:05

  作者:zhanhailiang 日期:2013-03-07

要想找出你的服务器支持哪个存储引擎，执行下面的语句：

mysql> SHOW ENGINES\G*************************** 1. row ***************************      Engine: FEDERATED     Support: NO     Comment: Federated MySQL storage engineTransactions: NULL          XA: NULL  Savepoints: NULL*************************** 2. row ***************************      Engine: MRG_MYISAM     Support: YES     Comment: Collection of identical MyISAM tablesTransactions: NO          XA: NO  Savepoints: NO*************************** 3. row ***************************      Engine: MyISAM     Support: YES     Comment: MyISAM storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 4. row ***************************      Engine: BLACKHOLE     Support: YES     Comment: /dev/null storage engine (anything you write to it disappears)Transactions: NO          XA: NO  Savepoints: NO*************************** 5. row ***************************      Engine: MEMORY     Support: YES     Comment: Hash based, stored in memory, useful for temporary tablesTransactions: NO          XA: NO  Savepoints: NO*************************** 6. row ***************************      Engine: CSV     Support: YES     Comment: CSV storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 7. row ***************************      Engine: ARCHIVE     Support: YES     Comment: Archive storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 8. row ***************************      Engine: PERFORMANCE_SCHEMA     Support: YES     Comment: Performance SchemaTransactions: NO          XA: NO  Savepoints: NO*************************** 9. row ***************************      Engine: InnoDB     Support: DEFAULT     Comment: Supports transactions, row-level locking, and foreign keysTransactions: YES          XA: YES  Savepoints: YES9 rows in set (0.00 sec)

还可以使用下面的语句代替SHOW ENGINES，并检查你感兴趣的存储引擎的变量值：

mysql> SHOW VARIABLES LIKE "have%";+----------------------+----------+| Variable_name        | Value    |+----------------------+----------+| have_compress        | YES      || have_crypt           | YES      || have_csv             | YES      || have_dynamic_loading | YES      || have_geometry        | YES      || have_innodb          | YES      || have_ndbcluster      | NO       || have_openssl         | DISABLED || have_partitioning    | YES      || have_profiling       | YES      || have_query_cache     | YES      || have_rtree_keys      | YES      || have_ssl             | DISABLED || have_symlink         | YES      |+----------------------+----------+14 rows in set (0.00 sec)

其中：各值含义

YES ：支持该特性并已经激活。
NO ：不支持该特性。
DISABLED ：支持该特性但被禁用。