From owner-freebsd-performance@FreeBSD.ORG Mon Mar 25 14:46:01 2013 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 1A77BF6A for ; Mon, 25 Mar 2013 14:46:01 +0000 (UTC) (envelope-from davide.damico@contactlab.com) Received: from mail2.shared.smtp.contactlab.it (mail2.shared.smtp.contactlab.it [93.94.37.7]) by mx1.freebsd.org (Postfix) with ESMTP id A146D3F8 for ; Mon, 25 Mar 2013 14:46:00 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; d=contactlab.it; s=clab1; c=relaxed/relaxed; q=dns/txt; i=@contactlab.it; t=1364222759; h=From:Subject:Date:To:MIME-Version:Content-Type; bh=TedF7Lv3mXMB5+OUXndoIHCSy/Cw448nrp77Y+4fi8U=; b=s+BD79xsIk6bywY6yXnFzocWZGocMCPSvFeArI9yPWRzvtOxYHMLBzHrUBdHpURh gso/y7WIshiUl6jO2xwqHN2mZ5dhCbOATeSbXsXWDjkMGkhTyGIuxb3LQ2m49V9l Al8l42sJTypP9/K5n+YKcxnOd81CFDVwViAkaiXvlO0=; Received: from [213.92.90.12] ([213.92.90.12:39017] helo=mail3.tomato.it) by t.contactlab.it (envelope-from ) (ecelerity 3.5.1.37854 r(Momo-dev:3.5.1.0)) with ESMTP id 51/7E-24145-72360515; Mon, 25 Mar 2013 15:45:59 +0100 Received: from mx3-master.housing.tomato.lan ([172.16.7.55]) by mail3.tomato.it with smtp (Exim 4.80.1 (FreeBSD)) (envelope-from ) id 1UK8et-000Jet-CD for freebsd-performance@freebsd.org; Mon, 25 Mar 2013 15:45:59 +0100 Received: (qmail 75569 invoked by uid 89); 25 Mar 2013 14:45:59 -0000 Received: from localhost (HELO davepro.local) (127.0.0.1) by mx3-master.housing.tomato.lan with SMTP; 25 Mar 2013 14:45:59 -0000 Message-ID: <51506326.9020109@contactlab.com> Date: Mon, 25 Mar 2013 15:45:58 +0100 From: Davide D'Amico User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:17.0) Gecko/20130307 Thunderbird/17.0.4 MIME-Version: 1.0 To: freebsd-performance@freebsd.org Subject: Re: FreeBSD 9.1 vs CentOS 6.3 [WAS Re: freebsd-performance Digest, Vol 119, Issue 8] References: <5150586E.5040408@contactlab.com> In-Reply-To: <5150586E.5040408@contactlab.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 25 Mar 2013 14:46:01 -0000 Il 25/03/13 15:00, Davide D'Amico ha scritto: > Thank you Daniel for your tests, here my tests using sysbench v0.5 MySQL > Benchmarks r/w (80%/20%) test on 10.000.000 rows 2.000.000 query using > Standard OLTP: values represent the number of transactions per second > and the first number is obtained using 1 thread, the second one using 2 > threads, 4, 8, 12, 16, 24, 32, 48 and 64 threads. > > CentOS 6 5.6.10-ent: > 4163 7653 10905 12511 13556 14832 16270 16733 16925 16895 > > VM CentOS 6 5.6.10-ent VMWare 5.1: > 3201 5543 8299 12823 14331 15658 16842 15946 11529 9457 > > VM FreeBSD 9.1 5.6.10-ent VMWare 5.1 (*): > 2102 3572 5917 8060 7905 7734 7104 7304 7612 7058 > > VM FreeBSD 9.1 5.6.10-ent VMWare 5.1 (**): > 2026 3290 4927 ... (I stopped the tests because it seems similar to the > previous one) > > FreeBSD 9.1 5.6.10-ent ZFS+SSD: > 2780 4371 6876 8202 8077 7780 7563 7632 7960 8062 > > FreeBSD 9.1 5.6.10-ent ZFS tweaked+SSD: > 2589 4679 6438 7073 7121 7227 7132 7273 7623 7672 > > Well, CentOS outperforms FreeBSD in every thread concurrency, and not > only in standard oltp tests. > I think I'll use CentOS for mysql servers. > > Thank you for all your time spent, support and tests. > > d. > > > (*) > Using: > - sysctl.conf: > - kern.eventtimer.periodic=1; > - kern.timecounter.hardware=ACPI-fast; > - loader.conf: > - kern.hz=100; > > (**) > Using: > - sysctl.conf: > - kern.eventtimer.periodic=1; > - kern.timecounter.hardware=ACPI-fast; > - loader.conf: > - kern.hz=100; > - malloc.conf -> 3N Well, because of a misunderstanding the previous tests were related to oltp.lua dataset/workload, using the oltp_simple I have: VM FreeBSD 9.1 5.6.10-ent VMWare 5.1: 2919 4758 8661 14075 16436 16328 17172 17636 17926 18218 CentOS 6: 5677 11253 22129 32096 45800 47091 42608 13097 12979 13282 FreeBSD 9.1: 2874 5179 9154 13199 14291 11627 19766 19887 21197 21787 I don't know is these tests could help finding where the problem is, I hope so. I can do other test until wednesday 27/03 if you need. Thanks, d.