analyze_buffer_pool
Analyze InnoDB buffer pool usage to identify memory allocation patterns, hit ratios, and page distribution. Provides recommendations for optimal buffer pool sizing based on schema and table analysis.
Instructions
Detailed analysis of InnoDB buffer pool usage.
Analyzes:
Buffer pool allocation by schema and table
Page types and distribution
Hit ratios and efficiency metrics
Memory allocation patterns
Recommendations for buffer pool sizing
Note: When analyzing by schema/table, this tool only shows user/custom tables and excludes MySQL system tables (mysql, information_schema, performance_schema, sys).
Uses sys schema views for detailed breakdown when available.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| by_schema | No | Include breakdown by schema | |
| by_table | No | Include breakdown by table (top N) | |
| top_n | No | Number of top tables to show |
Input Schema (JSON Schema)
{
"properties": {
"by_schema": {
"default": true,
"description": "Include breakdown by schema",
"type": "boolean"
},
"by_table": {
"default": true,
"description": "Include breakdown by table (top N)",
"type": "boolean"
},
"top_n": {
"default": 20,
"description": "Number of top tables to show",
"type": "integer"
}
},
"required": [],
"type": "object"
}