[Mediawiki-l] max_user_connections <-> 20 simultaneous MySQL connections <-> delayed inserts

[Joachim Schiele]

-----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&#039;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 at 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-----