-
Frazer Clement authored
Three new Ndbinfo views added : - locks_per_fragment Companion table to operations_per_fragment and memory_per_fragment. Keyed in a similar way. Shows counts of lock claim requests, and their outcomes per fragment. Shows total time spent waiting for locks successfully and unsuccessfully. - cluster_locks Companion table to cluster_operations. Keyed in a similar way. Shows current lock requests holding and waiting for locks. Allows stalls and deadlocks to be investigated. - server_locks Companion table to server_operations. Keyed in a similar way. Essentially a subset of cluster_operations, for transactions running on the local MySQLD, showing a connection id per transaction. The two tables are based on two underlying tables - ndb$frag_locks (locks_per_fragment) - ndb$acc_operations (cluster_locks, server_locks) Three new testcases added : - ndbinfo_locks_per_fragment - ndbinfo_cluster_locks - ndbinfo_server_locks
Frazer Clement authoredThree new Ndbinfo views added : - locks_per_fragment Companion table to operations_per_fragment and memory_per_fragment. Keyed in a similar way. Shows counts of lock claim requests, and their outcomes per fragment. Shows total time spent waiting for locks successfully and unsuccessfully. - cluster_locks Companion table to cluster_operations. Keyed in a similar way. Shows current lock requests holding and waiting for locks. Allows stalls and deadlocks to be investigated. - server_locks Companion table to server_operations. Keyed in a similar way. Essentially a subset of cluster_operations, for transactions running on the local MySQLD, showing a connection id per transaction. The two tables are based on two underlying tables - ndb$frag_locks (locks_per_fragment) - ndb$acc_operations (cluster_locks, server_locks) Three new testcases added : - ndbinfo_locks_per_fragment - ndbinfo_cluster_locks - ndbinfo_server_locks
Loading