解決centos服務(wù)器異常斷電mysql啟動(dòng)異常啟動(dòng)Mysql時(shí)報(bào)錯(cuò)
現(xiàn)象:
centos服務(wù)器異常斷電MySQL啟動(dòng)異常啟動(dòng)Mysql時(shí)報(bào)錯(cuò):mysqld_safe mysqld from pid file /usr/local/mysql/Linux.pid end
但是打開日志文件 查看
InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 50331648 bytes
InnoDB: than specified in the .cnf file 5242880 bytes!
160603
[ERROR] Plugin ‘InnoDB’ init function returned error.
160603
14:06:15 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
160603
14:06:15 [ERROR] Unknown/unsupported storage engine: InnoDB
160603 14:06:15 [ERROR] Aborting
處理方案:
1、存儲(chǔ)引擎錯(cuò)誤
Unknown/unsupported storage engine: InnoDB
2、檢查一下配置文件中關(guān)于innodb的參數(shù),如果有skip-innodb注釋掉
3、如果重新設(shè)置了innodb_log_file_size之類的,
4、需?刪除幾個(gè)rm -rf ib_logfile,然后重啟數(shù)據(jù)庫(kù)