I think you just increased your traffic to the point that there are more concurrent requests than MySQL connections.
Fixing it, however, could be problematic. Here's a few ideas: * Convince your host to allow you to use mysql_pconnect() in PHP, and modify the code to use it (and NOT close the connection). See http://www.php.net/manual/en/features.persistent-connections.php before trying this. * Modify the code and have it retry until it can connect. (Probably won't work) * Convince your host to raise the limit to accomadate this increase of traffic.
If these don't work, the only other thing I can think of is to throttle the number of requests (eg, waiting 15 seconds before doing any proccessing). But this should be avoided if possible.
On Tue, 25 Jan 2005 10:07:43 -0500, Myria myria@wolfandturtle.net wrote:
Hi,
Last night I started getting a strange error from my MediaWiki installation
Sorry! The wiki is experiencing some technical difficulties, and cannot contact the database server. User wolfandt_wiki has already more than 'max_user_connections' active connections"
The wiki has been running over a month and I've not had this problem before so I wondered if maybe my host had changed something, but they say they haven't --
Max user connections has not been changed. You will want to check your code to make sure that your mysql connections are being closed and not left open as thats the main cause for exceeding that limit of 100 connections.
To be honest I'm always a little suspicious when my host company says that nothing has changed, in the past that has turned out to be false, but other aps I host there, all of which also use MySQL, are and were running just fine and this morning MediaWiki appears to be running fine with no harm to the wiki itself.
Does anyone have any idea what might have caused that error message or how I might avoid it happening again?
Versions --
OS : FreeBSD 4.9-RELEASE-p11 MySQL : Ver 12.22 Distrib 4.0.16 PHP : 4.3.8 MediaWiki : 1.3.9
URL : http://wolfandturtle.net/Indigo/
Myria
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l