get_table_memory_usage
Analyze MySQL table memory usage to optimize caching parameters by showing table cache usage, hit rates, buffer pool breakdown, and open table statistics for performance tuning.
Instructions
Analyze memory usage for user tables and caches.
Shows:
Table cache usage and hit rates
Table definition cache efficiency
Open tables vs table_open_cache
InnoDB buffer pool by table
Note: Buffer pool breakdown by table only shows user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys).
Helps optimize table caching parameters.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_buffer_pool | No | Include InnoDB buffer pool by table | |
| top_n_tables | No | Number of top tables to show |
Input Schema (JSON Schema)
{
"properties": {
"include_buffer_pool": {
"default": true,
"description": "Include InnoDB buffer pool by table",
"type": "boolean"
},
"top_n_tables": {
"default": 20,
"description": "Number of top tables to show",
"type": "integer"
}
},
"required": [],
"type": "object"
}