MySQL Performance Monitoring
November 20, 2007
Part of our managed hosting service includes the active monitoring of your servers. If ever there is a bottleneck or a slow down in your website, we can tell you exactly where it is occurring and how to remedy the issue. Our consultation also allows for you to anticipate growth, plan for the future, and handle the mass amounts of traffic that you might expect.
We’ve now added MySQL performance monitoring to give you more information at your fingertips, so you can know exactly what is going on with your site.
How do we do this?
A big part of it is graphs! We track over 20 different metrics on how your server is running. Here are just a few examples:
Memory Usage Tracking
System Load Tracking
Traffic Analysis Tracking
Each dedicated server solution comes with detailed data, statistics and information about your server and website, to which you complete have access. You’re able to track hardware oriented data such as CPU and RAM usage over time.
A new feature that Gossamer Host now has is the ability to track MySQL database performance and activity, allowing you to tweak your code and ultimately optimize your website. Information is generated into graphs so you can analyze trends and data visually.
MySQL Monitoring
Gossamer Host generates numerous types of MySQL performance charts for you to analyze and make use of. Here are just a few:
MySQL Efficiency Tracking
MySQL Query Tracking
MySQL Query Type Tracking
MySQL Threads Tracking
This provides all sorts of immediate information and long-term / trending statistics on things like:
- Selects per second
- Inserts/Updates/Deletes per second
- Queries per Second
- Slow Queries per minute
- Query cache query performance
- Number of simultaneous connections
- and more!
We have a monitoring server that polls all of the servers in our data center for this information. The reports are generated as you need them, and are displayed in near real time.
Our Active Role
When we say we take an active role, we mean it. These charts and graphs serve as an indicator for which sites need our attention, and upon discovering a potential issue - we offer solutions to you instead of watching your site struggle.
Take a look at this particular site’s CPU usage graph:
At each of the steps above, Gossamer Threads was there to consult and recommend a solution.
The site was performing sluggishly, so we upgraded their servers with two Dual-Core Opteron processors to give them more power
As traffic grew again, the site started to bog down. We took a look at the platform it was running: a resource hungry PHP based one
The client couldn’t justify another hardware upgrade, so rather then throwing more hardware at the problem, we worked on a static page solution to reduce load on the server, but continue to serve more pages
Not all issues are because of hardware, and with Gossamer Threads detailed reporting system we can help you diagnose what the best course of action is for your website.
Great for Developers
Gossamer Host provides developers with all the crucial information need in the development of their website. With our reporting system, you can track data and trends by day, up to a week, to benchmark performance and compare it to your last set of optimizations.
All of the information is readily available and with our experience with web technologies, you can be at ease knowing you have the support and knowhow of a team that wants your site to succeed as much as you do.
Tags: Gossamer Host, graphs, mysql, server monitoring, tracking
