问题:
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
修改my.cnf文件参数如下innodb_data_file_path
innodb_data_file_path=ibdata1:12M;ibdata2:100M;ibdata3:100M;ibdata4:100M:autoextend
重新启动,问题解决.
阅读(8418) | 评论(0) | 转发(0) |