G’day All,
Am having an issue where my site freezes every night at the same time daily. The only thing I can make out is that there seems to be a backlog of mySQL transactions and commits. An example of some of the log entries in this time period is shown below:
120107 22:34:54InnoDB: Warning: cannot find a free slot for an undo log. Do you have too
InnoDB: many active transactions running concurrently?
120107 22:34:54InnoDB: Warning: cannot find a free slot for an undo log. Do you have too
InnoDB: many active transactions running concurrently?
120109 13:50:40 InnoDB: ERROR: the age of the last checkpoint is 120792770,
InnoDB: which exceeds the log group capacity 120792269.
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.
120110 9:27:04 InnoDB: ERROR: the age of the last checkpoint is 120792284,
InnoDB: which exceeds the log group capacity 120792269.
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.
Would anyone have an idea how to get to the root cause of this issue - am stumped after going through the various configs and scenarios.
TIA.