Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 05 Jul 2013 13:30:44 +0300
From:      Daniel Kalchev <daniel@digsys.bg>
To:        freebsd-fs@freebsd.org
Subject:   Re: Slow resilvering with mirrored ZIL
Message-ID:  <51D6A054.2070704@digsys.bg>
In-Reply-To: <8280798FCEE74CB08536F3BC43C9207F@multiplay.co.uk>
References:  <2EF46A8C-6908-4160-BF99-EC610B3EA771@alumni.chalmers.se> <51D437E2.4060101@digsys.bg> <E5CCC8F551CA4627A3C7376AD63A83CC@multiplay.co.uk> <CBCA1716-A3EC-4E3B-AE0A-3C8028F6AACF@alumni.chalmers.se> <20130704000405.GA75529@icarus.home.lan> <C8C696C0-2963-4868-8BB8-6987B47C3460@alumni.chalmers.se> <20130704171637.GA94539@icarus.home.lan> <2A261BEA-4452-4F6A-8EFB-90A54D79CBB9@alumni.chalmers.se> <20130704191203.GA95642@icarus.home.lan> <43015E9015084CA6BAC6978F39D22E8B@multiplay.co.uk> <20130704202818.GB97119@icarus.home.lan> <8280798FCEE74CB08536F3BC43C9207F@multiplay.co.uk>

next in thread | previous in thread | raw e-mail | index | archive | help

On 05.07.13 02:21, Steven Hartland wrote:
>
> To give a concrete example which may well be of use for others, we
> had a mysql box here with dual 60GB SSD L2ARC's whic after continuous
> increases in query write traffic we ended up with total IO saturation.
>
> As a test we removed the L2ARC, partitioning them into a 10GB SLOG and
> 40GB L2ARC and the machine was utterly transformed, from constant 100%
> disk IO to 10% as the SLOG's soaked up the sync transfers from mysql.

Also, you removed the ZFS fragmentation issue, which can severely impact 
performance.

Unfortunately, this removes fragmentation for newly written data only, 
old data remains fragmented --- one can only dream for the day when the 
"block pointer rewrite" promise becomes reality... it could do wonders 
to ZFS.

Alternatively, my proposal is for an background rewrite of ZFS blocks, 
that could at least achieve: re-distributing blocks to newly added 
vdevs, "fixing" compression/dedup of datasets, cleaning up fragmented 
data etc.
It should be relatively easy to be implemented... (I am, unfortunately 
not offering coding help due to lack of time)

Daniel



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?51D6A054.2070704>