Hello!
Here is my story:
We have a site which run free mail system on perl and mysql. Everything works fine, but couple times per day mysql seems to hang up. Load avarage get up to 10... I can't figure out what couse this situation. There is no unexpected flood of incoming mail or crouds of users reading their mail...
After about ten minutes it aborts all it's threads or comleat requsts and returns to normal operation. What should i do to investigate the situation? Anybody nows some general approaches to solve probles like this?