--查看默认引擎
mysql> show variables like 'storage_engine';
+----------------+--------+
| Variable_name | Value |
+----------------+--------+
| storage_engine | InnoDB |
+----------------+--------+
1 row in set (0.00 sec)

--修改引擎
vi /etc/my.cnf
[mysqld]
添加或修改 default-storage-engine=INNODB

修改完后要重新启动mysql
/etc/init.d/mysql stop
/etc/init.d/mysql start

MySQL引擎