## Notes 

Block name 

To obtain a list of all block names, simply execute SELECT block_name FROM ndbinfo.blocks . Although this is a static table, its content can vary between different NDB Cluster releases. 

## 23.5.14.5 The ndbinfo cluster_locks Table 

The cluster_locks  table provides information about current lock requests holding and waiting for locks on NDB  tables in an NDB Cluster, and is intended as a companion table to cluster_operations . Information obtain from the cluster_locks  table may be useful in investigating stalls and deadlocks. 

The cluster_locks  table contains the following columns: 

• node_id 

ID of reporting node 

• block_instance 

ID of reporting LDM instance 

• tableid 

ID of table containing this row 

• fragmentid 

ID of fragment containing locked row 

• rowid 

ID of locked row 

• transid 

Transaction ID 

• mode 

Lock request mode 

• state 

Lock state 

• detail 

Whether this is first holding lock in row lock queue 

• op 

Operation type 

• duration_millis 

Milliseconds spent waiting or holding lock 

