Re: mysql super-smack test on FreeBSD 5.3-RC1 amd64

--On Friday, October 22, 2004 15:55:08 +0900 Ganbold 
<ganbold_at_micom.mng.net> wrote:

> Here's benchmark I just did...
>
> -----------------------------------------------------------------------
> System Specs:
>
> IBM _at_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
>
> _______________________________________________
> freebsd-current_at_freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-current
> To unsubscribe, send any mail to "freebsd-current-unsubscribe_at_freebsd.org"
>

Did you turned of HTT?
try to set "sysctl machdep.hlt_logical_cpus=1" and test again.
did you compile with linuxthreads or pthreads?