Date: Tue, 19 Mar 2013 10:28:21 +0100 From: Davide D'Amico <davide.damico@contactlab.com> To: Steven Hartland <killing@multiplay.co.uk> Cc: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <51482FB5.2000305@contactlab.com> In-Reply-To: <394EAD0E59004D1B8D2010F94DDB7C84@multiplay.co.uk> References: <514729BD.2000608@contactlab.com> <810E5C08C2D149DBAC94E30678234995@multiplay.co.uk> <51473D1D.3050306@contactlab.com> <1DD6360145924BE0ABF2D0979287F5F4@multiplay.co.uk> <51474F2F.5040003@contactlab.com> <E106A7DB08744581A08C610BD8A86560@multiplay.co.uk> <51475267.1050204@contactlab.com> <514757DD.9030705@contactlab.com> <42B9D942BA134E16AFDDB564858CA007@multiplay.co.uk> <1bfdea0efb95a7e06554dadf703d58e7@sys.tomatointeractive.it> <897DB64CEBAF4F04AE9C76B3F686E497@multiplay.co.uk> <13317bbd289c4c828f134e2c2592a2d7@sys.tomatointeractive.it> <A3E2B710EF8342CCAF963106E3E747FB@multiplay.co.uk> <01576f39e05f96ab3b3c822531e0c286@sys.tomatointeractive.it> <0D88348E154D43E58597FF40BA41D22F@multiplay.co.uk> <51482E67.8060900@contactlab.com> <394EAD0E59004D1B8D2010F94DDB7C84@multiplay.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
Il 19/03/13 10:26, Steven Hartland ha scritto: > > ----- Original Message ----- From: "Davide D'Amico" > <davide.damico@contactlab.com> >>>> [...] >>>>> I'd recommend doing the same test on the SSD with ZFS as well as that >>>>> would >>>>> give you a simple like for like comparison. >>>> >>>> Here we are: >>>> >>>> # zpool create DATAZFS mfid2 >>>> >>>> 1° round: >>>> General statistics: >>>> total time: 90.1662s >>>> total number of events: 1 >>>> total time taken by event execution: 90.1631s >>>> >>>> 2° round: >>>> General statistics: >>>> total time: 82.3333s >>>> total number of events: 1 >>>> total time taken by event execution: 82.3307s >>>> >>>> 3° round: >>>> General statistics: >>>> total time: 81.5421s >>>> total number of events: 1 >>>> total time taken by event execution: 81.5399s >>>> >>>> 4° round: >>>> General statistics: >>>> total time: 82.1657s >>>> total number of events: 1 >>>> total time taken by event execution: 82.1636s >>>> >>>> >>>> # zfs get all DATAZFS >>>> NAME PROPERTY VALUE SOURCE >>>> DATAZFS type filesystem - >>>> DATAZFS creation Tue Mar 19 7:36 2013 - >>>> DATAZFS used 52.0G - >>>> DATAZFS available 64.2G - >>>> DATAZFS referenced 52.0G - >>>> DATAZFS compressratio 1.00x - >>>> DATAZFS mounted yes - >>>> DATAZFS quota none default >>>> DATAZFS reservation none default >>>> DATAZFS recordsize 128K default >>>> DATAZFS mountpoint /DATAZFS default >>>> DATAZFS sharenfs off default >>>> DATAZFS checksum on default >>>> DATAZFS compression off default >>>> DATAZFS atime off local >>>> DATAZFS devices on default >>>> DATAZFS exec on default >>>> DATAZFS setuid on default >>>> DATAZFS readonly off default >>>> DATAZFS jailed off default >>>> DATAZFS snapdir hidden default >>>> DATAZFS aclmode discard default >>>> DATAZFS aclinherit restricted default >>>> DATAZFS canmount on default >>>> DATAZFS xattr off temporary >>>> DATAZFS copies 1 default >>>> DATAZFS version 5 - >>>> DATAZFS utf8only off - >>>> DATAZFS normalization none - >>>> DATAZFS casesensitivity sensitive - >>>> DATAZFS vscan off default >>>> DATAZFS nbmand off default >>>> DATAZFS sharesmb off default >>>> DATAZFS refquota none default >>>> DATAZFS refreservation none default >>>> DATAZFS primarycache all default >>>> DATAZFS secondarycache all default >>>> DATAZFS usedbysnapshots 0 - >>>> DATAZFS usedbydataset 52.0G - >>>> DATAZFS usedbychildren 225K - >>>> DATAZFS usedbyrefreservation 0 - >>>> DATAZFS logbias latency default >>>> DATAZFS dedup off default >>>> DATAZFS mlslabel - >>>> DATAZFS sync standard default >>>> DATAZFS refcompressratio 1.00x - >>>> DATAZFS written 52.0G - >>> >>> That's got the wrong record size for mysql :( >> >> Sorry, my fault (I've made so many tests...). I'll modify it asap, >> copy the mysql/* files again and posting here the results. > > Is this a test I could possibly run here? I have a machine on test for > mysql so if its something you can let me have the data for I can run > some tests locally too. i don't know if you have installed sysbench 0.5.0 somewhere in you server, but we could test using *standard* oltp tests (the dataset I'm using is strictly private) included in sysbench package. Is it possible, for you? I'm using mysql-5.6.10 enterprise (but I think the one you find in the ports tree it's a good choice, too). Thanks, d.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51482FB5.2000305>