遇到一個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檔案,重新開機伺服器!