Too Many Connections

I have been on occasion recieving "Too Many Connections" errors which lock up mysql.. I know i can set the connections in my.cnf.. atleast thats what i've seen on this listover the past few months.. For starters.. i dont seem to have a my.cnf according to mysqladmin Default options are

Re: Too Many Connections

Since you feel that you should never have more than 15 simultaneous connections at a given time, I don't think modifying max_connections will help. I would first verify that the PHP code is closing the connection. If it isn't, then the connection will stay open until it times out. If you do,

Re: too many connections

"Jesse E. Stay II" wrote: I seem to have run into a problem lately where all of the sudden my server keeps giving me "too many connections" errors, locking anyone out of the site. I have set max_connections to 210, which shouldn't matter anyway because we haven't had

too many connections

I seem to have run into a problem lately where all of the sudden my server keeps giving me "too many connections" errors, locking anyone out of the site. I have set max_connections to 210, which shouldn't matter anyway because we haven't had any more users than usual accessin

Re: ERROR 1040: Too many connections

Filippo There must be a problem, then. Filippo It happens to me, often, that I cannot obtain a proc or ext with mysqladmin Filippo as root. Filippo All accesses are through an unpriv username, I have max_connections=1000 and Filippo a Filippo ps ax | grep mysqld | wc -l gives me a value

Re: ERROR 1040: Too many connections

still get through even if there are too many connections. It is already there - max_connections limit is actually for the user Filippo without process_priv. For the user with process_priv, the limit is max_connections Filippo + 1. The trick is not to connect as root for your regular connections

<    1   2