FreeBSD5.3-RC1 MySQL Performance

Ganbold ganbold at micom.mng.net
Thu Oct 21 23:48:56 PDT 2004


Hi,

At 03:01 PM 10/22/2004, you wrote:
>Hello,
>
>i found some time to make some performance tests with mysql under
>FreeBSD5.3-RC1. Hardware is a HP DL360 with 2x2,8GHz Xeon CPU´s, 2GB,
>deactivated HTT and u160/10krpm scsi drive. For reference values i took a
>RedHat Fedora with native threads (NPTL) on 2.6 kernel and the same
>hardware. for benchmarks i used super-smack with the default smack files.
>the MySQL backend was MyISAM.

I'm going to test mysql 4.0.21 on Dual AMD Opteron 2.1GHz, 4GB RAM, 6x36GB 
RAID5
machine. Does super-smack run on AMD64 machine?
What other benchmark tool do I need?

Ganbold


>with both setups the mysql was always under high load which seemed to me for
>a good sign to recognize expressive values on thread execution and mysql
>performance without loosing to much time in i/o.
>
>the benchmark is executing 1000 sql-select queries*10 concurrent clients on
>a 90k row table with a random not really high cacheable where-statement on
>the index:
>----
>15985 queries per second
>(pthreads without process scope threads, sched_4bsd and preemption)
>6139   queries per second
>(pthreads with process scope threads, sched_4bsd and preemption)
>10779 queries per second
>(linuxthreads, sched_4bsd and preemption)
>fedora result:
>11900 queries per second
>----
>same test (same parameters) but with a update query first and then a select
>query on the same key i realized worse values for freebsd:
>----
>2027.52 queries per second
>(pthreads without process scope threads, sched_4bsd and preemption)
>1146.66 queries per second
>(pthreads with process scope threads, sched_4bsd and preemption)
>3040.78 queries per second
>(linuxthreads, sched_4bsd and preemption)
>fedora result:
>3920.21 queries per second
>----
>
>i checked if i could tune up the update query procedure with writing on a
>ramdisk, but this wasnt a highly profit.
>if i could use the mixture of linuxthreads on updates and pthreads on select
>queries without the use of proc scope it would
>be a good answer to linux, but fedora wasnt reachable in its update
>operation..
>
>
>here the relevant used mysql values in this test:
>----
>query_cache_size=64000000
>key_buffer_size=1024M
>table_cache=128
>thread_cache_size=128
>max_connections=1000
>----
>
>maybe someone got some hints for improvement of this situation...
>
>regards,
>jesk
>
>
>_______________________________________________
>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"



More information about the freebsd-current mailing list