-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
dear wiki list,
i got this problem as described in the mail below which i marked as reply. can
someone please give me advice here?
thanks very much so far - wiki is running - except this thing - well with
sourceforge ;-)
Joachim Schiele
Where can i change the code to not have the delaying code?
The problem is that the wiki goes offline for over a few hours sometimes :P
========================<mail>=================
Dear sf team,
we got much problems with the mysql server because
sometimes it's not responding as expected - so not
working. We are working with a wiki* which has a mysql
backend and it happened 3 times last week that it didn't
work. I think it's because of the mysql service overload.
*mediawiki from the wikipedia
If i try to create a backup i get:
[qknight@sc8-pr-shell1 mysql_backup]$ ./backup.sh
mysqldump: Got error: 1203: User lmuse@ has already
more than "max_user_connections" active connections
when trying to connect
seems to me as if there is some 'overload'
What wrong here? Normaly the wiki does it's work
quite
nice.
Thank you very much,
Joachim Schiele
----------------------------------------------------------------------
Comment By: Jacob Moorman (moorman)
Date: 2004-04-02 12:42
Greetings,
We permit up to 20 simultaneous MySQL connections per
project at a time. This is mainly to prevent abuse.
Something your application is doing (or one of the other
scripts you run) must be causing threads to hang. Chances
are high that it is delayed inserts. Please remove the
delayed clause from all of your queries (or otherwise
disable delayed ops via flag if your application provides one).
Should you require further assistance from the
SourceForge.net team, please add a comment to this request.
Thank you,
Jacob Moorman
Quality of Service Manager,
SourceForge.net -----BEGIN PGP
SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAbc52yzk1c1T5Os4RAifKAJ49nsGPEk4EPd+Wyw1hqbtG+HY1ogCgg4QX
lcAb3wt1kejzl/PwTOfqKtc=
=ZBS/
-----END PGP SIGNATURE-----