MySQL Forums
Forum List  »  NDB clusters

Re: Waiting for commit lock
Posted by: Mikael Ronström
Date: July 12, 2017 07:16AM

Each MySQL Server has a set of locks to operate on tables.
NDB tables are often accessible even when one MySQL Server
has locked parts.
In principle one can say that NDB allows for higher concurrency
than the MySQL Server is able to handle.
This is one of the reasons why it makes sense to have separate
MySQL Servers for binlogging and to execute metadata statements.

I am not sure exactly what the commit lock is.
So please post the content of a SHOW PROCESSLIST from the problematic
MySQL Server and the error log in this server as well.
These probably have some hints what is happening.

Here is what the manual says about this lock:
Waiting for commit lock

A statement that causes an explicit or implicit commit is waiting for release of a read lock or FLUSH TABLES WITH READ LOCK is waiting for a commit lock.

So it might be that you have locked some table in the problematic
MySQL Server. Table locks are only local to a MySQL Server for NDB tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
54
July 12, 2017 03:27AM
Re: Waiting for commit lock
18
July 12, 2017 07:16AM
14
July 14, 2017 12:03PM
12
July 16, 2017 03:19AM


Sorry, only registered users may post in this forum.

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.