Been looking for a long time, but not finding lots on it, soo hopefully you guys can assist.

I'm running a web server on fedora + plesk, and mysql, php4, apache

been finding an odd issue where if a bot from let's say google crawls on my server, my iowait goes to 90%, and average load hits up to the 70s and 80s... this only happens when port 80 is triggered (httpd) and a page triggers mysqld.

i can drop it down again by restarting the server or restarting mysql (sometimes it gives a connection to mysql server failed with /etc/init.d/mysqld restart) but what I am wanting to do is decipher which page is causing the issue so it can be resovled...

looking at the logs, they don't seem to say much (as to what page it visited, etc) so if anyone has an idea, would be great. I'm @ work right now, so will post my my.cnf, and/or whatever you guys need to resolve this when i get home, but would be great. thanks!

I would much rather see the output of `mysql -e "SHOW FULL PROCESSLIST"` during the time the problem was occurring, rather than seeing your my.cnf file.

sadly, another friend of mine decided to delete a g2 gallery mysql db and viola, the idle went back to it's nominal 90% instead of being in the iowait.. i could not get the list since it's now cleared up ;\ but it would be nice to know, what does mysql -e "SHOW FULL PROCESSLIST" do?

thanks!

ah... that would be helpful.. thanks! until the next time!

Do you have database statistics enabled in phpMyAdmin (if you are using phpMyAdmin) for any databases?
That can lead to an extremely large amount of data transfer between the web server and the SQL server.

Linux Archive

I am not sure, the db he deleted was a gallery2 (gallery.mentalo?) that was there, but he didn't update it or touch it for a while. thus he decided to just delete it..