mysql --force 无效_使用innodb_force_recovery解决MySQL崩溃无法重启问题

一 背景

某一创业的朋友的主机因为磁盘阵列损坏机器crash,重启MysqL服务时 报如下错误:

InnoDB: Reading tablespace information from the .ibd files...

InnoDB: Restoring possible half-written data pages from the doublewrite

InnoDB: buffer...

InnoDB: Doing recovery: scanned up to log sequence number 9120034833

150125 16:12:51 InnoDB: Starting an apply batch of log records to the database...

InnoDB: Progress in percents: 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 150125 16:12:51 [ERROR] MysqLd got signal 11 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt,improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug,see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up so