MySQL 儲存引擎

標籤：

介紹

接下來幾篇文章會詳細介紹幾種常用的儲存引擎及適合情境。這篇文章就先來大概瞭解一下mysql的儲存引擎。  

參考說明：mysql5.7

 

 

查看支援的儲存引擎

mysql> show engines \G;*************************** 1. row ***************************      Engine: InnoDB     Support: DEFAULT     Comment: Supports transactions, row-level locking, and foreign keysTransactions: YES          XA: YES  Savepoints: YES*************************** 2. row ***************************      Engine: CSV     Support: YES     Comment: CSV storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 3. row ***************************      Engine: PERFORMANCE_SCHEMA     Support: YES     Comment: Performance SchemaTransactions: 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: MyISAM     Support: YES     Comment: MyISAM storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 6. row ***************************      Engine: MRG_MYISAM     Support: YES     Comment: Collection of identical MyISAM tablesTransactions: NO          XA: NO  Savepoints: NO*************************** 7. row ***************************      Engine: ARCHIVE     Support: YES     Comment: Archive storage engineTransactions: NO          XA: NO  Savepoints: NO*************************** 8. row ***************************      Engine: MEMORY     Support: YES     Comment: Hash based, stored in memory, useful for temporary tablesTransactions: NO          XA: NO  Savepoints: NO*************************** 9. row ***************************      Engine: FEDERATED     Support: YES     Comment: Federated MySQL storage engineTransactions: NO          XA: NO  Savepoints: NO9 rows in set (0.00 sec)

 

Supports列說明了支援(YES),不支援(NO)和當前預設的儲存引擎。

各種儲存引擎說明

 

 

 

總結

從5.7開始innodb儲存引擎成為預設的儲存引擎。

 

 

 

 

 

備忘：     pursuer.chen     部落格：http://www.cnblogs.com/chenmh 本網站所有隨筆都是原創，歡迎大家轉載；但轉載時必須註明文章來源，且在文章開頭明顯處給明連結。 《歡迎交流討論》

MySQL 儲存引擎