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!

link|improve this question

feedback

1 Answer

up vote 4 down vote accepted

The slow query log maybe an option.

link|improve this answer
Thanks! I'll try it! – cx42net Apr 7 '11 at 8:08
feedback

Your Answer

 
or
required, but never shown

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