apache slowdown: Vlogger fails to connct to mysql on localhost
Error message in the apache log file:
piped log program ' /usr/local/ispconfig/server/scripts/vlogger -s access.log -t "%Y%m%d-access.log" -d "/etc/vlogger-dbi.conf" /var/log/ispconfig/httpd' failed unexpectedly
The reason for this error is that vlogger ( aperl based logger script) fails to connect to mysql server on localhost. This seems to be a issue with the perl name resolution, as connections to the localhost IP 127.0.0.1 work.
Fix:
edit the file /etc/vlogger-dbi.conf and replace "localhost" with "127.0.0.1", then restart apache.
For Ubuntu 12.04 servers: Install the following package:
apt-get install libclass-dbi-mysql-perl
and restart apache.
Update:
Edit mysql my.cnf file and add the lines
max_connections = 500 max_user_connections = 500
In the [mysqld] section and restart mysql.