EBS+RAID10+XFS slower than EBS+RAID10+EXT3 using MySQL?

Posted by Johann Tagle on Server Fault See other posts from Server Fault or by Johann Tagle
Published on 2012-06-11T08:02:10Z Indexed on 2012/06/11 10:42 UTC
Read the original article Hit count: 299

Filed under:
|
|
|

We're currently using EC2 with 16 EBS volumes in RAID10 configuration for our MySQL data. I know some people don't recommend to put EBS volumes to RAID but that's not what I'm concerned about at the moment. Current format is ext3, but we're experimenting with moving to xfs, given many reports that it is faster. However, we're actually experiencing a performance degradation when the partition was converted to xfs - a benchmark run with inserts, updates, selects and deletes was more than 10 seconds slower using xfs.

Any idea what could be the problem? Below is the fstab entry (really only changed ext3 to xfs). Database tables are innodb and we are using innodb_file_per_table.

/dev/mapper/vg_data-lv_data /data xfs noatime 0 0

Thanks.

© Server Fault or respective owner

Related posts about mysql

Related posts about amazon-ec2