Skip site navigation (1)Skip section navigation (2)
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>