Apache and Mysql deadlock

[bdj]

My DA server has been running smooth for quite some time when I used it with only 1 reseller account (myself). Now i've added another reseller account for a friend.

In this account he has a wordpress site which sometimes get's a whole lot of requests in a short period of time. This results in the entire server being locked up. I can't access it with SSH and DA is not responding.

What happens is that apache creates allot of pids which open allod of mysql connections and all the internal memory is used, than all the swap is used. It's basicly deadlocked. After that I have to reset the power to reboot.

I want to limit either his domain or his account to prevent this but this is so new to me I can't figure out where to start.

Can anyone give me a little direction?

Thanks

 

[bdj]

I'm trying to fix this problem with jeff's httpd restart script

 

[nobaloney]

You may not want to leave open MySQL processes when you restart httpd; you may want to rewrite the script so it shuts down mysal, restarts apache, and then restarts mysql.

Inevitably you could lose data. If the wordpress site draws that many resources you may find it necessary to give it more resources (perhaps it's own server).

Busy wordpress sites do use a lot of data.

Jeff