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.