get_index_stats
Analyze MySQL index statistics to identify low cardinality indexes, oversized indexes, and infrequently used indexes for database performance optimization.
Instructions
Get detailed index statistics for MySQL user tables.
Returns:
Index cardinality and selectivity
Index size and memory usage
Read/write operation counts
Index efficiency metrics
Helps identify:
Low cardinality indexes
Oversized indexes
Infrequently used indexes
Note: This tool only analyzes user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_name | No | Schema/database to analyze | |
| table_name | No | Specific table to analyze (optional) | |
| order_by | No | Order results by | size |