get_fragmented_tables
Identify MySQL tables with significant fragmentation that waste disk space and slow query performance. Analyze user tables based on fragmentation percentage and wasted space thresholds to optimize database storage.
Instructions
Find user tables with significant fragmentation.
Fragmentation occurs when:
Data is deleted from tables
Tables are frequently updated
VARCHAR/TEXT columns are modified
Note: This tool only analyzes user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys) by default.
High fragmentation wastes disk space and can slow queries.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| min_fragmentation_pct | No | Minimum fragmentation percentage threshold | |
| min_data_free_mb | No | Minimum wasted space in MB | |
| schema_name | No | Filter by specific schema | |
| limit | No | Maximum tables to return |
Input Schema (JSON Schema)
{
"properties": {
"limit": {
"default": 50,
"description": "Maximum tables to return",
"type": "integer"
},
"min_data_free_mb": {
"default": 10,
"description": "Minimum wasted space in MB",
"type": "number"
},
"min_fragmentation_pct": {
"default": 10,
"description": "Minimum fragmentation percentage threshold",
"type": "number"
},
"schema_name": {
"description": "Filter by specific schema",
"type": "string"
}
},
"required": [],
"type": "object"
}