??????????????MySQL ?洢???棬??????????:
????????
????????????????????????????????洢???漰????????????????????????????mysql??洢???檔
?????ο??????mysql5.7
??????????洢????
????mysql> show 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: PERFORMANCE_SCHEMA
????Support: YES
????Comment: Performance Schema
????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: MyISAM
????Support: YES
????Comment: MyISAM storage engine
????Transactions: NO
????XA: NO
????Savepoints: NO
????*************************** 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: FEDERATED
????Support: YES
????Comment: Federated MySQL storage engine
????Transactions: NO
????XA: NO
????Savepoints: NO
????9 rows in set (0.00 sec)
????Supports??????????(YES)???????(NO)????????洢???檔
???????
??????5.7???innodb?洢??????????洢???檔
?????????
?????????http://www.cnblogs.com/chenmh