mysql 存储引擎 ppt_MySQL 存储引擎

mysql>show engines \G;*************************** 1. row ***************************Engine: InnoDB

Support:DEFAULTComment: Supports transactions, row-level locking, and foreignkeys

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: PERFORMANCE_SCHEMA

Support: YES

Comment: PerformanceSchemaTransactions: NO

XA: NO

Savepoints: NO*************************** 4. row ***************************Engine: BLACKHOLE

Support: YES

Comment:/dev/null storage engine (anything you write toit disappears)

Transactions: NO

XA: NO

Savepoints: NO*************************** 5. row ***************************Engine: MyISAM

Support: YES

Comment: MyISAM storage engine

Transactions: NO

XA: NO

Savepoints: NO*************************** 6. row ***************************Engine: MRG_MYISAM

Support: YES

Comment: Collectionofidentical 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, storedin memory, useful for temporarytables

Transactions: NO

XA: NO

Savepoints: NO*************************** 9. row ***************************Engine: FEDERATED

Support: YES

Comment: Federated MySQL storage engine

Transactions: NO

XA: NO

Savepoints: NO9 rows in set (0.00 sec)