…. This problem is particularly evident when using the ext3 file system (instead of xfs). Use FLUSH LOGS instead of sending SIGHUP When…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… make sure but results were basically the same. Using XFS instead of EXT3 gives expected results – we get 2350 transactions/sec with…% overhead. EXT2 filesystem also behaves similar to XFS so it seems to be EXT3 specific performance issue. We do not know if…. Innodb transactional log does not have the same problem on EXT3. I expect this is because Innodb log is pre-allocated…
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… thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with… running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…
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….1 146.0 Good – xfs matches raw – with or without snapshot. Now let’s look at ext3 with the same size file… on ext3 + snapshot performance. “randomio” might not be a good representation of what MySQL is doing so we are currently testing xfs…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… (Does Dell have referral program ? ), with RAID10 (8 disks) on ext3, 32GB of RAM. As you see there almost no difference… the same benchmarks on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD… on xfs on RAID10, I have results about 2times slower than for ext3. I am not sure yet – is it xtradb or xfs…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… table. Here is when the slow file removal on the ext3 file system starts to be a pain. Deleting a 10GB… be changing the file system. To XFS for example, which handles file removals much more efficiently: EXT3 mysql> drop table large_table; Query OK, 0 rows affected (7.44 sec) XFS mysql> drop table…
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…). However, I was not able to get good numbers with XFS on Debian. What are some of the recommended…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the days of ext2/ext3. So I decided to use sysbench and plot some graphs to compare the O_DIRECT performance of ext4 and XFS… statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally, maybe the lock contention issue that…
Comment: Drop table performance
April 21, 2011 By 22 Comments
…-land-of-io/ ) There 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, but still many issues remains…
Comment: Drop table performance
April 20, 2011 By 22 Comments
…-land-of-io/ ) 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, but still many issues remains…
