From owner-freebsd-performance@FreeBSD.ORG Mon Mar 25 14:00:24 2013 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115]) by hub.freebsd.org (Postfix) with ESMTP id C071D860 for ; Mon, 25 Mar 2013 14:00:24 +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 540D4FF0 for ; Mon, 25 Mar 2013 14:00:23 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; d=contactlab.it; s=clab1; c=relaxed/relaxed; q=dns/txt; i=@contactlab.it; t=1364220016; h=From:Subject:Date:To:MIME-Version:Content-Type; bh=2M2BKrk/dsE0PDGpG7Ew8WsXVs2caO4VugbVqRizXPE=; b=c+YFDFtfEmROWF6wAOu0TApImUPoZXFRKZDQrBDpF4c7G8uUKnOqc954RQWxE+jG WnCwRJA1xdXJ8I3IZUz8J/yAU1/IOikxrUwWcxKKqO/JLnSXcTlYP3ToCMOVf0V4 XO8GDWDFW7AnNCYpeX1HfutzERuGzcJmkAV7gRUwK5w=; Received: from [213.92.90.12] ([213.92.90.12:49549] 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 54/38-24145-07850515; Mon, 25 Mar 2013 15:00:16 +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 1UK7we-000GM2-4h for freebsd-performance@freebsd.org; Mon, 25 Mar 2013 15:00:16 +0100 Received: (qmail 62868 invoked by uid 89); 25 Mar 2013 14:00:16 -0000 Received: from localhost (HELO davepro.local) (127.0.0.1) by mx3-master.housing.tomato.lan with SMTP; 25 Mar 2013 14:00:16 -0000 Message-ID: <5150586E.5040408@contactlab.com> Date: Mon, 25 Mar 2013 15:00:14 +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: In-Reply-To: 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:00:24 -0000 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