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!


The slow query log maybe an option.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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