Status of MySQL on 7 w/o patches applied
Abdullah Ibn Hamad Al-Marri
wearabnet at yahoo.ca
Sun Nov 4 09:40:25 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-stable/attachments/20071104/f0cca599/utf-8quleslice.obj
More information about the freebsd-stable
mailing list