analyze_innodb_transactions
Analyze InnoDB transactions to identify long-running transactions, lock waits, deadlocks, and purge lag that impact MySQL database performance.
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
| Name | Required | Description | Default |
|---|---|---|---|
| include_queries | No | Include transaction queries | |
| min_duration_sec | No | Minimum transaction duration to include |
Input Schema (JSON Schema)
{
"properties": {
"include_queries": {
"default": true,
"description": "Include transaction queries",
"type": "boolean"
},
"min_duration_sec": {
"default": 0,
"description": "Minimum transaction duration to include",
"type": "integer"
}
},
"required": [],
"type": "object"
}