get_innodb_status
Analyze InnoDB engine status to identify performance bottlenecks in buffer pools, transaction handling, deadlocks, and I/O operations, providing optimization recommendations for MySQL database tuning.
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"
}