MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark

[Michael Vince]

Hugo Silva wrote:

> Today I decided to benchmark MySQL 5 performance on FreeBSD 6.1-STABLE.
> This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks 
> that do 320MB/s
>
> For all the tests, I restarted mysqld prior to starting the test,  
> waited for about 1 minute for it to settle down, and ran super smack. 
> For the consecutive runs, I executed super-smack right after the 
> previous run ended.
>
> Switching from HTT to no HTT was achieved by 
> machdep.hyperthreading_allowed, and switching from/to 
> libpthread/libthr was done via libmap.conf.
>
> System:
>
> FreeBSD ?? 6.1-STABLE FreeBSD 6.1-STABLE #3: Mon Jul  3 03:10:35 UTC 
> 2006     ??@??:/usr/obj/usr/src/sys/DATABASE  i386
>
> Here are the results:
>
>
> MySQL 5.0.22, built with BUILD_OPTIMIZED=yes and WITH_PROC_SCOPE_PTH=yes
>
>
> === 4BSD + libthr + HTT on ===
>
> Run #1
> connect: max=4ms  min=1ms avg= 3ms from 10 clients
> Query_type      num_queries     max_time        min_time        q_per_s
> select_index    200000      0           0           20405.86
>
>
I think that this, does show impressive scaling to actually see 
performance increase with HTT enabled, from what I have seen on 
benchmarks on many hardware sites testing on MS Windows is that on the 
average best you get is an extra 5% performance out of HTT per core.
I don't have any quad core machines either, but my dual CPU Dells that 
are around 3.[46]ghz get score of around 25,000

The other promising benchmark I saw on per CPU scaling was a few months 
ago with a posted super smack benchmark on a -current box that was 
getting a score of around 60,000 on a slightly better Quad core AMD64 
machine which proves consistent scaling per core, which as far as my 
memory goes shows good scaling when entering the 4+ core arena on MySQL.

Mike

>
> === 4BSD + libthr + HTT off ===
>
> Run #1
> connect: max=5ms  min=2ms avg= 3ms from 10 clients
> Query_type      num_queries     max_time        min_time        q_per_s
> select_index    200000      0           0           18253.60