Based on what I've seen so far, JFS and XFS do not yet have a solid track record of stability with MySQL. This does not mean they could not be good - I just do not trust them yet. I do vaguely remember a support case when a very strange corruption happened on either one of them - now cannot recall which one. In 3 years of handling MySQL supoprt (2000-2003), I do not recall reports of table corruption on a ReiserFS file system. I do remember corruption cases in the early ext3.
Thought I should reply with my experience on this.
I've been running various ( the most recent ) versions of MySQL-4.0.x since it was released on a Gentoo box with an XFS filesystem. XFS has never given us any problems. Ever.
We even had a disaster the other day, where my boss pulled the power on the server. The XFS recovery went without a hitch, and the InnoDB recovery also went without a hitch.
This server is under moderate load:
IMAP server for 38 clients. MySQL server for 30 or so MS Access clients ( as well as 3 PHP clients ). Setiathome full-time.
Having said that, XFS isn't particularly fast, at least for what I like doing. I just moved everything to a RAID 1 array, formatted as a Reiserfs system ( just did this tonight ). XFS was particularly slow doing the IMAP stuff - I assume because courier-imap stores things in lots of small files. XFS was also very slow doing Gentoo's 'emerge' searches. Reiserfs is much faster at both of these.
But I thought I'd better post and say that XFS has been 100% stable for me, and if it weren't for the speed hit, I would have stayed with it.
Dan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
