InnoDB存储引擎 - 常见问题修复

错误1：InnoDB: Error: page 19 log sequence number 2363194248

InnoDB: is in the future! Current system log sequence number 78250719.

InnoDB: Your database may be corrupt or you may have copied the InnoDB

InnoDB: tablespace but not the InnoDB log files.

解决方法: 在server没有任何备份的情况下，只能强迫innodb自己恢复

you can add the following line to the 110216 9:48:41 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 33554432 bytes!
110216 9:48:41 [ERROR] Plugin ‘InnoDB‘ init function returned error.
110216 9:48:41 [ERROR] Plugin ‘InnoDB‘ registration as a STORAGE ENGINE failed.


解决方法：          

1. SET GLOBAL innodb_max_dirty_pages_pct = 0; （dirty page听我同事解释说是内存数据）

   By default,  is 75 (MySQL 5.5+) or 90 (prior to MySQL 5.5). Setting this to zero keeps the number of dirty pages under 1% of the InnoDB Buffer Pool. Performing service mysql stop, does this anyway. In addition, a shutdown will finish up any remaining items in the redo log. 

   我在用google搜索，发现下面这个链接，有很多mysql问题的汇总

   


   本文出自 “” 博客，请务必保留此出处