MySQL Monitoring
MySQL server, connections, caches and index usage under continuous monitoring, with checks adapted to the environment in which the database operates.
From the key metrics to troubleshooting
MySQL is the most widely used open source relational database system: its performance and ease of use make it one of the pillars of the market. It consists of a server part and a client part, both available on Unix and Windows systems.
The Sentinet³ MySQL Pattern monitors both components with checks customised to the environment in which the database operates, performs continuous monitoring and flags potential problems before they hit the system. The checks start from the most important metrics, the ideal starting point for troubleshooting.
| At a glance | |
|---|---|
| Pattern | Sentinet³ MySQL Pattern |
| Sources | Direct authenticated access to the database |
| Scope | Server, connections and activity, caches, indexes and queries |
The Pattern’s checks
The Pattern includes 20 checks. Each has configurable thresholds and generates a notification when values exceed them.
Server
| Check | What it verifies |
|---|---|
| Reachability | The server responds on the network |
| CPU | Percentage of CPU utilisation |
| Memory | Memory usage |
| Disk | Free disk space |
| Service | Service availability |
Connections and activity
| Check | What it verifies |
|---|---|
| Connection Time | Time to connect to the database |
| Uptime | Minutes of database activity |
| Long running proc | Processes that have been running for a long time |
| Threads connected | Number of open connections |
Cache
| Check | What it verifies |
|---|---|
| Query cache hit rate | Query cache hit rate |
| Thread cache hit rate | Thread cache hit rate |
| Buffer pool hit rate | InnoDB buffer pool hit rate |
| Buffer pool wait free | InnoDB buffer pool waits for a free page |
| Key cache hit rate | MyISAM key cache hit rate |
| Table cache hit rate | Table cache hit rate |
| Log waits | Waits caused by log buffer capacity |
| Query cache low mem prunes | Entries removed from the query cache due to insufficient memory |
Other
| Check | What it verifies |
|---|---|
| Index usage | Percentage of index usage |
| Slow queries | Frequency of queries detected as slow |
| Temp disk table | Percentage of temporary tables created on disk instead of in memory |
Data read correctly, policies respected
- Authenticated access: Sentinet³ queries MySQL databases by accessing the system directly with authentication: data is read correctly according to the user level employed, in compliance with company policies.
- Server and client: both MySQL components are monitored, on Unix and Windows alike.
- Prevention: continuous monitoring flags potential problems before they hit the system.
Related topics
Want to see Sentinet³ on your infrastructure?
Tell us about your environment: sites, technologies, critical services. We will show you how Core and Infinity can work on your case.