读书人

mysql innodb 引擎初始化异常

发布时间: 2012-08-28 12:37:01 作者: rapoo

mysql innodb 引擎初始化错误

错误日志:

?

InnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Compressed tables use zlib 1.2.3110613 22:47:59  InnoDB: Initializing buffer pool, size = 1.0G110613 22:47:59  InnoDB: Completed initialization of buffer poolInnoDB: 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 backInnoDB: to what it was, and remove the new ibdata files InnoDB createdInnoDB: in this failed attempt. InnoDB only wrote those files full ofInnoDB: zeros, but did not yet use them in any way. But be careful: do notInnoDB: 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

?

读书人网 >其他数据库

热点推荐