Date: Tue, 19 Mar 2013 09:26:12 -0000 From: "Steven Hartland" <killing@multiplay.co.uk> To: "Davide D'Amico" <davide.damico@contactlab.com> Cc: freebsd-fs@freebsd.org Subject: Re: FreBSD 9.1 and ZFS v28 performances Message-ID: <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>
next in thread | previous in thread | raw e-mail | index | archive | help
----- 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.
Regards
Steve
================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it.
In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337
or return the E.mail to postmaster@multiplay.co.uk.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?394EAD0E59004D1B8D2010F94DDB7C84>