… our customers reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better performance. The problem could be repeated with SysBench as follows: ./sysbench…% overhead. EXT2 filesystem also behaves similar to XFS so it seems to be EXT3 specific performance issue. We do not know if it…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… else (i.e. xfs) should be used. Traditionally our recommendation is xfs, and it comes to known problem in ext3, where IO gets…/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4… running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… backup. EXT3 file system works OK in most cases, though if you’re running in particular roadblocks with it try XFS. You… default as transaction-isolation=READ-COMMITTED. This option has some performance benefits, especially in locking in 5.0 and even more…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… quite important. I run “randomio” benchmark on ext3 filesystem and compared it with xfs. The difference with LVM snapshot is big. “randomio…) all of the indirect address blocks are cached and ext3 resumes the “raw” performance. But once the snapshot is created it plummets… on ext3 + snapshot performance. “randomio” might not be a good representation of what MySQL is doing so we are currently testing xfs with…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
Last week we were busy to align XtraDB performance with 5.4, now we have some results. Currently it …). Basically we took improvements from 5.4 and backported ones performance related to XtraDB. Here are results for tpcc-like workload… the same benchmarks on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… ext2/ext3. So I decided to use sysbench and plot some graphs to compare the O_DIRECT performance of ext4 and XFS on… XFS instead of btrfs, and his feedback was that some recent developments in the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation), so maybe it’s time to do another benchmark. What I found with XFS…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… sometimes have a much more severe impact on the MySQL performance that it would seem. When or why? When you run… be changing the file system. To XFS for example, which handles file removals much more efficiently: EXT3 mysql> drop table large_table… may not be that simple, because the actual removal is performed by the storage engine, so it’s not something MySQL…
Comment: Drop table performance
April 21, 2011 By 22 Comments
Dave, There is one big problem with ext3, and unfortunately it was not fixed with ext4. It is … is also know performance issues with ext3 and sync_binlog http://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/ And in general XFS shows better and stable performance than ext3. ext4 looks better than ext3…
Comment: Drop table performance
April 20, 2011 By 22 Comments
Dave, There is one big problem with ext3, and unfortunately it was not fixed with ext4. It is …/ ) There is also know performance issues with ext3 and sync_binloghttp://www.mysqlperformanceblog.com/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/ And in general XFS shows better and stable performance than ext3. ext4 looks better than ext3…
Comment: Beware: ext3 and sync-binlog do not play well together
April 6, 2009 By 19 Comments
…’ve ran several sysbench tests with ext3, ext2, and XFS. I noticed a huge performance hit with ext3 and sync_binlog=1 and only…). However, I was not able to get good numbers with XFS on Debian. What are some of the recommended…
