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