FreBSD 9.1 and ZFS v28 performances

[Steven Hartland]

----- 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: Monday, March 18, 2013 6:07 PM
Subject: Re: FreBSD 9.1 and ZFS v28 performances


> Il 18/03/13 18:44, Davide D'Amico ha scritto:
>> Il 18/03/13 18:42, Steven Hartland ha scritto:
>>> ----- Original Message ----- From: "Davide D'Amico"
>>> <davide.damico at contactlab.com>
>>>
>>>>> So RAID10 on just 6 disks in effect just 3 active spindles? If so
>>>>> then your
>>>>> throughput of 400MB/s is about right.
>>>> Well, my RAID10 is on 4 disk (2 spindle) so do I have 400MB/s (3GBps)
>>>> because the max throughput is 6Gbps?
>>>
>>> You'll be limited by the actual disks. For your disks this is stated
>>> as 122 to 204MB/s sustained. So if your getting 400MB/s your doing
>>> well :)
>>>
>>
>> Thanks, now it's clear.
> 
> But now I do other tests using a lua script with sysbench with different 
> setups:
> 
> UFS on RAID10 HW:
> General statistics:
>     total time:                          36.1023s
>     total number of events:              1
>     total time taken by event execution: 36.1002s
> 
> UFS on 1 SSD:
> General statistics:
>     total time:                          36.3970s
>     total number of events:              1
>     total time taken by event execution: 36.3948s
> 
> ZFS (mirror mfid3 mfid4 mirror mfid5 mfid6):
> General statistics:
>     total time:                          78.0531s
>     total number of events:              1
>     total time taken by event execution: 78.0509s
> 
> ZFS with ZIL:
> General statistics:
>     total time:                          85.2306s
>     total number of events:              1
>     total time taken by event execution: 85.2285s
> 
> 
> The workload is always the same (a set of 50k mysql myisam queries), and 
> as you can see zfs is really slow compared to ufs, and I don't know why :(
> 
> The latest check I should do is using a L2ARC, but I'll do tomorrow.

Oh and another thing if this is mysql did you set the right settings
for your ZFS volume e.g.
zfs set atime=off tank
zfs create tank/mysql
zfs set recordsize=16k tank/mysql

    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 at multiplay.co.uk.