I have a web app and sometimes I start receiving PHP error failures ("Unable to connect to MySQL server") and after a while it gets resolved.
MaxConnection set in my.cnf is 750
Is there any log or way to learn why MySQL server gets down (or is it reaching connection limit?)?
Any help is appreciated, thanks!
After reading Warner's answer below, checked my.cnf file and tried to find the error log but it doesn't exist.
[mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 max_connections=700 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
Can I just add log-error=/var/log/mysqld.log to [mysqld] group?