Status of MySQL on 7 w/o patches applied

Abdullah Ibn Hamad Al-Marri wearabnet at yahoo.ca
Sun Nov 4 09:40:26 PST 2007


----- Original Message ----
> From: Peter Schuller <peter.schuller at infidyne.com>
> To: Ivan Voras <ivoras at freebsd.org>
> Cc: freebsd-current at freebsd.org
> Sent: Sunday, November 4, 2007 3:22:08 PM
> Subject: Re: Status of MySQL on 7 w/o patches applied
> 
> > So to follow-up, with RELENG_7 the performance is now significantly
> > > better than 6.2 for me too. I guess it was the debugging options in
> > > userland. If someone wants details anyway I'll provide them,
> but
> 
 since
> > > it is no longer that interesting I'm leaving it as is if no
> one
> 
 speaks
> > > up.
> > 
> > It's always interesting to get "third party" confirmations on such
> > benchmarks so please post them :)
> 
> Better late than never...
> 
> So to recap, these tests were done on single-processer AMD64 machines
> with 512 MB of memory. So nothing as interesting as SMP scalability
> and such, but still interesting to see an increase in absolute speed
> in the simple case. They were also performed maintaly with the 4BSD
> scheduler.
> 
> Due to the reason for running these tests, they were also made with
> MyISAM rather than InnoDB, prepared as such:
> 
> sysbench --test=oltp \
>          --mysql-table-engine=myisam \
>          --oltp-table-size=1000000 \
>          prepare
> 
> And run as such:
> 
> sysbench --num-threads=16 \
>          --max-requests=100000 \
>          --test=oltp \
>          --oltp-table-size=10000 \
>          --mysql-socket=/tmp/mysql.sock \
>          --oltp-read-only \
>          run
> 
> The MySQL version is 5.0.45_1 in both cases, compiled from ports with
> default build settings, and (on purpose) default MySQL runtime
> settings (empty my.cnf).
> 
> Nothing in loader.conf on either machine. On the RELENG_7 one I tried
> the following, one at a time, but none of them caused a different time
> source to be chosen (probably because I was doing it the wrong way):
> 
> kern.timecounter.tc.TSC.quality="1000"
> kern.timecounter.hardware="TSC"
> kern.timecounter.choice="TSC(1200) ACPI-fast(1000)
> i8254(0)
> 
 dummy(-1000000)"
> kern.timecounter.smp_tsc="1"
> 
> CPU details (6.2 machine, then RELENG_7 machine):
> 
> 
> CPU: AMD Athlon(tm) 64 Processor 3200+ (1989.81-MHz K8-class CPU)
>   Origin = "AuthenticAMD"  Id = 0x40ff2  Stepping = 2
> 
 
> Features=0x78bfbff
> ,PAT,PSE36,CLFLUSH,MMX,FXSR,SSE,SSE2>
>   Features2=0x2001
>   AMD Features=0xea500800
>   AMD Features2=0x1d,,CR8>
> 
> CPU: AMD Athlon(tm) 64 Processor 3200+ (1989.82-MHz K8-class CPU)
>   Origin = "AuthenticAMD"  Id = 0x40ff2  Stepping = 2
> 
 
> Features=0x78bfbff
> ,PAT,PSE36,CLFLUSH,MMX,FXSR,SSE,SSE2>
>   Features2=0x2001
>  
> AMD
> 
 Features=0xea500800
>   AMD Features2=0x1d
> 
> And the sysbench results:
> 
> 6.2:
> 
> OLTP test statistics:
>     queries performed:
>         read:                            1400000
>         write:                           0
>         other:                           200000
>         total:                           1600000
>     transactions:                        100000 (261.10 per sec.)
>     deadlocks:                           0      (0.00 per sec.)
>     read/write requests:                 1400000 (3655.45 per sec.)
>     other operations:                    200000 (522.21 per sec.)
> 
> Test execution summary:
>     total time:                          382.9903s
>     total number of events:              100000
>     total time taken by event execution: 6125.6312
>     per-request statistics:
>          min:                            0.0028s
>          avg:                            0.0613s
>          max:                            0.8482s
>          approx.  95 percentile:         0.0697s
> 
> Threads fairness:
>     events (avg/stddev):           6250.0000/94.01
>     execution time (avg/stddev):   382.8520/0.01
> 
> RELENG_7 from October 16:
> 
> OLTP test statistics:
>     queries performed:
>         read:                            1400000
>         write:                           0
>         other:                           200000
>         total:                           1600000
>     transactions:                        100000 (292.50 per sec.)
>     deadlocks:                           0      (0.00 per sec.)
>     read/write requests:                 1400000 (4095.01 per sec.)
>     other operations:                    200000 (585.00 per sec.)
> 
> Test execution summary:
>     total time:                          341.8797s
>     total number of events:              100000
>     total time taken by event execution: 5468.4663
>     per-request statistics:
>          min:                            0.0028s
>          avg:                            0.0547s
>          max:                            0.8707s
>          approx.  95 percentile:         0.0561s
> 
> Threads fairness:
>     events (avg/stddev):           6250.0000/124.43
>     execution time (avg/stddev):   341.7791/0.01
> 
> -- 
> / Peter Schuller

Peter,

Could you please try this patch Jeff posted in FreeBSD-performance@ ?


 
Regards, 
-Abdullah Ibn Hamad Al-Marri
Arab Portal
http://www.WeArab.Net/


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: =?utf-8?q?uleslice.diff?=
Type: application/octet-stream
Size: 18172 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-current/attachments/20071104/f0cca599/utf-8quleslice-0001.obj


More information about the freebsd-current mailing list