From owner-freebsd-performance@FreeBSD.ORG Sat Dec 1 22:35:18 2007 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 15D2116A420 for ; Sat, 1 Dec 2007 22:35:18 +0000 (UTC) (envelope-from bsam@ipt.ru) Received: from services.ipt.ru (services.ipt.ru [194.62.233.110]) by mx1.freebsd.org (Postfix) with ESMTP id BCF4A13C4D5 for ; Sat, 1 Dec 2007 22:35:17 +0000 (UTC) (envelope-from bsam@ipt.ru) Received: from bb.ipt.ru ([194.62.233.89]) by services.ipt.ru with esmtp (Exim 4.54 (FreeBSD)) id 1Iyaky-0006pg-IO; Sun, 02 Dec 2007 01:24:16 +0300 To: Gergely CZUCZY References: <20071129101729.GA57985@harmless.hu> <20071130143023.I884@192.168.1.107> <20071201163334.GA21709@harmless.hu> From: Boris Samorodov Date: Sun, 02 Dec 2007 01:22:38 +0300 In-Reply-To: <20071201163334.GA21709@harmless.hu> (Gergely CZUCZY's message of "Sat\, 1 Dec 2007 17\:33\:34 +0100") Message-ID: <10228705@bb.ipt.ru> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (berkeley-unix) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Cc: freebsd-performance@freebsd.org Subject: Re: mysql scaling questions X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 01 Dec 2007 22:35:18 -0000 On Sat, 1 Dec 2007 17:33:34 +0100 Gergely CZUCZY wrote: > I am using sysbench, with read-write tests. > The test-table has 10M tuples, and i'm querying it for two minutes. [...] > The testbox has a dual opteron 246, 12G of memory and a 3ware-9550 with > two disks in a mirror for the rootfs (also this is where the mysql datafiles > were, except for the ZFS setup). The freebsd has mysql-5.0.45_1. > As you see for the best case linux outperforms fbsd7 around twice, > this means that i couldn't reproduce jeff@'s results. 3ware driver is under GIANT at 7.x. I don't know if it's the same for linux. WBR -- Boris Samorodov (bsam) Research Engineer, http://www.ipt.ru Telephone & Internet SP FreeBSD committer, http://www.FreeBSD.org The Power To Serve