posted by Mohammad Lahlouh
on
Sun 19 Jul 2009 08:56 UTC
Tags:
In one of the servers we have an issue that happens to one of the servers that some items
that have the status of "freeing items" and "Sending data" are just stuck there, causing a
lot of locks on the server, and the load of the server drops to almost 0.
The server then wouldn't restart, and the only solution is to kill the mysqld process, and
fix the crashed tables that result from the kill.