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.

Yesterday I had a unusual spike in the number of MySQL queries in one of my servers. Is there any way I could inspect my logs to detect what was the main cause?

Thank you.

Edit: Added Munin graphs.!

Munin graphs

share|improve this question
    
Sorry Patt, I don't understand your question. Could you please be a little more concise? Kind regards, Simon. –  Simon Aug 29 '12 at 8:56
    
@Patt, I'm guessing Simon uses his eyes. Perhaps you intended to ask how the graphs are generated, or how is the data gathered (Munin apparently). –  John Gardeniers Aug 29 '12 at 9:39
add comment

1 Answer 1

The pt-query-digest tool from the Percona Toolkit will do this.

share|improve this answer
add comment

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.