get_innodb_status
Analyze InnoDB engine status to identify performance bottlenecks, monitor buffer pool efficiency, detect deadlocks, and optimize MySQL database operations with actionable recommendations.
Instructions
Analyze InnoDB engine status from SHOW ENGINE INNODB STATUS.
Parses and analyzes:
Buffer pool statistics and hit ratios
InnoDB log information and checkpoints
Row operations (reads, inserts, updates, deletes)
Transaction information and history list
Semaphore waits and mutex contention
Deadlock information (if any)
I/O statistics and pending operations
Redo log performance
Based on MySQLTuner's InnoDB analysis patterns. Provides actionable recommendations for InnoDB optimization.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_raw_output | No | Include raw INNODB STATUS output | |
| detailed_analysis | No | Include detailed analysis with all metrics |
Input Schema (JSON Schema)
{
"properties": {
"detailed_analysis": {
"default": true,
"description": "Include detailed analysis with all metrics",
"type": "boolean"
},
"include_raw_output": {
"default": false,
"description": "Include raw INNODB STATUS output",
"type": "boolean"
}
},
"required": [],
"type": "object"
}