On Wed, 26 Mar 2003, Lee Daniel Crocker wrote:
I just killed and restarted MySQL and Apache. Looks like we're still getting slammed, and the logs don't show anything like an out-of-control bot, so it looks like just ordinary heavy traffic.
Lee, in the future when mysqld is doing its thang all too well; could you try connecting (mysql -u root -p) and running a 'SHOW FULL PROCESSLIST'? This should show the life-sucking query (somewhere among the big huge list), and it is often possible to kill just that query using mysql's KILL command.
(Mysql supposedly always reserves one connection for root for emergency maintenance.)
If you already tried that and it didn't work, please ignore. :)
-- brion vibber (brion @ pobox.com)