[Mysql]查看儲存引擎

查看引擎資訊  系統資訊 centos6.2  mysql 5.1.69  

#1 查看所有引擎
 

mysql> show engines;+------------+---------+------------------------------------------------------------+--------------+------+------------+| Engine     | Support | Comment                                                    | Transactions | XA   | Savepoints |+------------+---------+------------------------------------------------------------+--------------+------+------------+| MRG_MYISAM | YES     | Collection of identical MyISAM tables                      | NO           | NO   | NO         || CSV        | YES     | CSV storage engine                                         | NO           | NO   | NO         || MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great performance     | NO           | NO   | NO         || InnoDB     | YES     | Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        || MEMORY     | YES     | Hash based, stored in memory, useful for temporary tables  | NO           | NO   | NO         |+------------+---------+------------------------------------------------------------+--------------+------+------------+5 rows in set (0.00 sec)

#2顯示某個表的儲存引擎

mysql> show create table auth_group; +------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| Table      | Create Table                                                                                                                                                                               |+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| auth_group | CREATE TABLE `auth_group` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `name` varchar(80) NOT NULL,  PRIMARY KEY (`id`),  UNIQUE KEY `name` (`name`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 |+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+1 row in set (0.00 sec)

！看到 ENGINE=MyISAM 了嗎

#3 查看當前預設引擎

mysql> show variables like '%storage_engine%';+----------------+--------+| Variable_name  | Value  |+----------------+--------+| storage_engine | MyISAM |+----------------+--------+1 row in set (0.00 sec)