3

I'm using the 1.1.8 mysql-cacti-templates to gather metrics on MySQL 5.0.77 (CentOS 5.7).

Both the InnoDB Current Lock Waits and InnoDB Lock Structures graphs are charting with Cur[rent] values but there are no Locked Transactions charting in the InnoDB Active/Locked Transactions graph. I also checked SHOW PROCESSLIST and SHOW INNODB STATUS and there are no locks.

However, if I do a mysqladmin debug it does print out a long list (dozens) of Current locks to the error log, i.e.:

lock: 0x1e6a21b0:

lock: 0x1e7cd750:

lock: 0x1e5bdcb0:

lock: 0x1e839180:

lock: 0x1e821870:

lock: 0x1e737840:

lock: 0x1e6c5590:

lock: 0x1e5b8fa0:

[snip]

How can I determine what is causing these locks if they don't show up in a SHOW PROCESSLIST or a SHOW INNODB STATUS? FWIW, I also tried the InnoDB Lock Monitor but it too did not show any locks.

Please advise.

Thanks!

2
  • Is mysqladmin debug printing to the console? Commented Jan 26, 2012 at 21:01
  • @RolandoMySQLDBA No, it is printing to the error log.
    – HTTP500
    Commented Jan 26, 2012 at 21:39

1 Answer 1

1

The locks appear to be spurious. Verified bug: http://bugs.mysql.com/bug.php?id=64140

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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