From owner-freebsd-current@FreeBSD.ORG Fri Oct 22 06:48:56 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B6D3816A4CE for ; Fri, 22 Oct 2004 06:48:56 +0000 (GMT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4F9B943D31 for ; Fri, 22 Oct 2004 06:48:53 +0000 (GMT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.41 (FreeBSD)) id 1CKtGX-000OSf-2e; Fri, 22 Oct 2004 14:51:11 +0800 Message-Id: <6.1.2.0.2.20041022144600.02b597c0@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.1.2.0 Date: Fri, 22 Oct 2004 14:48:37 +0900 To: "jesk" From: Ganbold In-Reply-To: <001301c4b7fc$99487240$45fea8c0@turbofresse> References: <001301c4b7fc$99487240$45fea8c0@turbofresse> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable cc: freebsd-current@freebsd.org Subject: Re: FreeBSD5.3-RC1 MySQL Performance X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 22 Oct 2004 06:48:56 -0000 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"