… Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should… in 100 do cd /mnt/stec sysbench –test=fileio –file-num=1 –file-total-size=${size}G prepare sync echo 3 > /proc…=$numthreads –rand-init=on –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384 –report-interval…
Comment: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… for external fragmentation (file system fragmentation, which you can check with filefrag on ext2/3(/4)? or xfs_db on xfs) could be partition… your file system is extents based (xfs) or not (ext2/3(/4)?) — you should get a lot more fragmentation with non-extents based file systems if you write to many tables (or externally writing other files in the same partition). As…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… fact that ext3 is not the most efficient file system out there and for example file removals can be painfully slow and cause… is when the slow file removal on the ext3 file system starts to be a pain. Deleting a 10GB file can take a few… | The only alternative seems to be changing the file system. To XFS for example, which handles file removals much more efficiently: EXT3 mysql> drop…
Comment: Learning about MySQL Table Fragmentation
May 5, 2008 By 20 Comments
… your file has. This works on just about any file system (on linux). If running XFS, xfs_bmap gives you much more detailed output. xfs_fsr will also (online) defragment the file. You can also use xfs_io to…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… performance when sync-binlog=1 is enabled, even though the system with RAID and BBU were expected to have much better… to make sure but results were basically the same. Using XFS instead of EXT3 gives expected results – we get 2350 transactions… this regard as it is by far the most common file system for Linux. It is also worth to investigate if something…
Comment: ext4 vs xfs on SSD
March 19, 2012 By 26 Comments
…) disks. The file systems on this “inherited” machine default to ext4, but I had Domas’ claims in my mind that xfs is superior… repeated the sysbench run. Up to 8 threads xfs was few percent faster (~10% on average). At 16 threads … lost it’s bite, but was still constantly better than xfs. I did not look deeper into this, but used the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… but beware of random writes to RAID5. Operating System First – run 64bit operating system. We still see people running 32bit Linux on… backup. EXT3 file system works OK in most cases, though if you’re running in particular roadblocks with it try XFS. You can use noatime and nodiratime options if you’re using innodb_file_per_table and a…
Comment: Setting up XFS on Hardware RAID -- the simple edition
December 17, 2011 By 9 Comments
The tuning of the file system for the raid stripe size is strange to me. What … the array standpoint there is no application impact, but with xfs it sounds like you want to reformat each time the… tune the file system for the RAID config. My storage array for example spreads i/o across every spindle in the system(assuming…
Post: Recovery after DROP [ TABLE | DATABASE ]
July 19, 2009 By 4 Comments
… can’t help, as table / directory with files was deleted (if you have innodb-file-per-table). And the same for MyISAM… / .MYI / .frm – files are deleted in this case. So first step after DROP is to restore files, and for ext3 file system there are…, one of them is to restore deleted files. I don’t know such tools for xfs, so in this case DROP will…
Comment: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…-like OS? If so, what file system are you using? Unjournalled, like ext2, or journaled, like ext3, xfs? If you’re running Windows, do you useFAT32 of NTFS? I suspect you’re using journaled file systems, although they…
