The SF MySQL Meetup Group Message Board › XFS mount settings

XFS mount settings

Ashley Martens
Posted May 26, 2010 10:30 AM
user 10165795
Pleasant Hill, CA
Post #: 1
Send an Email Post a Greeting
Hello everyone,

I'm setting up some new database machines and am going to use XFS to solve a problem we were seeing with ext3, however I don't have a lot of experience with the XFS mount options. Sooo I was wondering if people in the group have example mount options for a heavily used DB. If you have different options for your binlog mount from your DB mount then please specify which is which.
Robert Stewart
Posted May 27, 2010 10:08 AM
WombatNation
Oakland, CA
Post #: 1
Send an Email Post a Greeting
Check out the Linux Optimization presentation from the last MySQL Conference.

A couple relevant notes I took from that presentation:


  • Use BBWC on raid cards. Then, disable write cache on disks.
  • Don't set write barrier if using BBWC
  • Facebook moved from ext3 to xfs. ext3 very slow to delete large files. Makes dropping large table slow.
  • With xfs, disable write barrier with "nobarrier". Concurrent writes possible with O_DIRECT
  • Fusion SSD cards are 2-3 times faster than Intel SSD cards and 10-20 times faster than HDD. Fusion cards really benefit from xfs.
Powered by mvnForum

Our Sponsors

Percona

Food, drinks, books and speakers.

Continuent

Logo, signs & swag.

IGN Entertainment

Time, money, swag, food, drinks & facilities

CBS Interactive

Food, beverages & facilities

O'Reilly User Group Program

The O'Reilly User Group Program provides the great books we get monthly.

MySQL

A great database for us all to use! :)

Other nearby
Meetups
Why these groups?
x

The Meetup Groups shown here are topically similar to The SF MySQL Meetup Group.

Groups are more likely to be displayed here if they:

  • have a Meetup scheduled
  • have a high rating
  • have a group photo
  • are "public" and not "private"
  • have shown they are likely to stick around (older than 30 days)
Find more Meetup Groups
near San Francisco

Log in

  • Not registered with us yet?

Forgot your password?

or

Log in to Meetup with your Facebook account.

Sign up

or

Join this Meetup Group even quicker with your Facebook account.

By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service