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 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 start. > > How do we optimize mySQL for connections? > > We have moved the mysqld process up on priority (renice -3 -u mysql). > We have tried to: > specify the max_connections variable. It's commented out (see below) > because mySQL won't start with this directive. We also tried placing it in > the safe_mysqld section, but it doesn't get recognized when we restart mysql > and do a mysqladmin variables command. What do we need to do to increase > this? > > We have also tried to specify the open-files-limit variable, however, this > doesn't appear to be recognized either. > > Here is a copy of the my.cnf file we are using: > > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > log-bin > log-update = /var/log/gitgdb.log > #max_connections=250 > > [mysql.server] > user=mysql > basedir=/var/lib > > [safe_mysqld] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > open-files-limit=8192 > renice -3 -u mysql > > Any suggestions would be greatly appreciated. > Kim > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
