MySQL?洢????
?????pursuer.chen ???????[ 2016/9/2 10:37:15 ] ????????????? MySQL ?洢????
??????????????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
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11