Warning: mysql_connect(): Too many connections ???

[exsus]

Hi all.

I've installed oscommerce 2.2 milestone 2 and everything was ok till there were too many users accessing my site -- and then i'm getting this error:

 

"Warning: mysql_connect(): Too many connections in /home/..../database.php on line 19

Unable to connect to database server!"

 

 

My question is:

How it's generating this error ? oscommerce or my provider it's limiting the number of connections to the database ?

 

I want to mention that on the installing process i've checked this: use persistent connections - false.

 

define('USE_PCONNECT', 'false'); // use persistent connections?

[mark27uk3]

This error is generated when there are too many connections to the mysql server.

 

This is a general problem that all dbase driven sites have especially when you could be one of 1000's of sites on your hosts server.

 

Your host will have set a limit to the amount of connections they allow to the mysql server and its just a case of waiting for a connection to be dropped.

 

If customers see this then they go elsewhere.

 

I had this problem on my site and politely asked my host to move my dbase to a less densely populated server and it worked and I have no problems since.

 

Mark