MySQL Status
MySQL offers a wealth of status information to the administrator, however most users lack a means to process and interpret this data. Wormly provides you with a number of graphs describing the varying load, utilization and efficiency of your MySQL servers over time.
Correlating these graphs with lower-level performance metrics (e.g. Load, CPU & RAM Usage) can help you determine what impact the MySQL database is having on your overall website performance.
The MySQL Commands graph shows you the number of commands per second executed on the target server, for the four fundamental SQL operations.
Updates and Inserts are generally the ones to look out for, as an irregular spike can raise performance issues due to the increased Disk IO demands associated with it.
The MySQL Query Cache graph indicates what proportion of queries are being satisfied by the query cache; known as “cache hits”. Obviously the higher the proportion the better, as cached queries execute much faster and consume fewer resources.
The MySQL Connections graph indicates the number of connections per second established to your target MySQL server. This is a useful overall load metric, and can be helpful in diagnosing the familiar MySQL too many connections error.
The MySQL Throughput graph is another useful metric for assessing the overall load level of your MySQL server. It indicates the rate of raw data transfer into, and out of, the target database server. It is presented in kilobytes per second.
Spikes in this graph can reveal usage of large binary objects (BLOBs) which, despite having significant Disk IO requirements, would remain hidden in regular command query statistics.
Performance Graphs
Internal metrics
External metrics
Downtime Hurts. Start monitoring and stop worrying.
Our server monitoring service continually tests your website to keep you online and performing fast. Fully-featured plans start from just $19 / month.
But don't listen to our spiel - Grab a free trial and decide for yourself »
See Also
Solution Spotlight
Mark Harbottle from SitePoint said:
“We chose Wormly because website uptime is crucial to our business … A slow or unreachable website translates directly into revenue lost.” Read on »
About Wormly
Wormly monitors your website infrastructure to keep you online and performing fast.
Be Alert. Stay in the loop with SMS, ICQ, MSN and email failure alerts.
Be Proactive. Performance monitoring reveals problems before they cause downtime.
Exceptional Value. With feature packed plans from just $19 a month you can afford the peace of mind that a professional uptime monitoring solution delivers.