Too many connections in :

Anon

I am getting the "Too many connections in xyz.." error messaged. I am using <b>mysql_pconnect</b> persistent connection to connect to a database. I understading that pconnect does not have a close function. My question is, would the problem be solved if I use the <b>mysql_connect</b> and use the mysql_close() function. I am just using the database to bulid the page and once it has been built there is no need to maintain a connection. What you advice me?

Anon

Hi,

pconnect() only works on many connect and close calls within the SAME process, i.e. in the program. So please use connect() and close() function and optimize the variables in mysql to reduce the number of connections.

Anon

Hallo!
The default number of connection is = 100. If you have a very heavy loaded site, probably you want allow more connections on your database server.
To get this, start the server with the option --set-variable max_connections=200

It should correct the problem.
ciao