php mysql - Too many connections to database error

Question

Good day to all  I have an odd error  I have created a chat that works like this     questions answers are inserted into a db every 2 seconds an ajax request is sent to a php script that fetch the new questions answers   It worked fine until today when I got this error   Uncaught exception  PDOException  with message  SQLSTATE HY000   1040  Too many connections  in  var www html dbdev include Zend Db Adapter Pdo Abstract php 129  Stack trace   0  var www html dbdev include Zend Db Adapter Pdo Abstract php 129   PDO- gt   construct  mysql host loca              Array   s 1  var www html dbdev include Zend Db Adapter Pdo Mysql php 96   Zend Db Adapter Pdo Abstract- gt  connect    s 2  var www html dbdev include Zend Db Adapter Abstract php 448   Zend Db Adapter Pdo Mysql- gt  connect    s 3  var www html dbdev include Zend Db Adapter Pdo Abstract php 238   Zend Db Adapter Abstract- gt query  select profile       Array   s 4  var www html dbdev include Zend Db Adapter Abstract php 782   Zend Db Adapter Pdo Abstract- gt query  select profile       Array   s 5  var www html dbdev include Profile php 43   Zend Db Adapter Abstract- gt fetchPairs  select profile        s 6  var www html dbdev public html index php 29   Profile- gt load    s 7  main  Next exception  Zend Db Adapter Exception  with in  var www html dbdev include Zend Db Adapter Pdo Abstract php on line 144   The problem is that we were not that many     8  and I don t think the db could not support more than 8 to 16 connections simultaneously  on specifications is written that the chat must support 50-100 users so 8 is    small     So    can any1 tell me why did this happen  yesterday we were 15 and worked fine  and how to solve it  Thank you for your help  If you need any code samples just ask

User · Answer

Please check if you open up a new connection with each of your requests (mysql_connect(...)). If you do so, make sure you close the connection afterwards (using mysql_close($link)).

Also, you should consider changing this behaviour as keeping one steady connection for each user may be a better way to accomplish your task.

If you didn't already, take a look at this obvious, but nonetheless useful information resource: http://php.net/manual/function.mysql-connect.php

User · Answer

This can happen due to too many connection same time or many chat at same time  Also it can happen due too many session    The best way to sort out this issue is restart MySQL    service mysqld restart   or  service mysql restart   or    etc init d mysqld restart

User · Answer

The error SQLSTATE HY000   1040  Too many connections is an SQL error  and has to do with the sql server  There could be other applications connecting to the server  The server has a maximum available connections number   If you have phpmyadmin  you can use the  variables  tab to check what the setting is   You can also query the status table like so   show status like   onn      Or some variance on that  check the manual for what variables there are   be aware   connections  is not the current connections  check that link

User · Answer

If you need to increase MySQL Connections without MySQL restart do like below  also if you don t know configuration file  below use the mysqlworkbench or phpmyadmin or command prompt to run below queries   mysql gt  show variables like  max connections    ----------------- -------    Variable name     Value    ----------------- -------    max connections   151      ----------------- -------  1 row in set  0 00 sec   mysql gt  SET GLOBAL max connections   250  Query OK  0 rows affected  0 00 sec   mysql gt  show variables like  max connections    ----------------- -------    Variable name     Value    ----------------- -------    max connections   250      ----------------- -------  1 row in set  0 00 sec    These settings will change at MySQL Restart     For permanent changes add below line in my cnf and restart MySQL   max connections   151

User · Answer

There are a bunch of different reasons for the  Too Many Connections  error   Check out this FAQ page on MySQL com   http   dev mysql com doc refman 5 5 en too-many-connections html  Check your my cnf file for  max connections    If none exist try    mysqld  set-variable max connections 250   However the default is 151  so you should be okay   If you are on a shared host  it might be that other users are taking up too many connections   Other problems to look out for is the use of persistent connections and running out of diskspace

User · Answer

If you are reaching the mac connection limit go to  etc my cnf and under the  mysqld  section add max connections   500  and restart MySQL

[php] php, mysql - Too many connections to database error

Examples related to php

Examples related to mysql

Examples related to zend-framework

Examples related to pdo

Examples related to database-connection