check_database_health
Analyze MySQL database performance metrics including connection statistics, buffer pool efficiency, replication status, and query cache to identify optimization opportunities and provide actionable recommendations.
Instructions
Perform a comprehensive MySQL database health check.
Analyzes multiple aspects of MySQL health:
Connection statistics and pool usage
Buffer pool hit ratio
Query cache efficiency (if enabled)
InnoDB metrics (buffer pool, log, transactions)
Replication status (if configured)
Thread and connection usage
Uptime and general status
Returns a health score with detailed breakdown and recommendations. Based on MySQLTuner analysis concepts.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_recommendations | No | Include actionable recommendations | |
| verbose | No | Include detailed statistics |
Input Schema (JSON Schema)
{
"properties": {
"include_recommendations": {
"default": true,
"description": "Include actionable recommendations",
"type": "boolean"
},
"verbose": {
"default": false,
"description": "Include detailed statistics",
"type": "boolean"
}
},
"required": [],
"type": "object"
}