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
