Monit is using the anonymous bind (user= and password=) - mysql
should apply the user limit on this type of connect.
I have retested with your setup and reached the same result.
I have used mysql 5.0.30 ... maybe there is bug in your mysql version or
some setting of mysql which applies the
... there may be one reason why monit reports that your mysql is OK - as
i mentioned, monit connects as anonymous user with empty password.
The protocol test however solves the case, where the anonymous user has
no permission to connect to mysql - in such case the access is refused
I have tested it ... it works, maybe you forgot to reload monit with the
new configuration?
Testing output:
1.) i have set the connection limit to 5 in my.cnf using:
--8--
max_connections = 5
--8--
2.) i have started 6 connections as mysql admin to block the additional
connections:
Martin Pala wrote:
I think that monit mysql protocol test should detect this, for example:
Hi Martin,
I think the following configuration is what you mean, but it does not work:
--8--
check process mysql with pidfile /var/lib/mysql/iifwpdata.com.pid
start program = /usr/bin/safe_mysqld