Re: Too many connections

either pass it as a parametr at startup: mysqld -O max_connections=500 or mysqld --set-variable max_connections=500 or in my.cnf/my.ini (the [mysqld] section): set-variable = max_connections=500 At 17:33 5.1. 2001, David Smith wrote the following: -------------------------------------------------------------- >Below is my problem... Can anyone explain how I can change the >max_connections variable to 500? > > >MySQL Doc's >---------------- > >If you get the error Too many connections when you try to connect to MySQL, >this means that there is already max_connections clients connected to the >mysqld server. > >If you need more connections than the default (100), then you should restart >mysqld with a bigger value for the max_connections variable. > >Note that mysqld actually allows (max_connections+1) clients to connect. The >last connection is reserved for a user with the process privilege. By not >giving this privilege to normal users (they shouldn't need this), an >administrator with this privilege can log in and use SHOW PROCESSLIST to >find out what could be wrong. See section 7.28 SHOW Syntax (Get Information >About Tables, Columns,...). > >The maximum number of connects MySQL is depending on how good the thread >library is on a given platform. Linux or Solaris should be able to support >500-1000 simultaneous connections, depending on how much RAM you have and >what your clients are doing. > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net ------end of quote------ ____________________________________________________________ Cynic: A member of a group of ancient Greek philosophers who taught that virtue constitutes happiness and that self control is the essential part of virtue. cynic@mail.cz