[ERROR] InnoDB: ibdata1 different size (rounded down to MB)

張衝andy發表於2018-08-31

啟動mysql例項報錯,檢視 error log

## 錯誤資訊
2018-08-31T10:38:36.945081Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 1536 pages, max 0 (relevant if non-zero) pages!


解決過程:

768/64=12

檢視 my.cnf 檔案 將
innodb_data_file_path = ibdata1:24M:autoextend

改為

innodb_data_file_path = ibdata1:12M:autoextend

再次啟動成功!


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31383567/viewspace-2213293/,如需轉載,請註明出處,否則將追究法律責任。

相關文章