count concurrent locking transactions ?

[pedro lopez]

Hi,

I have a transaction locking an InnoDB table that can take some time under certain rare conditions (SELECT *** FOR UPDATE), and it then tends to create deadlocks when subsequent transactions are concurrently issued on this same table during such long running transactions.

I thus would like to test how many statements (SELECT *** FOR UPDATE) are currently active againt this table before I decide to launch a new statement against it.


Is this thus possible to see at a given time how many statements are currently queued to acquire a lock on a given InnoDB table ?

thanks in advance !

Pedro