FreBSD 9.1 and ZFS v28 performances

[Davide D'Amico]

Il 19/03/13 10:18, Steven Hartland ha scritto:
>
> ----- Original Message ----- From: "Davide D'Amico"
> <davide.damico at contactlab.com>
> To: "Steven Hartland" <killing at multiplay.co.uk>
> Cc: <freebsd-fs at freebsd.org>
> Sent: Tuesday, March 19, 2013 7:12 AM
> Subject: Re: FreBSD 9.1 and ZFS v28 performances
>
>
>> [...]
>>> 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.

Thanks,
d.