首先通过命令行查看一下mysql的存储引擎

mysql> show ENGINES;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       | | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         | | MyISAM             | YES     | MyISAM storage engine                                          | 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         | | ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         | | InnoDB             | DEFAULT | Supports transactions, row-level locking, and foreign keys     | YES          | YES  | YES        | | PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ 9 rows in set (0.00 sec)

这个是我本地看的，不大明显，找了个网上的图片

可以看到mysql的引擎以及各个引擎的情况

如果查看mysql现在使用的那个引擎，可以利用命令

show variables like 'storage_engine'

mysql> show variables like 'storage_engine';

+----------------+--------+ | Variable_name  | Value  | +----------------+--------+ | storage_engine | InnoDB | +----------------+--------+ 1 row in set (0.00 sec)

可以看出使用的是InnoDB引擎

如何查看表的引擎

mysql> show table status from fmcm_test where name='xadmin_userwidget';

+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | Name              | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time | Check_time | Collation       | Checksum | Create_options | Comment | +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | xadmin_userwidget | InnoDB |      10 | Compact    |    0 |              0 |       16384 |               0 |        16384 |         0 |              1 | 2016-06-16 05:57:12 | NULL        | NULL       | utf8_general_ci |     NULL |                |         | +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec)

可以看出使用的是InnoDB引擎

如果需要转还表的引擎，可以使用alter table mytable ENGINE=InnoDB

如下

mysql> alter table xadmin_userwidget ENGINE='MyISAM'

    -> ; Query OK, 0 rows affected (0.03 sec) Records: 0  Duplicates: 0  Warnings: 0

改变引擎成功，

现在在查看一下该表的引擎

mysql> show table status from fmcm_test where name= 'xadmin_userwidget';

+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name              | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time | Collation       | Checksum | Create_options | Comment | +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | xadmin_userwidget | MyISAM |      10 | Dynamic    |    0 |              0 |           0 | 281474976710655 |         1024 |         0 |              1 | 2017-01-13 13:06:34 | 2017-01-13 13:06:34 | NULL       | utf8_general_ci |     NULL |                |         | +-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ 1 row in set (0.00 sec)

可以看出来引擎那一选项已经改为MyISAM引擎。

在mysql中没有规定服务器一定要使用一种引擎，可以针对不同的表使用不同的引擎，在SUPPORT列中如果是YES表示可以使用，No表示不可以使用，DEFAULT表示默认的引擎

待续