check_database_health
Analyze MySQL database performance metrics including connection statistics, buffer pool efficiency, query cache, InnoDB operations, and replication status to identify optimization opportunities and maintain system health.
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"
}