Data Base Software or...
3 отговора
67 прегледа
Data Base Software or...
Ne znam "na kvo" raboti DB server-a na dir.bg i po to4no clubs.dir.bg ama tova vseki den okolo 17 4asa da mi kazva too many connections e sramota. Adi to 1,2,5 pyti se tyrpi ama to stava postoianno po tova vreme. Sto ne si kupite edin oracle ili moje bi da si optimizirate software (php-tata)? Predpolagam 4e ste s mysql i vi predlagam malko help po vyprosa:
A.2.6 Too many connections Error
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 SUPER 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 4.5.7.6 SHOW PROCESSLIST.
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.
Edva li se vyrjat po 1000 4oveka na vednyj
A.2.6 Too many connections Error
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 SUPER 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 4.5.7.6 SHOW PROCESSLIST.
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.
Edva li se vyrjat po 1000 4oveka na vednyj
