Re: Too Many Connections

max_connections = 500 <-- this needs to in the server config file mysql@lists.mysql.com On Fri, 2003-04-18 at 13:15, Monty wrote: > > On 18-Apr-2003 Monty wrote: > >> I am getting a "Too Many Connections" error now with MySQL. I've done > >> some > >> searching here to find solutions, but, was wondering if anyone knew of > >> any > >> sites that have detailed info about how to resolve this problem in MySQL > >> and > >> PHP. I'm not sure where to begin as far as optimizing my code to reduce > >> database access. One thing I did do is I start using mysql_connect > >> (instead > >> of pconnect) for some quick-and-dirty routines to reduce this problem. > >> While > >> it has helped some, it hasn't made the problem go away. > >> > > mysql> show variables like '%timeout'; > > mysql> show variables like 'max_conn%'; > > > > increase max_connections > > decrease wait_timeout, interactive_timeout. > > > > Regards, > > -- > > Don Read dread@texas.net > > -- It's always darkest before the dawn. So if you are going to > > steal the neighbor's newspaper, that's the time to do it. > > > Thanks Don. I looked at the MySQL site for more info on this and am still > confused. I know I need to put this in a my.cnf file in the /etc directory > on my server, but, I'm not exactly sure of the format for this file. Is this > what I need to do in my.cnf? > > --------- > > [client] > set-variable = max_connections = 150 > set-variable = wait_timeout = 14400 > set-variable = interactive_timeout = 14400 > > --------- > > Is this what I need to do to increase connections and decrease wait_timeout > and interactive_timeout from 28800 to 14400? Is 14400 a good idea or is that > too little/much? I have no clue after spending an hour on the MySQL site > looking through their horrible documentation. > > I know this isn't PHP, but, I've tried joining the MySQL mailing list with > no success, and MySQL for some reason still doesn't have a well-run > newsgroup like PHP. > > Monty >