Basically you want to look at the “show engine innodb status \G” that you know is capturing the issue. Assuming the number of connections that triggered the data being captured is accurate, then the first entry in the log will likely show what is causing the backup. So just cut out the first entire “show engine innodb status \G” section from the log file.