Re: global schema lock

[Mouhsen Ibrahim]

Hi, right now I am trying to execute this query "TRUNCATE TABLE performance_schema.events_statements_summary_by_digest" it just hangs with this state in the output of "SHOW PROCESSLIST"

"Waiting for ndbcluster global schema lock"

This is also the output of "ndb_mgm -e show"

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=12 @192.168.2.21 (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0, *)
id=13 @192.168.2.22 (mysql-5.7.17 ndb-7.5.5, Nodegroup: 0)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @192.168.2.29 (mysql-5.7.17 ndb-7.5.5)
id=11 @192.168.2.20 (mysql-5.7.17 ndb-7.5.5)

[mysqld(API)] 2 node(s)
id=14 @192.168.2.22 (mysql-5.7.17 ndb-7.5.5)
id=15 @192.168.2.21 (mysql-5.7.17 ndb-7.5.5)



Edited 1 time(s). Last edit at 07/04/2017 03:55AM by Mouhsen Ibrahim.