Traffic problems: MySQL connections - mysql_pconnect

[tanasi]

Hi,

these days I am experiencing "Site unavaillable" and this is that my site is down for a while (10 min) and then comes online again. I checked the logs and one common error I noticed is the following:

 

mod_fcgid: stderr: PHP Fatal error: Uncaught Link to database cannot be established: SQLSTATE[HY000] [1040] Too many connections

 

I spoke with hosting support and they told me that I have reached the limit of concurrent users in MySQL which is 50. And that i should check that my Database connecting type is not persistence (mysql_pconnect).

 

What do you advise me to do? If this configuration is recommended where can I find and change it?

Edited April 27, 2013 by tanasi (see edit history)

[PascalVG]

As far as I know, PS already uses mysql_connect, not mysql_pconnect.

 

See file /classes/db/MYSQL.php (and modules/shopimporter/ajax.php)

 

There may be other reasons however, so have a look here:

http://stackoverflow.com/questions/5040048/php-mysql-too-many-connections-to-database-error

 

or here:

 

http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

 

Hope this helps,

Pascal