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!
UPDATE
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?
Thanks.