1. 查看Mysql Server已提供什么存储引擎:
mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
| ndbcluster | DEFAULT | Clustered, fault-tolerant tables | YES | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MyISAM | YES | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)
2. 查看Mysql Server当前缺省的存储引擎:
mysql> show variables like '%storage_engine%';
+----------------+------------+
| Variable_name | Value |
+----------------+------------+
| storage_engine | ndbcluster |
+----------------+------------+
1 row in set (0.00 sec)
3. 某个表用了什么引擎
mysql> show create table aaapolicy/G
*************************** 1. row ***************************
Table: aaapolicy
Create Table: CREATE TABLE `aaapolicy` (
`id` int(11) NOT NULL,
`name` varchar(64) NOT NULL,
`checklist` varchar(1024) DEFAULT NULL,
`replylist` varchar(1024) DEFAULT NULL,
PRIMARY KEY (`id`) USING HASH,
UNIQUE KEY `aaapolicy_key` (`name`) USING HASH
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.01 sec)
4. 查看Mysql Server缺省isolation level
mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;+-----------------------+----------------+| @@GLOBAL.tx_isolation | @@tx_isolation |+-----------------------+----------------+| READ-COMMITTED | READ-COMMITTED |+-----------------------+----------------+1 row in set (0.00 sec)