http://www.ndchost.com/cpanel-whm/scripts/watchmysql/

Installation

cd /sbin
rm -f watchmysql
wget http://www.ndchost.com/cpanel-whm/scripts/watchmysql/download.php
chown root.root watchmysql
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 = 'your@email.address';

#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