addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1launch-new-window--smalllight-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

#SFMySQL Meetup Message Board › XFS mount settings

XFS mount settings

Ashley M.
user 10165795
Pleasant Hill, CA
Post #: 1
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 S.
WombatNation
Oakland, CA
Post #: 1
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

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy