MySQL won't stop doing stuff
Posted
by Felix
on Server Fault
See other posts from Server Fault
or by Felix
Published on 2010-04-02T12:09:51Z
Indexed on
2010/04/02
12:13 UTC
Read the original article
Hit count: 287
mysql
Sorry for the title of the question, here's my problem: I've been trying to set up some scripts that import a lot of stuff hourly from an external source. They seemed to work fine, so I set up a cronjob to run them every hour. One day later I find six or seven instances of that script just hogging the MySQL server, making it unresponsive. I killed their processes, but MySQL was still not responding. I had to kill MySQL, reboot and then MySQL started working again (who knows on what) and being unresponsive (yes, I did remove the scripts from the cronjobs). I SHOW PROCESSLIST
ed and killed every process I could find. Still nothing, MySQL is hogging the HDD and is at the top of top
and making the server load go up in the sky. I don't know what to do, if I kill and start it again it will probably do the same thing. What should I do?
© Server Fault or respective owner