天天看點

mysql error

遇到一個mysql的錯誤!

120822  2:37:33  InnoDB: ERROR: the age of the last checkpoint is 9437013,

InnoDB: which exceeds the log group capacity 9433498.

InnoDB: If you are using big BLOB or TEXT rows, you must set the

InnoDB: combined size of log files at least 10 times bigger than the

InnoDB: largest such row.

google了一下說是innodb_log_file_size參數設定太小!

當時因為是開發用的資料庫,沒有修改這個參數大小,預設是5M,資料庫裡面包含text/blob的字段,超出了這個參數的大小,導緻出錯!

這個應該修改參數的大小,先轉移日志檔案ib_logfile0/1.。。然後修改my.cnf檔案,重新開機伺服器!