Too many connections

From: Date: Fri, 05 Jan 2001 16:33:35 +0000
Subject: Too many connections
Groups: php.general 
Request: Send a blank email to php-general+get-32894@lists.php.net to get a copy of this message
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.

« previous php.general (#32894) next »