MySQL Forums :: NDB clusters :: MySQL NDB cluster lock


Advanced Search

Re: MySQL NDB cluster lock
Posted by: Martin Sköld ()
Date: October 26, 2016 04:19AM

Hello,

Prior to mysql-5.7 there is unfortunately no way of finding what
connection is holding a metadata lock. In 5.7 there is a system table:
https://dev.mysql.com/doc/refman/5.7/en/metadata-locks-table.html
The ndbcluster global schema locks are not directly related since
they are used to synchronize meta data operations between several
mysql servers connected to the cluster. A drop table would typically
acquire a local metadata lock first and then a ndbcluster global schema lock
to ensure that the drop is acknowledged from all mysql servers.
The output from the processlist indicate that it didn't manage to
lock the table locally, so some other connection is accessing the
same table. If you provide some more information what other statements/queries
are being executed we might be able to help some more.

best regards,
Martin Sköld

Options: ReplyQuote


Subject Views Written By Posted
MySQL NDB cluster lock 636 Maggie Liu 09/29/2016 05:14PM
Re: MySQL NDB cluster lock 295 Martin Sköld 10/26/2016 04:19AM
Re: MySQL NDB cluster lock 266 David Ashman 10/27/2016 11:59AM


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.