Mysql server - which filesystem to choose? Is it really that important nowadays?
- 1 Messages
- Collapse All
- Expand All
- Subscribe
May 22
=?ISO-8859-2?Q?Rafa=B3_Radecki?= Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22, 2013; 08:55
=?ISO-8859-2?Q?Rafa=B3_Radecki?=
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.
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.
May 22
Manuel Arostegui Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22, 2013; 09:22
Manuel Arostegui
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22
Tim Callaghan Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22, 2013; 11:09
Tim Callaghan
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22
Rick James RE: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 22, 2013; 18:20
Rick James
RE: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23
Manuel Arostegui Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23, 2013; 11:02
Manuel Arostegui
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23
Johan De Meersman Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23, 2013; 12:49
Johan De Meersman
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23
Tim Callaghan Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
May 23, 2013; 07:15
Tim Callaghan
Re: Mysql server - which filesystem to choose? Is it really that important nowadays?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!