get_table_memory_usage
Analyze MySQL table memory usage to optimize caching parameters. Shows table cache usage, hit rates, InnoDB buffer pool by table, and cache efficiency metrics 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"
}