MySQL and MariaDB Health Checks run server-level checks and show findings for configuration, performance, capacity, and operational risk.
Health Checks give DBAs and application teams a practical list of configuration, performance, capacity, and reliability findings. Start with findings that affect production availability, backup confidence, storage capacity, security, or user-visible performance. Then group lower-severity findings into planned maintenance work.
Validate each finding before making a change. A memory recommendation should be compared with Memory and InnoDB, while a query-related recommendation should be checked against Queries. This reduces the risk of fixing a symptom while missing the real workload cause.
Run health checks after remediation so the team can see which items cleared and which need follow-up. This makes the page useful for managed service reports, internal reviews, and ongoing database hygiene.
No. They are useful during incidents, but regular review helps catch capacity and configuration issues before users notice them.
Some low-severity findings can be deferred, but they should still be reviewed and either accepted or scheduled.
Configuration that is acceptable for one workload may be risky for another. Always interpret findings in the context of the monitored server.
After a health check finding appears, validate it on the supporting page before making changes. Query findings should be compared with Queries and Activity. InnoDB findings should be checked with InnoDB, Deadlocks, and I/O. Configuration findings should be reviewed against your MySQL or MariaDB version, hosting model, and change-control process.
The following Mini DBA MySQL and MariaDB health check detail pages explain the purpose of each check and the actions to take when a check fails.
| Health check | Category | Detail |
|---|---|---|
| % of Max Files Open | Performance | Open detail |
| Connection Capacity | Performance | Open detail |
| Fragmented Tables | Performance | Open detail |
| General Log Enabled | Performance | Open detail |
| InnoDB Lock Pressure | Performance | Open detail |
| MySQL Error Log Warnings | Performance | Open detail |
| Threads Running Pressure | Performance | Open detail |
| % Selects Scanning | QueryPlans | Open detail |
| % Slow Queries | QueryPlans | Open detail |
| % Temp Tables on Disk | QueryPlans | Open detail |
| Prepared Statement Use | QueryPlans | Open detail |
| Query Errors and Warnings | QueryPlans | Open detail |
| Aborted Connects | Security | Open detail |
| Anonymous Users | Security | Open detail |
| % Data of Buffer Pool Size | Storage | Open detail |
| % InnoDB Buffer Pool Usage | Storage | Open detail |
| InnoDB Buffer Pool Dirty Pages | Storage | Open detail |
| InnoDB Buffer Pool Free | Storage | Open detail |
| InnoDB Buffer Pool Hit Ratio | Storage | Open detail |
| InnoDB Buffer Pool Waits | Storage | Open detail |
| InnoDB Log Waits | Storage | Open detail |
| Single Engine Per DB | Storage | Open detail |
| Unused Indexes | Storage | Open detail |