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.

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

1 Answer 1

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

 
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.