From owner-freebsd-current@FreeBSD.ORG Sun Jan 7 16:25:24 2007 Return-Path: X-Original-To: freebsd-current@freebsd.org Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 75AA916A4A7; Sun, 7 Jan 2007 16:25:24 +0000 (UTC) (envelope-from massimo@cedoc.mo.it) Received: from aa013msr.fastwebnet.it (aa013msr.fastwebnet.it [85.18.95.73]) by mx1.freebsd.org (Postfix) with ESMTP id 0F8B513C461; Sun, 7 Jan 2007 16:25:23 +0000 (UTC) (envelope-from massimo@cedoc.mo.it) Received: from intanto (37.254.91.190) by aa013msr.fastwebnet.it (7.3.105.6) id 452E074A03BF29B9; Sun, 7 Jan 2007 17:14:08 +0100 Date: Sun, 7 Jan 2007 17:14:08 +0100 From: Massimo Lusetti To: Jeff Roberson Message-Id: <20070107171408.1792ad79.massimo@cedoc.mo.it> In-Reply-To: <20070106041435.P586@10.0.0.1> References: <20070104005625.D1508@10.0.0.1> <200701061935.31324.davidxu@freebsd.org> <20070106033749.V586@10.0.0.1> <200701061958.06484.davidxu@freebsd.org> <20070106041435.P586@10.0.0.1> X-Mailer: Sylpheed version 2.2.9 (GTK+ 2.10.6; i386-portbld-freebsd6.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: Kip Macy , freebsd-current@freebsd.org, David Xu , current@freebsd.org Subject: Re: ULE 2.0 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 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: Sun, 07 Jan 2007 16:25:24 -0000 On Sat, 6 Jan 2007 04:15:13 -0800 (PST) Jeff Roberson wrote: > On Sat, 6 Jan 2007, David Xu wrote: > > > On Saturday 06 January 2007 19:38, Jeff Roberson wrote: > > > >> > >> Can you tell me what you are doing? I have a dual core opteron that works > >> fine here running normal things. > > > > It is mysql super-smack, I am trying to get a performance result. > > What threading library and what arguments? select-key? How many threads? I step in just to show some results i got with super-smack. This is -CURRENT as of yesterday (06/01) with mysql 5.1.12 from packages and super-smack 1.13 from ports. I built two kernels, the GENERIC and a GENERIC with ULE instead of 4BSD which i named GENEULE. I got dmesg from both if you're interested. The test box is my laptop which is seens as: Copyright (c) 1992-2007 The FreeBSD Project. Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994 The Regents of the University of California. All rights reserved. FreeBSD is a registered trademark of The FreeBSD Foundation. FreeBSD 7.0-CURRENT #0: Sun Jan 7 13:19:24 CET 2007 root@intanto.datacode.it:/usr/obj/usr/src/sys/GENEULE WARNING: WITNESS option enabled, expect reduced performance. ACPI APIC Table: Timecounter "i8254" frequency 1193182 Hz quality 0 CPU: Genuine Intel(R) CPU T2300 @ 1.66GHz (1662.52-MHz 686-class CPU) Origin = "GenuineIntel" Id = 0x6e8 Stepping = 8 Features=0xbfe9fbff Features2=0xc1a9> AMD Features=0x100000 Cores per package: 2 real memory = 1072168960 (1022 MB) avail memory = 1035640832 (987 MB) FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 During the test the machine was completely idle, expect for super-smack and mysqld of course. The tests cases where select-key and update-select always with 10 clients and 10000 queries each executed 5 times. On every threading library switch the server were restarted. Here the results in order as they were executed. Query_type num_queries max_time min_time q_per_s 4BSD libpthread select_index 200000 2 0 4817.59 select_index 200000 2 0 4793.25 select_index 200000 3 0 4814.93 select_index 200000 2 0 4770.63 select_index 200000 2 0 4819.42 -- update_index 100000 2 0 2131.67 update_index 100000 2 0 2168.52 update_index 100000 3 0 2170.03 update_index 100000 2 0 2169.04 update_index 100000 3 0 2166.57 4BSD libthr select_index 200000 1 0 5079.52 select_index 200000 3 0 4728.71 select_index 200000 3 0 4707.58 select_index 200000 1 0 4682.04 select_index 200000 1 0 4687.51 -- update_index 100000 1 0 2323.26 update_index 100000 2 0 2315.49 update_index 100000 2 0 2365.37 update_index 100000 2 0 2324.08 update_index 100000 2 0 2323.27 ULE libpthread select_index 200000 3 0 4487.76 select_index 200000 0 0 4419.15 select_index 200000 3 0 4104.53 select_index 200000 3 0 4083.51 select_index 200000 4 0 4063.64 -- update_index 100000 3 0 1525.89 update_index 100000 3 0 1532.17 update_index 100000 4 0 1531.36 update_index 100000 4 0 1530.10 update_index 100000 4 0 1520.19 ULE libthr select_index 200000 3 0 4318.65 select_index 200000 8 0 4347.53 select_index 200000 13 0 4327.46 select_index 200000 2 0 4312.92 select_index 200000 3 0 4349.71 -- update_index 100000 3 0 1710.85 update_index 100000 2 0 1731.89 update_index 100000 3 0 1716.59 update_index 100000 3 0 1711.15 update_index 100000 3 0 1697.40 Thanks to all your work and for reading this till the end ;) now i wait to read you further Regards -- Massimo.run(); THE DAILY PLANET SUPERMAN SAVES DESSERT! Plans to "Eat it later"