…. 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: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
Robert, I wonder if you are using ext3? The performance of dropping large tables is mostly bound by IO when using ext3. XFS can drop large files much more quickly.
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… system are you using? Unjournalled, like ext2, or journaled, like ext3, xfs? If you’re running Windows, do you useFAT32 of NTFS…
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…
