问题描述
我无法设置系统变量 table_type.当我尝试这样做时,我收到以下错误.
I am unable to set the system variable table_type. When I try to do so I get the following error.
mysql> SET table_type=InnoDB;
ERROR 1193 (HY000): Unknown system variable 'table_type'
我发现在执行SHOW VARIABLES"时未列出table_type".这是设置问题吗?
I see that "table_type" is not listed when I do a "SHOW VARIABLES". Is this a setup issue?
为了安装 mysql,我只是在 Amazon EC2 实例上执行了sudo yum install mysql mysql-server mysql-libs".
To install mysql I just did a "sudo yum install mysql mysql-server mysql-libs" on Amazon EC2 instance.
推荐答案
来自 文档:
这个变量在 MySQL 5.5.3 中被删除了.改用 storage_engine.
This variable was removed in MySQL 5.5.3. Use storage_engine instead.
反过来说:
从 MySQL 5.5.3 开始不推荐使用此变量.请改用 default_storage_engine.
This variable is deprecated as of MySQL 5.5.3. Use default_storage_engine instead.
因此您应该使用 SET default_storage_engine=InnoDB
,这是自 MySQL 5.5.5 以来的默认值.
Therefore you should use SET default_storage_engine=InnoDB
, which FWIW is the default since MySQL 5.5.5.
这篇关于mysql 系统变量 table_type 不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!