MySQL is one of the main causes of issues on a shared server. MySQL Governor monitors MySQL usage and throttles abusers, preventing them from overloading the server, which improves overall stability and performance.
MySQL often becomes a major headache for shared hosting companies. Keeping MySQL stable is difficult, and customer queries can easily slow everything down. This is where MySQL Governor comes in. Its ability to pinpoint abusers and throttle them in real time is unprecedented in the industry. With support from the latest versions of MySQL and MariaDB, it is a must-have for any shared host.
MySQL Governor tracks CPU and disk IO usage for every user in real time and throttles MySQL queries by using same-per-user LVE limits. By using the dbtop utility, it is possible to see usage as it happens on a per-customer basis, ensuring that system admins always know what is going on.
MySQL Governor features:
- Stable, simple limits counted as part of LVE limits
- Automatic detection and killing of long-running queries
- MySQL 5.1 – 5.6 support
- MariaDB 5.x and 10.x support
As a result, hosting companies can carefully throttle resources to maintain performance across servers without instantly disconnecting users.