This plugin 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.

Installation Instructions

The installation proceedure for this plugins requires that you have root access to the server via the console or SSH. Below are step by step instructions you should use to install this plugin.

Code: 
cd /home
Code: 
rm -f latest-watchmysql
Code: 
wget http://www.ndchost.com/cpanel-whm/plugins/watchmysql/download.php
Code: 
sh latest-watchmysql
Screenshots :






Using the plugin from the WebHostManager

Log into the WHM, click on plugins, then WatchMySQL.
Using the plugin from the Command Line

/etc/init.d/watchmysql -- this is the init.d 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
Regards
Bharat Reviewed by Bharat on . Installing WatchMySQL Plugin for WHM This plugin 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. Installation Instructions The installation proceedure for this plugins requires that you have root access to the Rating: 5