[MySQL] viewing storage engines

View engine Information System Information centos6.2 MySQL 5.1.69

#1 View All engines
 

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 display the storage engine of a table

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)

! Have you seen engine = MyISAM?

#3 view the current default Engine

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