Re: MySQL Falling over - InnoDB locks

[placid]

Here's the scenario:

1) I'm editing my wiki - going back and forth with edits, saves etc (Note: this is mediawiki)

2) The site stops responding (note: mysql is not replying)

3) MySQL does not allow connections from PHP or mysqladmin - I get the classic 'cannot open socket /tmp/blah' (which you get when MySQL isn't even running).

Here's the weird bit:

/etc/init.d/mysql stop - fails
/etc/init.d/mysql start - fails

NOTHING in the logs, both /var/log/mysql.err or /var/log/mysql.log

Issuing `killall mysqld` runs fine, and *now mysql responds and works perfectly*
Note: Before I run this, there is only one mysqld process running - compared to plenty when it's working properly.

Thanks for your reply!



Edited 1 time(s). Last edit at 02/22/2007 08:48AM by placid.