Overview
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.
Instructions
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.
cd /usr/src wget http://download.ndchost.com/watchmysql/latest-watchmysql sh latest-watchmysql
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
