How to install WatchMySQL Plugin in WHM
Installation
Go to the below path
cd /sbin
Remove the file or take the backup
rm -f watchmysql
Download watchmysql plugin using the below link
wget http://www.ndchost.com/cpanel-whm/scripts/watchmysql/download.php
Change the ownership of that file
chown root.root watchmysql
Change permission of the file.
chmod 0750 watchmysql
Configuration
Before you run the script you must first configure it. Use edit to open the watchmysql script and set the options.
#Sets the maximum concurrent connections per MySQL user.
my $max_concurrent_connections = '15';
#Who to tell about this user... (email)
my $warning_email = '[email protected]';
#Kill Abuser's MySQL Connections (0 = no, 1 = yes)
my $kill_user = '0';
#MySQL polling in seconds (600 = 10 minutes)
my $check_interval = '600';
Running
To start this script simply run the following command
/sbin/watchmysql &
If you want the script to start when the system boots you need to add the above line to /etc/rc.local