Possible Solution for Issue with MYSQL hanging

RLJB

This post may help others (and is a selfish post so I can check it again in a year when I get this next):

We were suffering server instability as follows:

People couldn't login or use system
No errors were showing in logs
Both Tomcat and Aware Server were still running

We managed to narrow it down to a user upload, on a multi doc upload, causing the problem. It was a doc of reasonable size (5mb) but we had increased allowed packet size in MySQL my.conf to deal with it so we didn't initially think this could ne the problem. We then discovered errors in the MySQL log as follows:

ERROR: the age of the last checkpoint is 9445469, which exceeds the log group capacity 9433498.

tford

In case the linked article is no longer there later:

The error message means that you're trying to insert too much data into InnoDB too quickly, and the InnoDB log is filling up before the data can be flushed into the main data files.

To solve it, you need to stop MySQL cleanly (very important), delete the existing InnoDB log files (probably lb_logfile* in your MySQL data directory, unless you've moved them), then adjust the innodb_log_file_size to suit your needs, and then start MySQL again. This article from the MySQL performance blog might be instructive.

The article linked above would be difficult to copy here, so here the link:
https://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/

itdeptcorp

Nice post!