MySQL修改配置文件增加表空间个数导致系统无法启动[转]

最新推荐文章于 2023-10-27 14:29:06 发布

转载最新推荐文章于 2023-10-27 14:29:06 发布 · 256 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.chinaunix.net/uid-77311-id-5765710.html

文章标签：

#mysql

MySQL 专栏收录该内容

13 篇文章

订阅专栏

本文解决了一个关于MySQL启动时遇到的InnoDB数据文件大小配置不一致的问题，详细介绍了如何调整my.cnf中innodb_data_file_path参数，以匹配实际的ibdata1文件大小，避免启动错误。

修改配置文件启动MySQL报错:

2017-05-31T10:31:05.945111Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata2'.
2017-05-31T10:31:05.945126Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata3'.
2017-05-31T10:31:05.945131Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata4'.
2017-05-31T10:31:05.945162Z 0 [ERROR] InnoDB: The innodb_system data file '/opt/mysql5718/data/ibdata1' is of a different size 768 p
ages (rounded down to MB) than the 6400 pages specified in the .cnf file!
2017-05-31T10:31:05.945171Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-05-31T10:31:06.545674Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-05-31T10:31:06.545710Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-31T10:31:06.545716Z 0 [ERROR] Failed to initialize plugins.
2017-05-31T10:31:06.545722Z 0 [ERROR] Aborting

实际ibdata1文件大小:

[mysql@izwz9gxsbwybwg9n5xdi47z data]$ ls -al ibdata1
-rw-r----- 1 mysql mysql 12582912 May 31 18:45 ibdata1

配置文件ibdata文件大小:

innodb_data_home_dir=/opt/mysql5718/data
innodb_data_file_path=ibdata1:100M;ibdata2:100M;ibdata3:100M;ibdata4:100M:autoextend

解决办法：

可以看到修改ibdata1大小跟实际的不一样(different size 768 pages (rounded down to MB) than the 6400 pages specified in the .cnf file!),导致报错误.

768/64=12M			#1 page = 1/64M

修改my.cnf文件参数如下innodb_data_file_path
innodb_data_file_path=ibdata1:12M;ibdata2:100M;ibdata3:100M;ibdata4:100M:autoextend

systemctl restart mysqld
重新启动,问题解决.