Date: Mon, 25 Mar 2013 15:45:58 +0100 From: Davide D'Amico <davide.damico@contactlab.com> To: freebsd-performance@freebsd.org Subject: Re: FreeBSD 9.1 vs CentOS 6.3 [WAS Re: freebsd-performance Digest, Vol 119, Issue 8] Message-ID: <51506326.9020109@contactlab.com> In-Reply-To: <5150586E.5040408@contactlab.com> References: <mailman.67.1364212802.87792.freebsd-performance@freebsd.org> <5150586E.5040408@contactlab.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51506326.9020109>