Max DB connections problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Max DB connections problem

Post by McGruff »

Been having various database connection problems, including:

"more than 'max_user_connections' active connections"

These are the relevant server settings (local value / master value):

mysql.allow_persistent On / On
mysql.max_links 20 / 20
mysql.max_persistent Unlimited / Unlimited

I tried but couldn't find any info on the above in the mysql manual. Am I right in thinking that any number of persistent connections are allowed - or am I limited to a max of 20 of either kind?

The host (a shared server) recommends using persistent connections to hook up to the database - which I have done. I think I understand the basic idea of these: sort of a Blue Peter "here's one I made earlier" approach where any existing child process will be reused at each new page request.

However, the "more than 'max_user_connections' active connections" error was obtained by my client in a test area when he was the only individual accessing the test site (checking out some functions such as admin updates of the database and general browsing). This seems odd since, I would have thought, the first persistent connection created at the first page load should be reused on subsequent page requests.

If you can provide some info on what the above server settings actually mean I can probably figure it out from there.

Thanks for your help.
Post Reply