Jump to content
MDDHosting Forums

[Completed] Hermes - MySQL Governor/Stats Installation

Recommended Posts

We will be installing a MySQL Governor and Statistics system so that we can more easily track which MySQL databases are causing issues for the server for us to ensure overall stability and performance. This installation should be seamless with the only MySQL downtime being up to 5 minutes while the MySQL server is restarted. We will update this thread once the installation is completed or if any unexpected issues arise.
Link to comment
Share on other sites

Very nice Mike. What sort of issues do client MySQL databases cause on a server and how will you use the tool to ensure stability? I always thought that databases were relatively static and that the applications that reference databases were culprits of instability. It's interesting to learn that db's themselves can be culprits too.
Link to comment
Share on other sites

It allows us to watch statistics on which databases are accessed when, how much CPU is used in doing so, how many rows were requested, how many were updated, etc. It's quite in-depth.


At the end of the day - if MySQL is having issues it will allow us to more easily identify the source of the trouble so that we can ensure a higher level of service and reliability.

Link to comment
Share on other sites

For those who may be curious, it allows us to see statistics such as these:

Statistics for ONE MySQL User on a shared server over 15 minutes:
Table: wp_adrotate_tracker
>> Rows Read: 88,199,361 (97,999 rows per second)

Table: wp_adrotate_stats_tracker
>> Rows Read: 10,771,198 (11,968 rows per second)

Total: Rows Read: 98,970,559 (109,967 per second)

Link to comment
Share on other sites

Have you ever given thought to running the Percona release of MySQL? It's said to be significantly faster than the Oracle releases, and it's a drop-in replacement... kind of like Apache and LiteSpeed (except that Percona is free). I might have mentioned this to you, but I don't recall it.
Link to comment
Share on other sites

  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...