[ERROR] InnoDB: ibdata1 different size (rounded down to MB)
啟動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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a differentMySql
- MySQL innodb_buffer_pool_size 變數MySql變數
- ibdata1檔案損壞時恢復InnoDB單表測試
- ubuntu 命令列更改innodb_buffer_pool_sizeUbuntu命令列
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- 如何選擇配置 MySQL innodb_log_file_sizeMySql
- MySQL服務端innodb_buffer_pool_size配置引數MySql服務端
- 3.5 Different
- local.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728ErrorException
- mysql 啟動錯誤(InnoDB: Operating system error number 13 )MySqlError
- different random numbers generatorrandom
- 2.3.3.3.2 Applications at Different VersionsAPP
- 11.23 Two Different Worlds
- [ERROR] [MY-012872] [InnoDB] [FATAL] Semaphore wait has lasted > 600 secondsErrorAIAST
- mysql ibdata1太大的原因MySql
- 帝國CMSr的Fatal error:Allowed memory size of的解決辦法Error
- 帝國cms網站Fatal error: Allowed memory size of … bytes exhausted怎麼辦？網站Error
- 帝國CMS更新時提示Fatal error: Allowed memory size of的解決方法Error
- CF1408F Two Different
- 3.3 Shutting Down a DatabaseDatabase
- SDXL Error : "The shape of the 2D attn_mask is torch.Size([77, 77]), but should be (1, 1)"Error
- MySQL 5.7從庫報錯exceeds of slave_pending_jobs_size_max. Error_code: 1864MySqlError
- Script of Narrative Writing from different point of viewView
- 3.3.4 Shutting Down with the Transactional Mode
- check memcached process and restart if downREST
- Mbps和Mb/s
- mysql中的utf8mb4、utf8mb4_unicode_ci、utf8mb4_general_ciMySqlUnicode
- CF917E Upside DownIDE
- 21：Count Down設計模式設計模式
- [20190706]Same dog, different leash – functions in SQL.txtFunctionSQL
- ATX 報錯-32001 Jsonrpc error: <java.lang.StackOverflowError> data: java.lang.StackOverflowError: stack size 1041KBJSONRPCErrorJava
- ASM DG Usable_file_MB和Req_mir_free_MB的含義ASM
- gitignore by file size?Git
- 4-bit shift register and down counter
- PHP之mb_substr使用PHP
- php的strpos-mb_strposPHP
- Index column size too large. The maximum column size is 767 bytes.Index
- 手把手教你做閱讀理解題-初中中考閱讀理解解題技巧009-There are many different parts that have different jobs