Monitoring MySQL servers is no rocket science provided you know what to monitor. MySQL gives a comprehensive list of variables to check your server’s health and performance. Let me walk you through the crucial variables you should be monitoring. Lets assume that you have one or more MySQL servers, which have been setup and running fine. Here are the top 10 things to monitor on your MySQL.
1. MySQL availability
Yes, this is the first thing you should be looking at!
It would not make sense to monitor your MySQL if its not even
available. MySQL downtime is simply not acceptable in production.
At the same time ensuring zero downtime does not guarantee
You can execute
-mysqladmin -h 192.168.1.95 -u root -p status
to know if MySQL is running or you can just ping MySQL using service mysqld status if you are using RedHat Linux.
2. Presence of insecure users and …[Read more]