PHP+MySQL config. problem

[Anon]

We just migrated our site to a new server and updated PHP to 4.0B2 and Apache 1.3.9 and mysql 3.23. We have worked out most all of the configuration problems except for an intermittent problem with mysql_pconnect. People are being locked out of apps. that tie into the database.

We have the php.ini set at-

mysql.allow_persistent: On
mysql.default_host: no value
mysql.default_password: no value
mysql.default_port: no value
mysql.default_socket: no value
mysql.default_user: no value
mysql.max_links: Unlimited
mysql.max_persistent: Unlimited

This is the error that comes up:

Warning: Too many connections in /www/pathname.. on line #

Warning: MySQL Connection Failed: Too many connections in /www/pathname.. on line #

And help is appreciated!

[mrmufin]

Just because the PHP interpreter will allow 'unlimited' database connections. doesn't mean that the database engine will...

This can be especially troublesome when many sites share a common database server. If you have access to the database via a shell, get the status from the database engine:

mysql>\s;

It'll return information about the current state of the database server, number of current connections, etc. If your site shares a common database engine with other sites on the same server... welll... move to a server where you have your own instance of the database.

Try connecting without using mysql_connect(), (not mysql_pconnect()), and explicitly closing every connection resource with mysql_close() and see if that helps any.

Have fun.