IFDB keeps going down with one sleeping MySQL process and everyone else waiting for a lock

[dfabulich]

Several times this week, IFDB has gone down. curl -k --header "Host: ifdb.org" https://localhost/ times out on the local machine.

sudo mysql -e "SHOW PROCESSLIST\G" shows one sleeping process and a bunch of other processes waiting for a lock.

processlist.txt

I killed the sleeping process with sudo mysql -e "KILL 4723716;" and the site came back up.

[dfabulich]

I think this wouldn't have happened if we'd switched to InnoDB, but that will require a bunch of schema work.

• Convert from MyISAM to InnoDB #1016
• Add primary keys to every table #1017