2013/5/22 Rafał Radecki <radecki.rafal@stripped>
> Hi All.
> I use mysql/perconna/maria on my production CentOS 6 Linux servers. I
> currently try to choose the default filesystem for partitions with mysql
> data. Some time ago (previous dba) reiserfs was the choice but now it is
> not in the kernel and the main author is in prison.
> From what I've read xfs and ext4 are valid choices and performance
> benchmarks over the web show that they are "comparable" (no clear winner).
> I've also read that with every new kernel there can be changes in
> performance in every filesystem ( for example
> From your experiences: which filesystem to choose for a mysql db? Is ext4
> or xfs better? Or is it more a case of proper filesystem tuning to my
> workload? Any articles worth reading which you can recommend?
I guess it really depends on your workload, your HW, kernel etc.
From my experience, having XFS with lazy-count=1 and kernels 2.6.31.X gives
better performance in our HW RAID 10 + BBU servers. We do have this
configuration in around 200 DBs without any stability issue.
I still have pending to test ext4/xfs with 3.2.X kernels...