Ticket #7373: show.engines.txt

File show.engines.txt, 1.3 KB (added by fayoeu@…, 11 years ago)

Output of show engines.

Line 
1*************************** 1. row ***************************
2      Engine: ndbcluster
3     Support: NO
4     Comment: Clustered, fault-tolerant tables
5Transactions: NULL
6          XA: NULL
7  Savepoints: NULL
8*************************** 2. row ***************************
9      Engine: MRG_MYISAM
10     Support: YES
11     Comment: Collection of identical MyISAM tables
12Transactions: NO
13          XA: NO
14  Savepoints: NO
15*************************** 3. row ***************************
16      Engine: CSV
17     Support: YES
18     Comment: CSV storage engine
19Transactions: 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
26Transactions: 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
33Transactions: 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
40Transactions: NO
41          XA: NO
42  Savepoints: NO