I am running MySQL 5.5.31 on FreeBSD 9.2. I have a web server with a miss-configured service that generates faulty connections. After a while, MySQl blocks any connection from the web server.
At some stage, I had set-up a script that would browse syslog log and look for a string like "Host 'xxx' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'" and would then issue a mysqladmin flush-hosts.
But after an upgrade, MySQl stopped reporting to syslog.
MySQL process is:
database<root>: ps auwwx | grep mysql mysql 81063 0.0 0.1 9852 1172 ?? Is 3Dec14 0:00.18 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/database/mysql/my.cnf --user=mysql --datadir=/database/mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --syslog mysql 81386 0.0 2.0 314712 42180 ?? I 3Dec14 8:19.75 /usr/local/libexec/mysqld --defaults-extra-file=/database/mysql/my.cnf --basedir=/usr/local --datadir=/database/mysql --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --pid-file=/database/mysql/database.cs.ait.ac.th.pid --socket=/tmp/mysql.sock --port=3306
Any help will be greatly appreciated.
TIA,
Olivier
--
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!