I have heard that there have been talks at MySQL UC on running MySQL (InnoDB) on top of XFS for better write concurrency than ext3.
Last weekend I had a chance to discuss on Twitter the xfs stack overflow problem (that became apparent this month, on x86_64 systems with 8k stack) and how it would affect (if any) MySQL servers. If I understand correctly, the problem is that stack overflow might occur when a dirty page needs to be paged-out to xfs.
The conclusion was that for stability of MySQL running on xfs:
- xfs should not be used on top of LVM or any other MD (i.e. software RAID, etc.)
- xfs volumes should only contain ibdata files (that are accessed using O_DIRECT) so that the files on xfs would never exist as dirty pages within the OS
- Togetter - まとめ「xfs stack overflow」 (the discussion on Twitter, in Japanese)
- LKML: John Berthels: PROBLEM + POSS FIX: kernel stack overflow, xfs, many disks, heavy write load, 8k stack, x86-64 (on-going discussion on LKML how to fix the problem)
- Bug 240077 – Panic under high disk I/O (stack overflow: XFS + LVM) (a bug-report involving MySQL on the issue)