一台MySQL slave 由于需要把服务重启了一次,用ps -ef |grep mysql时发现没有进程,看日志发现
InnoDB: You may have to recover from a backup. InnoDB: It is also possible that your operating InnoDB: system has corrupted its own file cache InnoDB: and rebooting your computer removes the InnoDB: error. InnoDB: If the corrupt page is an index page InnoDB: you can also try to fix the corruption InnoDB: by dumping, dropping, and reimporting InnoDB: the corrupt table. You can use CHECK InnoDB: TABLE to scan your table for corruption. InnoDB: See also http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html InnoDB: about forcing recovery. InnoDB: Ending processing because of a corrupt database page. 100317 05:26:54 mysqld_safe Number of processes running now: 0 100317 05:26:54 mysqld_safe mysqld restarted 在my.cnf添加innodb_force_recovery = 4 后仍然是这个错误,一时没有找到相关解决方法,只能从另一台slave把mysql目录copy到这台机器重新同步