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

I've found plenty of tools that will monitor the output of SHOW PROCESSLIST and SHOW INNODB STATUS but haven't really found much that indicates it will log, digest and summarize (optionally enabled) data from the InnoDB Lock Monitor. Is there such a tool?

(FWIW, I know I can enable the slow_query_log and have done that, but want to be able to log more specific locking activities over time. What is difficult to tell when encountering a slow query is what other thread/query/user caused it without manual inspection.)

share|improve this question

innotop can be used to display locks in a prettier format than the raw data, but it's more of a point in time view. If you're looking for something like long-term statistics and summaries, I'm not aware of anything.

share|improve this answer
Thanks, I'm aware of innotop, but nothing for long-term like you. – Zadan Nov 20 '11 at 1:40

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.