信息模式 ENGINES 表
它包含以下列:
列名 | 描述 |
---|---|
ENGINE | 存储引擎的名称。 |
SUPPORT | 引擎是否为默认引擎,或是否被支持。 |
COMMENT | 存储引擎的注释。 |
TRANSACTIONS | 引擎是否支持事务。 |
XA | 引擎是否支持XA事务。 |
SAVEPOINTS | 是否支持保存点。 |
它提供了与SHOW ENGINES
语句相同的信息。由于存储引擎是插件,有关它们的不同信息也显示在information_schema.PLUGINS
表和SHOW PLUGINS
语句中。
该表不是标准的信息模式表,而是MySQL和MariaDB的扩展。
请注意,MySQL的InnoDB和Percona的XtraDB替代方案都标记为InnoDB
。但是,如果使用了XtraDB,则会在COMMENT
字段中指定。请参阅XtraDB和InnoDB。FederatedX也是如此。
示例
SELECT * FROM information_schema.ENGINES\G; *************************** 1. row *************************** ENGINE: InnoDB SUPPORT: DEFAULT COMMENT: Supports transactions, row-level locking, and foreign keys TRANSACTIONS: YES XA: YES SAVEPOINTS: YES *************************** 2. row *************************** ENGINE: CSV SUPPORT: YES COMMENT: CSV storage engine TRANSACTIONS: NO XA: NO SAVEPOINTS: NO *************************** 3. row *************************** ENGINE: MyISAM SUPPORT: YES COMMENT: MyISAM storage engine TRANSACTIONS: 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: FEDERATED SUPPORT: YES COMMENT: FederatedX pluggable storage engine TRANSACTIONS: YES XA: NO SAVEPOINTS: YES *************************** 6. row *************************** ENGINE: MRG_MyISAM SUPPORT: YES COMMENT: Collection of identical MyISAM tables TRANSACTIONS: NO XA: NO SAVEPOINTS: NO *************************** 7. row *************************** ENGINE: ARCHIVE SUPPORT: YES COMMENT: Archive storage engine TRANSACTIONS: NO XA: NO SAVEPOINTS: NO *************************** 8. row *************************** ENGINE: MEMORY SUPPORT: YES COMMENT: Hash based, stored in memory, useful for temporary tables TRANSACTIONS: NO XA: NO SAVEPOINTS: NO *************************** 9. row *************************** ENGINE: PERFORMANCE_SCHEMA SUPPORT: YES COMMENT: Performance Schema TRANSACTIONS: NO XA: NO SAVEPOINTS: NO *************************** 10. row *************************** ENGINE: Aria SUPPORT: YES COMMENT: Crash-safe tables with MyISAM heritage TRANSACTIONS: NO XA: NO SAVEPOINTS: NO 10 rows in set (0.00 sec)
检查给定的存储引擎是否可用:
SELECT SUPPORT FROM information_schema.ENGINES WHERE ENGINE LIKE 'tokudb'; Empty set
检查哪个存储引擎支持XA事务:
SELECT ENGINE FROM information_schema.ENGINES WHERE XA = 'YES'; +--------+ | ENGINE | +--------+ | InnoDB | +--------+
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.