MySQL查看及修改默认存储引擎

查看存储引擎

mysql> SHOW VARIABLES LIKE 'default_storage_engine%';

修改存储引擎

临时修改

mysql>SET default_storage_engine=<存储引擎名>
如
mysql>SET default_storage_engine=MyISAM

mysql> SHOW VARIABLES LIKE 'default_storage_engine%';
+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| default_storage_engine | InnoDB |
+------------------------+--------+
1 row in set (0.00 sec)

mysql> SET default_storage_engine=MyISAM;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'default_storage_engine%';
+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| default_storage_engine | MyISAM |
+------------------------+--------+
1 row in set (0.00 sec)

mysql>

永久修改

在my.cnf的mysqld中添加如下设置

[mysqld]
default-storage-engine=INNODB
。。。其他配置。。。