Skip to content
  • Frazer Clement's avatar
    ec1e0119
    WL#7656 Per fragment locks information · ec1e0119
    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
    ec1e0119
    WL#7656 Per fragment locks information
    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
Loading