Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
2013/5/22 Tim Callaghan tmcallag...@gmail.com Rafal, I don't believe TRIM is supported for XFS. I tried this two weeks ago and worked pretty well: http://xfs.org/index.php/FITRIM/discard Manuel.
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
- Original Message - From: Rick James rja...@yahoo-inc.com Subject: RE: Mysql server - which filesystem to choose? Is it really that important nowadays? ext does less well with simultaneous IOPs than xfs. Possibly, but how much less (and which ext)? Without numbers that's not very helpful :-) I think that the underlying FS is only a major concern in setups where the load is explicitly I/O-bound - that is to say, where the active dataset is significantly larger than the available memory. I do not think the majority of installations match that description. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
Thanks for the information, I'll give it a try myself. On Thu, May 23, 2013 at 5:02 AM, Manuel Arostegui man...@tuenti.com wrote: 2013/5/22 Tim Callaghan tmcallag...@gmail.com Rafal, I don't believe TRIM is supported for XFS. I tried this two weeks ago and worked pretty well: http://xfs.org/index.php/FITRIM/discard Manuel.
Mysql server - which filesystem to choose? Is it really that important nowadays?
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 http://gtowey.blogspot.com/2013/02/serious-xfs-performance-regression-in.html ). 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? Best regards, Rafal.
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
2013/5/22 Rafał Radecki radecki.ra...@gmail.com 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 http://gtowey.blogspot.com/2013/02/serious-xfs-performance-regression-in.html ). 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? Hi Rafal, 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... Manuel.
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
Rafal, I benchmark a lot on various hardware and software configurations. When I started 2 years back I went along with the general consensus that XFS is faster than ext4 for MySQL. I recently had the opportunity to see how much of a difference, if any, it made. I didn't find much, especially on SSD. The benefit of ext4 on SSD (on newer kernels) is that it supports the TRIM functionality (add discard to your /etc/fstab file for the particular file system). I don't believe TRIM is supported for XFS. -Tim On Wed, May 22, 2013 at 2:55 AM, Rafał Radecki radecki.ra...@gmail.comwrote: 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 http://gtowey.blogspot.com/2013/02/serious-xfs-performance-regression-in.html ). 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? Best regards, Rafal.
RE: Mysql server - which filesystem to choose? Is it really that important nowadays?
ext does less well with simultaneous IOPs than xfs. -Original Message- From: Manuel Arostegui [mailto:man...@tuenti.com] Sent: Wednesday, May 22, 2013 12:22 AM To: Rafał Radecki Cc: mysql@lists.mysql.com Subject: Re: Mysql server - which filesystem to choose? Is it really that important nowadays? 2013/5/22 Rafał Radecki radecki.ra...@gmail.com 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 http://gtowey.blogspot.com/2013/02/serious-xfs-performance- regression- in.html ). 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? Hi Rafal, 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... Manuel. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Which Filesystem to choose?
Chris, - Original Message - From: [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, October 18, 2004 10:24 AM Subject: Which Filesystem to choose? 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? my impression is that all three have the same performance and reliability. Opteron + Linux as a platform, on the other hand, still seems to have quite a few unexplained hardware faults or OS bugs. Thanks chris Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which Filesystem to choose?
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: 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? ext3 is the safest. For both others I'd suggest you to have UPS for your server. XFS is sensitive to power outages. For InnoDB consider using raw partitions or raw disks as a storage. This will give you more performance/reliability and this will let InnoDB have full control over the storage space, bypassing the filesystem layer. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which Filesystem to choose?
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which Filesystem to choose?
[EMAIL PROTECTED] wrote: 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've found XFS to be painfully slow. 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]