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

Advanced Search

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
MySQL NDB cluster lock 682 Maggie Liu 09/29/2016 05:14PM
Re: MySQL NDB cluster lock 318 Martin Sk├Âld 10/26/2016 04:19AM
Re: MySQL NDB cluster lock 291 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.