現(xiàn)象:?
centos服務器異常斷電MySQL啟動異常啟動Mysql時報錯: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、存儲引擎錯誤?
Unknown/unsupported storage engine: InnoDB?
2、檢查一下配置文件中關于innodb的參數(shù),如果有skip-innodb注釋掉?
3、如果重新設置了innodb_log_file_size之類的,?
4、需?刪除幾個rm -rf ib_logfile,然后重啟數(shù)據(jù)庫
聲明:所有內(nèi)容來自互聯(lián)網(wǎng)搜索結(jié)果,不保證100%準確性,僅供參考。如若本站內(nèi)容侵犯了原著者的合法權(quán)益,可聯(lián)系我們進行處理。