job/mysql
mysql log file size error
시스템엔지니어
2019. 6. 26. 17:42
190329 19:47:38 InnoDB: ERROR: the age of the last checkpoint is 13637149,
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.
참고
iib_logfiib_logfile 0이랑 1 mv로 옮겨두고
innodb_log_file_size = 52428800 (my.cnf에는 아무 설정 안돼있고 디폴트는 5242880 인데 0 하나 더 줌)
그리고 mysql 재시작