…? I mean this: http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/ http://www…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD is more visible… mention I have strange results on xtradb running it on xfs on RAID10, I have results about 2times slower than for ext3. I am not sure yet – is it xtradb or xfs problem, and why it appears only on RAID10, but not SSD.
Post: FlashCache: first experiments
May 10, 2010 By 18 Comments
… ( 1 gen firmware) ( Model Number: SSDSA2SH032G1GN INTEL, Firmware Revision: 045C8621) * SSD-2: Intel X25-M 160GB ( 2 gen ) ( Model Number: INTEL…, Firmware Revision: 2CV102HA ) * FlashCache: build over SSD-1 or SSD-2 * Filesystem XFS, builds as: mkfs.xfs -f -d su=16384,sw=40 /dev…* are placed on separate RAID partition ( not on FlashCache or SSD) * Benchmark: sysbench oltp ( read-only and read-write modes), 80mln…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 26 Comments
… the overwrite DIO performance problem: http://oss.sgi.com/archives/xfs/2012-02/msg00219.html Now that the prerequisite fixes have… check this was the problem – I don’t have a SSD available right now, so I ran the tests on a… throughput being in GB/s sync async threads throughput throughput XFS ext4 XFS ext4 1 1.90/124k 1.41/92k 1…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… of FlashCache, for help with that) is 16KB alignment in XFS and FlashCache. As developers recommend to have 16KB block size in XFS and 16KB block size in FlashCache, I was not able… about 70GB of data. I allocated 35GB for cache on SSD and I used 16GB and 10GB buffer pool sizes. I…
Comment: MySQL performance: Impact of memory allocators (Part 2)
March 9, 2013 By 12 Comments
tobi, you are asking this in a wrong place. You may go and file a bug report to glibc developers (actually we may do it also). My previous report on ext4 vs xfs http://www.mysqlperformanceblog.com/2012/03/15/ext4-vs-xfs-on-ssd/ resulted that the fix for XFS is included in RedHat/CentOS 6.4
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… significant. Here’s another example of misalignment, described in SGI xfs training slides: D stands for the disk here so the… size, here’s how we would create the file system: xfs – mkfs.xfs -b size=4k -d su=64k,sw=5 /dev… in 512-bytes internally. This however gets more complicated with SSD drives which often operate in 4kbyte units, though this is…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… take that long to remove.” ‘Note that on ext4 and xfs you should not have this problem as they would remove… linux but was recommended for ext4. If they made an SSD as fast as Ram or if one was to raid 10 a bunch of SSD‘s then we could put the Innodb straight to SSD and not even use any Ram and it would remove …
Comment: btrfs - probably not ready yet
May 23, 2012 By 17 Comments
Andy, you may see discussion ext4 vs xfs there http://www.mysqlperformanceblog.com/2012/03/15/ext4-vs-xfs-on-ssd/ In short: at this point of time, my opinion, that ext4 can provide better throughput. But feature wise you may decide for yourself.
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… close to 100%. As you may know (check my presentation) SSD design requires background “garbage collector” activity, which requires space to… 5.3 2-6.18.164 Kernel Filesystem is XFS formatted with mkfs.xfs -s size=4096 option ( size=4096, sector size…
