Information_schema.innodb_locks is empty
Posted by: Tom Grant
Date: November 18, 2016 09:49AM

When I run the following query, it always returns an empty result set.

FROM information_schema.innodb_locks;

It seems very unlikely that none of the times that I run this there are no locks. I even ran a LOCK TABLES command with autocommit set to 0 and still there was nothing.

I have checked permissions. I have same issue with innodb_lock_waits.

I am working with MySql version 5.6.28 Community Server.

Is there something that I need to do in order for this view to return results?

Options: ReplyQuote

Written By
Information_schema.innodb_locks is empty
November 18, 2016 09:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.