Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

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

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

share|improve this answer

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.