Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

XFS for MySQL

Infin1tyInfin1ty EntrantInactive User Role Beginner
Hey,
I'm about to run a new a server, 10x256GB SSD Disks, i plan to use RAID5 (i know it's bad, but that's my only option).
I will have an adaptec 5445 raid controller with BBU.

I'm starting to test xfs on some hardware, it's seems as it's faster so i might opt for it.

i'm planning to create the RAID5 array with 16k chunk size, that makes me mount the xfs with sunit=32,swidth=320,nobarrier
mkfs.xfs -f -d sunit=32,swidth=320 <device>, am i correct?
I will use innodb_flush_method = O_DIRECT and innodb_flush_log_at_trx_commit = 1, i should be fine with that?


Thanks!

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    raid5 is pretty slow in writes (vs raid10) but still very good in reads. Question is how much write bound is your environment.

    Don't have much experience with XFS but I guess performance would not much differ from ext4. It would be nice to benchmark both with the same data/traffic.

    I'm curious about SSD's - did you test max read/write bandwith ? I wonder if your controller is able to use full SSD drives speed combined.
  • gmousegmouse Mod Squad Inactive User Role Beginner
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">przemek wrote on Mon, 18 October 2010 20:57</td></tr><tr><td class="quote">
    raid5 is pretty slow in writes (vs raid10) but still very good in reads. Question is how much write bound is your environment.

    </td></tr></table>
    Do you have a source for that statement when a decent raid controller is used?
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">Quote:</td></tr><tr><td class="quote">

    Don't have much experience with XFS but I guess performance would not much differ from ext4. It would be nice to benchmark both with the same data/traffic.
    </td></tr></table>
    I haven't seen benchmarks, but XFS is definitely faster.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.