[Fwd: Re: Mysql - Linuxthreads : Still needed?]

[Ganbold]

Some mysql benchmark I just did...

-----------------------------------------------------------------------
System Specs:

IBM @server 325 type 8835
Dual AMD Opteron 2.1ghz
4GB (2x2GB) PC-2700 ECC memory
6x36GB hot swap RAID5 Ultra 320 SCSI HDD
ServeRAID 6M controller

-------------------------------------------------------------------------
OS / Software Configuration:

FreeBSD amd.micom.mng.net 5.3-STABLE FreeBSD 5.3-STABLE #6: Thu Nov 11 
21:08:50 ULAT 2004     tsgan at amd.micom.mng.net:/usr/obj/usr/src/sys/AMD  amd64

MySQL Compiled from mysql40-server port with:

BUILD_OPTIMIZED=yes
BUILD_STATIC=yes

-------------------------------------------------------------------------
kernel without SMP and without PREEMPTION options
-------------------------------------------------------------------------
amd# cat test_nosmp_nopreemption
Query Barrel Report for client smacker
connect: max=7ms  min=2ms avg= 4ms from 30 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    300000  4       0       3565.71
update_index    300000  4       0       3565.71
-------------------------------------------------------------------------

-------------------------------------------------------------------------
kernel without SMP and with PREEMPTION options
-------------------------------------------------------------------------
amd# cat test_nosmp_preemption
Query Barrel Report for client smacker
connect: max=18ms  min=1ms avg= 8ms from 30 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    300000  6       0       3568.64
update_index    300000  4       0       3568.64
-------------------------------------------------------------------------

-------------------------------------------------------------------------
kernel with SMP and without PREEMPTION options
-------------------------------------------------------------------------
amd# cat test_smp_nopreemption
Query Barrel Report for client smacker
connect: max=16ms  min=5ms avg= 8ms from 30 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    300000  4       0       3755.09
update_index    300000  3       0       3755.09
-------------------------------------------------------------------------

-------------------------------------------------------------------------
kernel with SMP and with PREEMPTION options
-------------------------------------------------------------------------
amd# cat test_smp_preemption
Query Barrel Report for client smacker
connect: max=14ms  min=9ms avg= 10ms from 30 clients
Query_type      num_queries     max_time        min_time        q_per_s
select_index    300000  4       0       4053.86
update_index    300000  3       0       4053.86
-------------------------------------------------------------------------

It seems like fastest result I get in kernel with SMP and with PREEMPTION 
options.

regards,

Ganbold


At 06:56 PM 11/15/2004, you wrote:

>On Wed, 10 Nov 2004, Julian Elischer wrote:
>
> > send to the right list.
>
>So, the good news is that we've successfully dramatically improved the
>performance of MySQL between 5.2 and 5.3.  The mixed news is that clearly
>we have more work to do. :-)  Out of curiousity, has anyone done much in
>the way of kernel profiling during heavy duty MySQL runs to see if there
>are specific kernel bottlenecks we can be working on?
>
>I've noticed that we're contending a fair amount on UNIX domain socket
>locking, although with Giant off the stack this is a big improvement over
>what we saw previously.  Although it was a few months ago, my recollection
>from profiling the mutex use and kernel use is that we're spending a lot
>of time checking to see if we have to deliver signals to threads or not in
>kernel.  I may have the opportunity to do a bit of profiling today or
>tomorrow and see what I bump into.
>
>Robert N M Watson             FreeBSD Core Team, TrustedBSD Projects
>robert at fledge.watson.org      Principal Research Scientist, McAfee Research
>
>
>_______________________________________________
>freebsd-threads at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-threads
>To unsubscribe, send any mail to "freebsd-threads-unsubscribe at freebsd.org"