analyze_storage_engines
Analyze MySQL storage engine usage and statistics to identify optimization opportunities. Get table counts, sizes by engine, and specific metrics for InnoDB, MyISAM, and MEMORY engines with actionable recommendations.
Instructions
Analyze storage engine usage and statistics for user tables.
Provides:
List of available engines and their status
Table count and size by engine
Engine-specific metrics (InnoDB, MyISAM, MEMORY, etc.)
Recommendations for engine optimization
Note: This tool only analyzes user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys) by default.
Based on MySQLTuner's engine analysis patterns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_table_details | No | Include per-table engine details | |
| schema_name | No | Filter by specific schema (optional) |
Input Schema (JSON Schema)
{
"properties": {
"include_table_details": {
"default": true,
"description": "Include per-table engine details",
"type": "boolean"
},
"schema_name": {
"description": "Filter by specific schema (optional)",
"type": "string"
}
},
"required": [],
"type": "object"
}