1
|
SHOW ENGINES;
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
mysql> SHOW ENGINES\G
*************************** 1. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
Transactions: NO
XA: NO
Savepoints: NO
*************************** 2. row ***************************
Engine: InnoDB
Support: DEFAULT
Comment: Supports transactions, row-level locking, and foreign keys
Transactions: YES
XA: YES
Savepoints: YES
*************************** 3. row ***************************
Engine: MyISAM
Support: YES
Comment: MyISAM 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
8 rows
in
set
(0.11 sec)
|
1
|
SHOW VARIABLES LIKE
'storage_engine'
;
|
1
2
3
4
5
6
7
|
mysql> SHOW VARIABLES LIKE
'storage_engine'
;
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | InnoDB |
+----------------+--------+
1 row
in
set
(0.10 sec)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
mysql> USE hellodb
Database changed
mysql> SHOW TABLE STATUS\G
*************************** 7. row ***************************
Name: toc
Engine: MyISAM
Version: 10
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 2533274790395903
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2013-08-12 16:17:23
Update_time: 2013-08-12 16:17:23
Check_time: NULL
Collation: utf8_general_ci
Checksum: NULL
Create_options:
Comment:
|
-
InnoDB存储引擎
-
MyISAM存储引擎
-
ARCHIVE
-
CSV
-
BLACKHOME
-
FEDERATED
-
MEMORY存储引擎
-
MRG_MYISAM
-
扩展一些第三方存储引擎