lock_wait_rca
Build the InnoDB wait-for tree, identify the root blocker, and parse the latest deadlock from SHOW ENGINE INNODB STATUS to diagnose lock-wait issues.
Instructions
[READ] Build the InnoDB wait-for tree, name the root blocker, and parse the last deadlock out of SHOW ENGINE INNODB STATUS.
Pass 'pairs' (as from lock_waits) for pure/offline analysis, or omit to pull the current lock-wait graph live.
Args: pairs: Injected lock-wait pairs {blockedId, blockingId, ...}; if omitted, pulled live (flavor-branched). include_deadlock: Also parse the LATEST DETECTED DEADLOCK section from SHOW ENGINE INNODB STATUS (default True). target: Target name from config; omit for the default.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pairs | No | ||
| target | No | ||
| include_deadlock | No |