WatchMySQL is a cpanel plugin for mysql that gives administrators the ability to monitor concurrent user connections to MySQL. The WatchMySQL daemon can be configured so that when a user exceeds theire connection limit a notification is sent to the administrator and/or user. The daemon can also be configured so that it will kill off those connections. Limits can be set per user, per package, or globally.
How to install Login the server as root user and follow the below steps to install this plugin.
# cd /home
# rm -f latest-watchmysql
# wget
http://www.ndchost.com/cpanel-whm/plugins/watchmysql/download.php# sh latest-watchmysql
Now login to WHM to see the new plugin installed.
Useful backend files#/etc/init.d/watchmysql -- startup script used for starting and stoping the watchmysql daemon
#/etc/watchmysql.config -- this is the global config file that watchmysql uses.
#/etc/watchmysql.userlimits -- this is the user limits config file, syntax is user=limit, one user per line.
#/etc/watchmysql.packagelimits -- this is the package limits config file, syntax is package=limit, one package per line. This only works on cPanel/WHM servers
/usr/sbin/watchmysql -- this is the watchmysql daemon