mysql performance on 4 * dualcore opteron
Steven Hartland
killing at multiplay.co.uk
Thu Apr 20 10:24:58 UTC 2006
Just retested on a dual dual core so 2 * as quick as before
Dual 265 ( 4 * 1.8 Ghz Cores )
== 4BSD + libthr + ACPI-Fast ==
super-smack -d mysql select-key.smack 100 10000
Query Barrel Report for client smacker1
connect: max=36ms min=0ms avg= 18ms from 100 clients
Query_type num_queries max_time min_time q_per_s
select_index 2000000 13 0 38965.71
super-smack -d mysql select-key.smack 10 100000
Query Barrel Report for client smacker1
connect: max=2ms min=0ms avg= 1ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 2000000 0 0 42344.21
Dual 244 ( 2 * 1.8 Ghz Cores )
== 4BSD + libthr + ACPI-Fast ==
super-smack -d mysql select-key.smack 100 10000
Query Barrel Report for client smacker1
connect: max=107ms min=2ms avg= 45ms from 100 clients
Query_type num_queries max_time min_time q_per_s
select_index 2000000 13 0 22413.39
super-smack -d mysql select-key.smack 10 100000
Query Barrel Report for client smacker1
connect: max=2ms min=1ms avg= 1ms from 10 clients
Query_type num_queries max_time min_time q_per_s
select_index 2000000 0 0 26841.07
So pretty good scaling there.
Steve
================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.
In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137
or return the E.mail to postmaster at multiplay.co.uk.
More information about the freebsd-performance
mailing list