mysql super-smack test on FreeBSD 5.3-RC1 amd64
Ganbold
ganbold at micom.mng.net
Fri Oct 22 00:55:41 PDT 2004
Here's benchmark I just did...
-----------------------------------------------------------------------
System Specs:
IBM @server 325 type 8835
Dual AMD Opteron 2.1ghz
4GB (2x2GB) PC-2700 ECC memory
6x36GB hot swap RAID5 Ultra 320 SCSI HDD
ServeRAID 6M controller
-------------------------------------------------------------------------
OS / Software Configuration:
FreeBSD amd.micom.mng.net 5.3-RC1 FreeBSD 5.3-RC1 #1: Fri Oct 22 12:17:38
ULAT 2004 root at amd.micom.mng.net:/usr/obj/usr/src/sys/AMD amd64
MySQL Compiled from mysql40-server port with:
BUILD_OPTIMIZED=yes
BUILD_STATIC=yes
amd# super-smack update-select.smack 30 10000
Query Barrel Report for client smacker
connect: max=14ms min=5ms avg= 7ms from 30 clients
Query_type num_queries max_time min_time q_per_s
select_index 300000 3 0 4231.18
update_index 300000 3 0 4231.18
amd# super-smack select-key.smack 30 10000
Query Barrel Report for client smacker1
connect: max=18ms min=5ms avg= 11ms from 30 clients
Query_type num_queries max_time min_time q_per_s
select_index 600000 4 0 10030.74
regards,
Ganbold
More information about the freebsd-current
mailing list