Re: Optimizing mySQL for volume

2001-12-27 Thread Jason Burfield
You need to set the max_connections variable like this in the my.cnf file: set-variable = max_connections=250 -- Jason On Thu, 2001-12-27 at 11:38, Kim Albee wrote: > We are trying to optimize mySQL. Right now, the max_connections is set to > 100. We are only able to open 99 concurrent co

Re: Optimizing mySQL for volume

2001-12-27 Thread Jeremy Zawodny
On Thu, Dec 27, 2001 at 10:38:42AM -0600, Kim Albee wrote: > We are trying to optimize mySQL. Right now, the max_connections is set to > 100. We are only able to open 99 concurrent connections to the db, and even > then, some requests are unable to get a connection. We'd like to be able to > sc

Optimizing mySQL for volume

2001-12-27 Thread Kim Albee
We are trying to optimize mySQL. Right now, the max_connections is set to 100. We are only able to open 99 concurrent connections to the db, and even then, some requests are unable to get a connection. We'd like to be able to scale that up, but mySQL doesn't like what we've done, as it won't st