The WatchMySQL plugin gives you the ability to monitor your MySQL server connection usage per user. If you've ever seen the message 'Too Many Connections' when trying to connect to to the server through the CLI you know how frustrating it is not knowing who is chewing up all the connections. The WatchMySQL daemon stays connected to the MySQL server and monitors usage. If a user is abusing the server the daemon can either alert you or even kill off the users connections. Limits can be set per user, per package, and globally.
Set connection limits by cPanel user, package, and globally.
E-Mail alert admins, cPanel user, or both when limit threshold is reached.
Optionally kill excessive connections.
The installation process of this plugin is very simple, log into your server's console as the user root and execute the following commands!
cd /usr/src wget http://download.ndchost.com/watchmysql/latest-watchmysql sh latest-watchmysql
It's that simple! Now log into the WHM, scroll down to the plugins section and click the 'WatchMySQL' link.
Help support the company who brought you this Free plugin! Did you know we offer cPanel licenses? We will even match your current license providers price and renewal date. The tranfer process is simple, there is no downtime, and you will have no billing overlap!. If you are interested in finding out more information please our license transfers page.
NDCHost has been my Goto Hosting Provider for the past 8 years - From colo to vps to dedicated and all of our cPanel license needs. The team at NDC is amazing!
