Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 24 Mar 2004 12:35:46 -0700 (MST)
From:      "Kris Gale" <kris-fbsd@asn.net>
To:        "Daniel Eischen" <eischen@vigrid.com>
Cc:        freebsd-threads@freebsd.org
Subject:   Re: Loaded MySQL 4.0.18 w/ KSE running nicely
Message-ID:  <50726.68.228.211.254.1080156946.squirrel@mail.asn.net>
In-Reply-To: <Pine.GSO.4.10.10403221539360.9266-100000@pcnet5.pcnet.com>
References:  <51632.68.14.252.60.1079987672.squirrel@mail.asn.net> <Pine.GSO.4.10.10403221539360.9266-100000@pcnet5.pcnet.com>

next in thread | previous in thread | raw e-mail | index | archive | help
> And I use still use your script to test MySQL, except that
> I use don't override the default for key_buffer, and I also
> patch MySQL to use process scope threads.

I just tested out the patch for mysql, and everything seems
to be running very smoothly.  Not only was I able to get
1800 threads (90 * 20) running (which was a huge stumbling
block for me earlier), but I'm looking over at 4000 threads
that managed to connect (200 * 20).

Before trying the patch, I synced to -current.  There was
some talk about some recent scheduler changes maybe
helping things.  This didn't seem to help at all.  Before
I patched mysql, I was getting frequent lockups with as
few as 100 threads.

Since the key_buffer value is tuned for the amount of RAM
on my test system, I've left it in place...

I'm going to continue by trying to test actual queries I'd
see in production to see how this compares to my
4-stable system.

Kris



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?50726.68.228.211.254.1080156946.squirrel>