Loaded MySQL 4.0.18 w/ KSE running nicely

Kris Gale kris-fbsd at asn.net
Wed Mar 24 11:35:52 PST 2004


> 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


More information about the freebsd-threads mailing list