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>