2
votes
1answer
4k views

Recommended filesystem for MySQL (xfs vs ext4)

Setting up a MySQL 5.5 server, and wondering what the recommended filesystem is? ext4 or xfs? Running InnoDB and 40% writes 60% reads. Thanks.
2
votes
3answers
808 views

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

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 ...
3
votes
1answer
789 views

XFS Check/Repair Fails

I have a mysql database server on an EC2 instance with 3 drives in a Raid 0 array. This morning the server crashed and after inspecting the logs, I noticed a Structure Needs Cleaning error(i.e. System ...
0
votes
1answer
507 views

How should I setup an Ubuntu server on EC2 (MySQL, code location, etc..)?

I've started to fiddle around EC2, and I can't seem to understand the "AWS way" of setting up a server. I'm using Ubuntu server 10.10 64 bit, from an official AMI by Canonical. There is an EBD drive ...
2
votes
4answers
739 views

Linux filesystem suggestion for MySQL with a 100% SELECT workload

I have a MySQL database that contains millions of rows per table and there are 9 tables in total. The database is fully populated, and all I am doing is reads i.e., there are no INSERTs or UPDATEs. ...
0
votes
2answers
525 views

best filesystem for mysql @ net-volume @ ec2

What is the best filesystem to use for EC2 network volume to be used for mysql database? And what mount options to use? Specifically is there a better option then xfs +noatime? This is the option I ...