1

Is there any advantage for XFS file system compared with ext3, With MYSQL DB ?

Which is safest file system for hosting MYSQL DB ?

1

XFS was designed to handle large files efficiently. This could be an advantage if your database is very large or if all of your tables are stored in InnoDB format (since the data then resides in one large file). In consequence, you should get a performance boost out of it.

I cannot really make a judgement on the safety of any particular file system, other than the general comment that running any database without appropriate backups is madness. Also, in a production system I would NEVER run a database on anything else but a RAID array.

  • Sure .. We are with the RAID 5 and having the replica as well as the daily backup. With googling I can see the XFS is much faster than ext3, and further reading I think ext-4 can be better with considering safety with performance (Journal checksumming). – Arunjith May 24 '11 at 6:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.