calculate_memory_usage
Analyze MySQL memory usage by calculating per-thread buffers, global server buffers, and maximum potential utilization to identify configuration issues and provide optimization recommendations.
Instructions
Calculate MySQL memory usage and provide recommendations.
Analyzes:
Per-thread memory buffers (read_buffer, sort_buffer, join_buffer, etc.)
Global server buffers (key_buffer, innodb_buffer_pool, etc.)
Maximum potential memory usage
Current memory utilization
Based on MySQLTuner's memory calculation methodology. Helps identify memory-related configuration issues.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| physical_memory_gb | No | Physical memory in GB (for comparison). If not provided, uses system detection if available. | |
| detailed | No | Include detailed breakdown |
Input Schema (JSON Schema)
{
"properties": {
"detailed": {
"default": true,
"description": "Include detailed breakdown",
"type": "boolean"
},
"physical_memory_gb": {
"description": "Physical memory in GB (for comparison). If not provided, uses system detection if available.",
"type": "number"
}
},
"required": [],
"type": "object"
}