… particularly evident when using the ext3 file system (instead of xfs). Use FLUSH LOGS instead of sending SIGHUP When copytruncate is…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
1) Would you recommend EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems …
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
… how data was lost: MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There… what I learned while working on this case: Recovering from XFS is possible. Just a month ago we had a team… did not try any of the file recovery tools for xfs – apparently they are all targeting specific file types and sure…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with… not test it. At this point we may decide that xfs is still preferable, but there is one more point to… running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted… not start on a RAID stripe boundary. Create the Filesystem XFS requires a little massaging (or a lot). For a standard…, but let’s use some simple ones: /var/lib/mysql xfs nobarrier,noatime,nodiratime Setting the IO scheduler This is a…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… poping up again. Long story is: I started with puting XFS on SSD and running very primitive test with INSERT INTO… ignores write barriers (see http://dammit.lt/2008/11/03/xfs-write-barriers/ ), but again with enable write-cache you may… sure what is good ones – another are for research 4. XFS without LVM is putting barrier option which decreases write performance…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 26 Comments
… MySQL, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from… that ext4 worked really well out of the box, while XFS required poorly documented knobs to be turned and still couldn… statistically significant impact on performance, which seems to indicate that XFS had some bottleneck internally, maybe the lock contention issue that…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 26 Comments
… the overwrite DIO performance problem: http://oss.sgi.com/archives/xfs/2012-02/msg00219.html Now that the prerequisite fixes have… throughput being in GB/s sync async threads throughput throughput XFS ext4 XFS ext4 1 1.90/124k 1.41/92k 1… above patch forward ported to 3.4-pre-RC1, the XFS results are: sync async threads throughput throughput vanilla patched vanilla…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
… run “randomio” benchmark on ext3 filesystem and compared it with xfs. The difference with LVM snapshot is big. “randomio” opens its…@udbqa006.sf2p ~]# mount /dev/mapper/VolGroup20-mysqldata on /data type xfs (rw,noatime,allocsize=1g) [root@udbqa006.sf2p ~]# ls -l /data… very fast (you can preallocate space in vxfs and in xfs – I use a mount option allocsize=1g). The second problem…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… minimize the effects of misalignment. File system of choice was XFS. Barriers and physical disk cache was disabled. The tool I… slightly below 1TB. Investigating this I found that 32-bit xfs inodes (which are used by default) have to live in… written before this was set may still be unaligned, though xfs defragmentation may be able to fix that (not verified). 6…
