On Thu, Mar 07, 2013 at 02:15:31PM +0100, Julien FERRERO wrote:
> > We actually test brutal "Power off" for xfs, ext4 and other file systems. If
> > your storage is configured properly and you have barriers enabled, they all
> > pass without corruption.
> > What hardware raid cards can do is to hide a volatile write cache. Either on
> > the raid HBA itself or, even worse, on the backend disks behind the card.
> > S-ata disks tend to default to write cache enabled and need to be checked
> > especially careful (sas drives tend to be write cache disabled by default).
> Write cache is supposed to be disabled on the H/W RAID (according to
> hdparm) and barrier are correctly enabled since xfs does not report
> any warning at mount.
> The odd thing is we never see this with kernel 2.6.18 where barriers
> weren't yet available.
Yes they were. XFS had barrier support added in 2.6.15.
> An other difference is the "unwritten extend"
> that was used to set to 0 by default. Now we cannot change this
> setting according to an old thread I've found: "unwritten extents on
> linux are generally a bad idea, this option should not be used.".
Yes, that would have been me that said that. I started seeing lots
of boy-racer "tweak your filesystem to go faster" blogs recommending
that unwritten extents should be turned off high up in google
results, with numbers to prove that it improved performance.
There were two common things wrong with these blogs:
1. None of them mentioned that turning off unwritten extents
exposes stale data to users. i.e. a whopping great big
2. they reported significant performance improvements for
workloads that *didn't use unwritten extents* when they set
this flag. i.e. they mistook run-to-run variablity of the
benchmark for a performance improvement. i.e. Benchmarking
When you get people who do not understand what they are doing and
giving bad advice as the first 10 hits for a google search about
optimising/tuning XFS filesystems, it's a major concern, and so I
took steps to ensure you can't turn off unwritten extents with
> Unfortunately, the engineer that chose this setting is no longer
> working with us...
It sounds like he read one too many of these blogs, because if mysql
is triggering speculative preallocation, it is not using unwritten