MySQL Forums
Forum List  »  NDB clusters

Re: MySQL NDB cluster lock
Posted by: David Ashman
Date: October 27, 2016 11:59AM

The table metadata lock and ndb global schema lock can deadlock each other. You can kill the two 'show tables' threads and see if the drop goes through.

Drop tables are usually fast, but if you do any large alters that require table copies it's very easy to get into this situation if you don't close all other sessions.

Options: ReplyQuote


Subject
Views
Written By
Posted
912
September 29, 2016 05:14PM
440
October 26, 2016 04:19AM
Re: MySQL NDB cluster lock
404
October 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.