[ILUG] [Fwd: Re: [Webdev] MySQL and Linux kernel patch]

[Donncha O Caoimh]

Sent the following to webdev, I'm sure some of the kernel hackers here
will be interested too in the following..

Donncha.

---------------------------------------------------------------

Patched the kernel, did the tests, here's the results:
Kernel              Patched  Unpatched
Num clients         150      150
Queries per client  1000     1000
Queries per second  2591     3086
Max query time      521      120
Max connect time    25137    259
Avg connect time    15052    9

Take a look at the file below for the actual queries executed.

I have a html table of results with 10,25,75,100,125, and 150 clients.
If anyone wants it ask me, or if anyone has a place to post it on the
'net, contact me.

Donncha.


Donncha O Caoimh wrote:
> 
> Has anyone tried the kernel patch in
> http://www.mysql.com/Downloads/Contrib/mysql-bench-0.6.tar.gz
> yet?
> I've just applied it(hacked it since it didn't apply to my RH6.1 kernel
> cleanly) and recompiling the kernel as we speak.
> The supplied stats look very impressive: (Pentium III 500, 256 MB RAM,
> Linux 2.2.12)
> Unpatched kernel:
> Avg connect time for 10 clients, 1000 requests was 645