Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.