… my colleague Aurimas posted two excellent blogs on both the theory of Aligning IO on hardware RAID and some good benchmarks to emphasize the point, go read those if you need the theory here. Is it common on…’s use some simple ones: /var/lib/mysql xfs nobarrier,noatime,nodiratime Setting the IO scheduler This is a commonly missed step…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…here’s what happened – for XFS file system on a raw partition I…RAID controller cache set to Write-Through and then to Write-Back. 1. Baseline – misalignment on…cache gave an incredible performance boost – up to 33x in single-threaded … running sideways with the same hardware, but with a misaligned IO….
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… running in particular roadblocks with it try XFS. You can use noatime and nodiratime options …cases this setting improves performance. Though be careful if you do not have battery backed up RAID cache … take MySQL with defaults run it on hardware without battery backed up cache with no OS changes …
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…setting up ext2/3/4 file system is sticking to defaults when it comes to behavior on…/4 while over systems like XFS will not continue if consistency …Inode blocks per group: 128 RAID stride: 8 RAID stripe width: 80 Flex block…the error popping up you are very likely looking at hardware issues which …
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… now have to scale up – cheap memory, fast storage, …18GB worth of data+indexes) XFS Filesystem mounted with nobarrier option….Hardware was our Dell 900 (specs here). To start with, we have a test on…t know what your working set is – ask us! Important note… pool, GB FusionIO Intel SSD RAID 10 2 450.3 …
