| 1 | *************************** 1. row *************************** |
|---|
| 2 | Engine: ndbcluster |
|---|
| 3 | Support: NO |
|---|
| 4 | Comment: Clustered, fault-tolerant tables |
|---|
| 5 | Transactions: NULL |
|---|
| 6 | XA: NULL |
|---|
| 7 | Savepoints: NULL |
|---|
| 8 | *************************** 2. row *************************** |
|---|
| 9 | Engine: MRG_MYISAM |
|---|
| 10 | Support: YES |
|---|
| 11 | Comment: Collection of identical MyISAM tables |
|---|
| 12 | Transactions: NO |
|---|
| 13 | XA: NO |
|---|
| 14 | Savepoints: NO |
|---|
| 15 | *************************** 3. row *************************** |
|---|
| 16 | Engine: CSV |
|---|
| 17 | Support: YES |
|---|
| 18 | Comment: CSV storage engine |
|---|
| 19 | Transactions: NO |
|---|
| 20 | XA: NO |
|---|
| 21 | Savepoints: NO |
|---|
| 22 | *************************** 4. row *************************** |
|---|
| 23 | Engine: MyISAM |
|---|
| 24 | Support: DEFAULT |
|---|
| 25 | Comment: Default engine as of MySQL 3.23 with great performance |
|---|
| 26 | Transactions: NO |
|---|
| 27 | XA: NO |
|---|
| 28 | Savepoints: NO |
|---|
| 29 | *************************** 5. row *************************** |
|---|
| 30 | Engine: InnoDB |
|---|
| 31 | Support: YES |
|---|
| 32 | Comment: Supports transactions, row-level locking, and foreign keys |
|---|
| 33 | Transactions: YES |
|---|
| 34 | XA: YES |
|---|
| 35 | Savepoints: YES |
|---|
| 36 | *************************** 6. row *************************** |
|---|
| 37 | Engine: MEMORY |
|---|
| 38 | Support: YES |
|---|
| 39 | Comment: Hash based, stored in memory, useful for temporary tables |
|---|
| 40 | Transactions: NO |
|---|
| 41 | XA: NO |
|---|
| 42 | Savepoints: NO |
|---|
