Mailing List Archive

max_user_connections <-> 20 simultaneous MySQL connections <-> delayed inserts
-----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@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-----
Re: max_user_connections <-> 20 simultaneous MySQL connections <-> delayed inserts [ In reply to ]
On Apr 2, 2004, at 12:35, Joachim Schiele wrote:
> i got this problem as described in the mail below which i marked as
> reply. can
> someone please give me advice here?

Search for "INSERT DELAYED" and "REPLACE DELAYED" in the *.php files
and remove the word "DELAYED".

-- brion vibber (brion @ pobox.com)