Yes, since XFS uses transactional model, metadata checksums may be sufficient. With full … block size. lzjb seems interesting, hadn’t heard of it before. @Nils, In a way that is true. Imagine running InnoDB over XFS… – one that of InnoDB and other of XFS itself. In case of InnoDB, the block size – 16k – is much larger than 4k and…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… have their own optimizations for this (like larger btrfs metadata block size etc.). b) For #a, it would be nice if btrfs… 3.9) and zfsonlinux (latest) are benchmarked. c) Regarding integrity, XFS from 3.10 is going to have metadata checksums. d…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… 13MiB/sec. When we calculate in the fact that the block size in use here is 16KiB, these numbers equate to over… upon the usual factors (read/write ratio, working set size, buffer pool size, etc.) but overall the card is extremely quick and… sysbench OLTP: It is worth noting here that EXT4 outperforms XFS by a fairly significant margin. The approximate raw numbers, in…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… a mutex for slow log writes. Truncation can block MySQL because the OS serializes access to … using the ext3 file system (instead of xfs). Use FLUSH LOGS instead of sending SIGHUP …/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/…
Post: ext4 vs xfs on SSD
March 15, 2012 By 26 Comments
… running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result significantly… for numthreads in 4 do sysbench –test=fileio –file-total-size=${size}G –file-test-mode=rndwr –max-time=3600 –max-requests…=0 –file-io-mode=sync –file-block-size=16384 –report-interval=10 run | tee -a run$size.thr$numthreads.txt done done Follow…
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… / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00051fe9 Device Boot Start End Blocks Id System /dev… blks, lazy-count=1 realtime =none extsz=4096 blocks=0, rtextents=0 The XFS FAQ is a good place to check out…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… 512-byte blocks, for bigger files 4k may make more sense (you can’t use blocks bigger than 4k (page size) on Linux… 64k stripe unit size and 4k file system block size, here’s how we would create the file system: xfs – mkfs.xfs -b size=4k -d… * 512 = 512 bytes Disk identifier: 0×00091218 Device Boot Start End Blocks Id System /dev/sda1 * 63 19535039 9767488+ 83 Linux /dev…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… that) is 16KB alignment in XFS and FlashCache. As developers recommend to have 16KB block size in XFS and 16KB block size in FlashCache, I was not able to make it working, there too many moving parts – it’s XFS alignment by RAID strip size, XFS aligned file allocation, raid partition should be created aligned by 16K block, etc. In…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
… limited to EXT2/3/4 while over systems like XFS will not continue if consistency problems are discovered. So … 226918400 Block count: 3630694400 Reserved block count: 0 Free blocks: 3616208434 Free inodes: 226918374 First block: 0 Block size: 4096 Fragment size: 4096 Reserved GDT blocks: 316 Blocks …
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… same as in the previous experiment, as I am running XFS with nobarrier mount options. OS is CentOS 5.3 with… echo “====== testing $blksize in $threads threads” echo PARAMS $size $mode $threads $blksize > sysbench-size-$size-mode-$mode-threads-$threads-blksz-$blksize for i…-block-size=$blksize run \ | tee -a sysbench-size-$size-mode-$mode-threads-$threads-blksz-$blksize 2>&1 done done sysbench –test=fileio –file-total-size=$size…
