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
TableJSON 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 |