[EMAIL PROTECTED] wrote:
I've found XFS to be painfully slow.Hi,
I'm trying to set up a new Opteron-Based MySQL-Server. The only thing I'm unsure about is which filesystem to choose..
ext3? ReiserFS? XFS? What's your experience?
Thanks
chris
I haven't tried ext3.
I have used reiser3 on our servers ( mysql, apache, squid, sendmail, courier-imap, samba ) for almost 5 years with no issues. It's quite fast and is excellent at disaster recovery - we've had a couple of 'issues' where the power cord has been pulled from the server, and everything came back up quite nicely.
I've also been building desktops here at work with reiser4. I haven't had any issues with it yet, but it's up to you whether you consider it stable enough yet. If I was rebuilding our server, I'd do it, but I know many people would call me a fool for doing so. Works for me. It's *very* fast. You have to patch your kernel as it's not yet included in the vanilla sources.
If you want to play it safe, you really can't go wrong with reiser3.
You can also use raw partitions with MySQL, which will make it a *little* bit faster than what you can get from putting your data into a filesystem. I haven't done it myself, but I've seen it mentioned in the mailing list. Check the archives / web site. I think you have to use InnoDB to use raw partitions, but I might be wrong.
Dan
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
