我是新来的,希望有人能帮我解决MySQL问题。
我遇到了一个奇怪的情况,InnoDB不是默认存储引擎:
- MySQL版本14.14 Distrib 5.6.39,适用于Linux(x86_64),使用EditLine包装器。
- linux发行版:CentOS Linux release 7.5.1804(Core)
我已经尝试了几乎每一个使InnoDB成为默认引擎的解决方案,但都没有成功。
以下是我尝试过的一些方法:
步骤1
files my.cnf and my.ini. has been edited in /root/my.cnf and /root/my.ini and /etc/my.cnf as:
[mysqld]
character-set-server=utf8
collation-server=utf8_bin
default-storage-engine=INNODB
max_allowed_packet=256M
innodb_log_file_size=2GB
transaction-isolation=READ-COMMITTED
binlog_format=row
第二步,文件保存后,我以几种方式重新启动了MySQL:
Following commands DID NOT work:
# /etc/init.d/mysqld stop: No such file or directory
# /etc/init.d/mysql stop: No such file or directory
# service mysqld stop
Redirecting to /bin/systemctl start mysql.service
Failed to start mysqld.service: Unit not found.
Following commands DID work:
# service mysql stop
Redirecting to /bin/systemctl start mysql.service
# service mysql status (was Active: inactive (dead))
# service mysql start
Redirecting to /bin/systemctl start mysql.service
# service mysql status (was Active: active (running))
第三步
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 | DEFAULT | 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 | YES | 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>
第四步 我尝试了以下命令,最终将InnoDB设置为默认引擎,但仍然无法正常工作,因为一旦重置mysqld,它会重新变回MyISAM是默认引擎。
SET default_storage_engine=INNODB;
这真的很令人沮丧,非常感谢您的帮助。
InnoDB
代替INNODB
吗? - Anthony