Date: Fri, 22 Oct 2004 14:48:37 +0900 From: Ganbold <ganbold@micom.mng.net> To: "jesk" <jesk@killall.org> Cc: freebsd-current@freebsd.org Subject: Re: FreeBSD5.3-RC1 MySQL Performance Message-ID: <6.1.2.0.2.20041022144600.02b597c0@202.179.0.80> In-Reply-To: <001301c4b7fc$99487240$45fea8c0@turbofresse> References: <001301c4b7fc$99487240$45fea8c0@turbofresse>
next in thread | previous in thread | raw e-mail | index | archive | help
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=B4s, 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= =20 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=3D64000000 >key_buffer_size=3D1024M >table_cache=3D128 >thread_cache_size=3D128 >max_connections=3D1000 >---- > >maybe someone got some hints for improvement of this situation... > >regards, >jesk > > >_______________________________________________ >freebsd-current@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-current >To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org"
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?6.1.2.0.2.20041022144600.02b597c0>