MySQL 的 Error log 出現:
InnoDB: ERROR: the age of the last checkpoint is 122123,
InnoDB: which exceeds the log group capacity 122123.
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.
解決方式:
1.調大以下三個參數(vi my.cnf)
innodb_log_buffer_size
innodb_buffer_pool_size
innodb_log_file_size
2.shutdown mysql
ssh# mysqladmin shutdown -uroot -p
Enter password:
3.將 ib_logfile* 刪除
ssh# cd /var/db/mysql
ssh# rm ib_logfile0
ssh# rm ib_logfile1
4.start mysql
ssh# /usr/local/bin/mysqld_safe &
沒有留言:
張貼留言