Hi all,
I'm seeing very high loads (around 12 or 13) on our DPM MySQL server.
This seems to be causing timeouts when DPM is requesting information
as I am seeing lots or errors like:
160425 12:05:17 [ERROR] /usr/libexec/mysqld: Lock wait timeout
exceeded; try restarting transaction
160425 12:05:17 [ERROR] /usr/libexec/mysqld: Sort aborted
in /var/log/mysqld.log
Does anyone have any ideas about how I can start debugging this?
This is similar to the errors I was seeing a few months ago but I have
seen none of them since then. I have been draining some of our disks
this last week so it's possible that it pushed it over the edge.
Cheers,
Matt
|