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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
--
-------------------------------------------------------------------
http://endeavour.zapto.org/astro73/
Thank you to JosephM for inviting me to Gmail!