Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

It happens quite often that my server goes down (from a few minutes to always).

I think I managed to found the problem, located to mysql that take a big amount of ram to do a request, but since the server is not responding, I can't connect to SSH to analyze it.

Is there a tool that save into a file every actions made by mysql, each request, the size it took to make them, the memory used, cpu, etc.

I'd like to find which request is causing my server to go down about one/two times per week :/

Thanks for your help!

share|improve this question
up vote 4 down vote accepted

The slow query log maybe an option.

share|improve this answer
Thanks! I'll try it! – Cyril N. Apr 7 '11 at 8:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.