analyze_innodb_transactions
Analyze InnoDB transactions to identify long-running processes, lock waits, deadlocks, and transaction isolation levels for performance optimization.
Instructions
Analyze InnoDB transactions and locking.
Identifies:
Long-running transactions
Lock waits and blocking transactions
Deadlock history
History list length (purge lag)
Transaction isolation levels
Helps identify transaction-related performance issues.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_queries | No | Include transaction queries | |
| min_duration_sec | No | Minimum transaction duration to include |