I have a VPS server. There are about 20 sites hosted on it. The sites become inaccessible every 10 minutes or so. I run "top" and it shows that it's MySQL that's taking up the resources.

How can I find out which script and on which site sucks the resources?