[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錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytesError
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a differentMySql
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11MySqlError
- mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write modeMySqlError
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- The innodb_system data file 'ibdata1' must be writable
- MySQL innodb_buffer_pool_size 變數MySql變數
- ubuntu 命令列更改innodb_buffer_pool_sizeUbuntu命令列
- The connection to adb is down, and a severe error has occured.Error
- 如何選擇配置 MySQL innodb_log_file_sizeMySql
- ibdata1檔案損壞時恢復InnoDB單表測試
- error:unable to get logical block size for spfileErrorBloC
- 【MySQL】5.6.x InnoDB Error Table mysql.innodb_table_stats not foundMySqlError
- 【MySQL】ERROR 1799 (HY000) innodb_online_alter_log_max_size引數過小的一則caseMySqlError
- Android-The connection to adb is down, and a severe error has occuredAndroidError
- mysql引數之innodb_buffer_pool_size大小設定MySql
- AIX 6.1, ORACLE 11G LOCK_SGA, LAGE_PAGE_SIZE(16MB) IMPORTANT!!!AIOracleImport
- Our yoga instruction software are parajumpers sale roundedStruct
- Xtrbackup 備份過程報錯 Error: option 'datadir' has different values:Error
- InnoDB: Error: space id and page n:o stored in the page?Error
- set up different data screen(masterial master) for different userAST
- 【Mysql】Mysql額外記憶體池 innodb_additional_mem_pool_sizeMySql記憶體
- master bug InnoDB Error unlock row could not find a 4 mode lockASTError
- put it down?
- PHP Fatal error: Allowed memory size of 1610612736 bytesPHPError
- mysql 啟動錯誤(InnoDB: Operating system error number 13 )MySqlError
- MySQL5.7 線上調整Innodb_Buffer_Pool_size不用重啟mysql程式薦MySql
- different random numbers generatorrandom
- The connection to adb is down, and a severe error has occured(Android模擬器埠被佔用)ErrorAndroid
- local.ERROR: Symfony\Component\Debug\Exception\FatalErrorException: Allowed memory size of 134217728ErrorException
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- mysql ibdata1太大的原因MySql
- 2.3.3.3.2 Applications at Different VersionsAPP
- Upside DownIDE
- Mbps、Mb/s、MB/s之間是啥關係?
- substr(),mb_substr()及mb_strcut的區別和用法