Am Dienstag, den 07.12.2004, 11:47 -0600 schrieb Jacob S: > Hello list, > > I am having a problem with mysql refusing connections intermittently on > a webserver. It acts like an invisible limit has been hit on the maximum > number of connections. Not finding any info in the config files about > the max number of connections allowed, I did some googling. > > This url is the closest I can find, though I notice their syntax seems > to be a lot different from the standard mysql config file in Debian. Not > to mention that the page was last updated 09/2003. > > http://www-css.fnal.gov/dsg/external/freeware/mysqlTuning.html > > Can anyone tell me if this is the correct way to increase the max number > of connections, or how to do it if it's not? I would try to test it > myself, but it is a bit hard to do on a busy server and when I would > need a huge number of connections. >
There are tow ways to set the limit of maximium connections at one time: - connect to mysql as root and type: mysql> set global max_connections=xxx; you can check your vars with: mysql> show variables; -->> after restart of mysqld the default value is back. - edit /etc/my.cnf and add max_connections = xxx to the "[mysqld]" section -->> this would cause mysqld to use this var after next restart good luck, Achim > TIA, > Jacob > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]