analyze_storage_engines
Analyze MySQL storage engine usage and statistics to identify optimization opportunities. Provides table counts, sizes by engine, and specific metrics for InnoDB, MyISAM, and MEMORY engines with optimization 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"
}