… something as important as an Operating System or major component like a File System on the basis of ONE fairly small…look at the bug list or patch list for MySQL/InnoDB at any one point in time. The list…the wall at me. Worse, someone electing to use ext3/4 because of your post. In the second event…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… facto filesystem for many modern Linux system, I am getting a lot of… it comes to known problem in ext3, where IO gets serialized per i…consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or… –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… note when error is discovered during the operation EXT3, EXT4 filesystem will force file system check on the next startup which is handy… file will take out whole file system. I do not think these concerns are valid. First with recent Linux versions and quality hardware EXT3… very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will assert and restart. Now…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total… dropped 20 times. This could be because ext3 does not like so many files in directory or because random updates to 10000… 100 1000 10000; do ./benchmark.php $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
… reported strange problem with MySQL having extremely poor performance when sync-binlog=1 is enabled, even though the system with RAID and… to see if EXT3 can be fixed in this regard as it is by far the most common file system for Linux. It is also worth to investigate if something can be done on MySQL side – may be…
Post: Working with many files and file system fragmentation
March 18, 2008 By 11 Comments
… optimization project (not directly MySQL related) we did a test – creating 100 files writing 4K in the random file for some time and… file at 80MB/sec while fragmented files only deliver about 2MB/sec – this is a massive difference. The test was done on EXT3 and it looks like it does not do very good job preventing file fragmentation for large amount of growing files. It…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
… in-house apps include testing MySQL with a variety of file systems (ext3, jfs, xfs), a variety of storage engines (MySQL 5.0 with InnoDB…
Post: Slow DROP TABLE
June 16, 2009 By 21 Comments
… is when the slow file removal on the ext3 file system starts to be a pain. Deleting a 10GB file can take a few seconds and if that is a MySQL table… seems to be changing the file system. To XFS for example, which handles file removals much more efficiently: EXT3 mysql> drop table large_table; Query…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…) and pointer-based block-map technologies of the log structured file systems (WAFL, ZFS). With log structured filesystems you get snapshots practically… ext3 + snapshot performance. “randomio” might not be a good representation of what MySQL is doing so we are currently testing xfs with MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…flatfiles 30GB ext3 EBS This is an ext3 volume which contains the flat files for… an even data distribution in the system. To get an even distribution, …mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file…
