mysql innodb 引擎初始化错误

最新推荐文章于 2024-10-09 11:12:52 发布

大大柳树

最新推荐文章于 2024-10-09 11:12:52 发布

阅读量476

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql 文章标签： MySQL GCC

本文链接：https://blog.youkuaiyun.com/zbwangchao/article/details/83945852

Mysql 专栏收录该内容

51 篇文章

订阅专栏

错误日志：

InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110613 22:47:59  InnoDB: Initializing buffer pool, size = 1.0G
110613 22:47:59  InnoDB: Completed initialization of buffer pool
InnoDB: Error: data file /data1/mysqldata/mysql5.1.57/innodb_data/ibdata1 is of a different size
（数据文件大小错误，重新配置innodb数据文件大小引起的初始化失败，）


InnoDB: 640 pages (rounded down to MB)
InnoDB: than specified in the .cnf file 128000 pages!
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
110613 22:47:59 [ERROR] Plugin 'InnoDB' init function returned error.
110613 22:47:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

删除innodb 数据文件 ibdata1