Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark

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


_______________________________________________
freebsd-performance@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-performance
To unsubscribe, send any mail to "freebsd-performance-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark
    ... This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that do 320MB/s ... Switching from HTT to no HTT was achieved by machdep.hyperthreading_allowed, and switching from/to libpthread/libthr was done via libmap.conf. ... 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. ... 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. ...
    (freebsd-performance)
  • Re: MySQL 5.0.22 , FreeBSD 6.1-STABLE: Benchmark
    ... This server is a Dual Xeon 2.8GHz, 4GB of RAM and 2x73GB SCSI disks that do 320MB/s ... Switching from HTT to no HTT was achieved by machdep.hyperthreading_allowed, and switching from/to libpthread/libthr was done via libmap.conf. ... 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. ... 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. ...
    (freebsd-performance)
  • Re: Painkiller: First time I had to disable a core (and it worked!)
    ... I was playing Painkiller on a multicore system (Dual XEON HT and Dual Dualcore Opteron) and it ran fine out of the box... ... Still playing it here on a Core 2 Duo E6600 and it works fine OOTB ...
    (comp.sys.ibm.pc.games.action)
  • Re: Detection of HTT
    ... November 2004 05:11, Brooks Davis wrote: ... > some early P4s that set the HTT flag but only have one core. ... P4s without HTT are/were available in the 1.3-2.8 GHz range (HTT actually was ...
    (freebsd-current)
  • Re: Dual core CPUs support
    ... > I?d like to ask here, what is the actual situation with dual core CPUs - ... your second core is ignored/not reported. ... will enable the HTT (second core, in your case) if you wish. ...
    (freebsd-current)