FreBSD 9.1 and ZFS v28 performances

[Steven Hartland]

----- Original Message ----- 
From: "Davide D'Amico" <davide.damico at contactlab.com>
> 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.

How does ZFS compare if you do it on 1 SSD as per your second
UFS test? As I'm wondering the mfi cache is kicking in?

While running the tests what sort of thing are you
seeing from gstat, any disks maxing? If so primarily
read or write?

    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.