May 26, 2012

Post: Setting up XFS on Hardware RAID -- the simple edition

… and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options….normal configurations.  Are there ways to squeeze more performance out of a server by dividing the logical…enabled with Write-back cache only No read cache or read-ahead No drive write cache enabled …

Post: read_ahead (disabled) as steroid

… took improvements from 5.4 and backported ones performance related to XtraDB. Here are results for tpcc… control of “read_ahead”. And if in the same benchmark you disable read-ahead (innodb_read_ahead=none), you…have strange results on xtradb running it on xfs on RAID10, I have results about 2times …

Post: Virident tachIOn: New player on Flash PCI-E cards market

… 5.3 2-6.18.164 Kernel Filesystem is XFS formatted with mkfs.xfs -s size=4096 option ( size=4096, sector size… needed for FusionIO tuning. First graph is random reads, so see compare read performance As you see in 1 and 4 threads FusionIO… like FlashCache, where card have both concurrent read and write pressure Quite stable sequential writes performance (important in question for log related…

Post: Innodb Performance Optimization Basics

… of Hardware OS And Application optimization. I call this Innodb Performance Optimization Basics so these are general guidelines which work well… if you’re running in particular roadblocks with it try XFS. You can use noatime and nodiratime options if you’re… in READ-COMMITED isolation mode – if it does – set it to be default as transaction-isolation=READ-COMMITTED. This option has some performance

Post: Aligning IO on a hard disk RAID – the Benchmarks

… the performance improved another 20-40%. It took me a while to figure it out, but here’s what happened – for XFS… bad idea File IO benchmark results Sequential read results are expectedly the least interesting. Read-ahead kicked in immediately giving ~9’600… cache enabled, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads…

Comment: Disaster: LVM Performance in Snapshot Mode

…@udbqa006.sf2p ~]# mount /dev/mapper/VolGroup20-mysqldata on /data type xfs (rw,noatime,allocsize=1g) [root@udbqa006.sf2p ~]# ls -l /data…” performance. But once the snapshot is created it plummets again. It’s the same reason – a write turned into a COW read… + snapshot performance. “randomio” might not be a good representation of what MySQL is doing so we are currently testing xfs with MySQL…

Post: FlashCache: first experiments

…, to see what performance benefits we can expect. For initial tries I took sysbench oltp tests ( read-only and read-write) and case…: build over SSD-1 or SSD-2 * Filesystem XFS, builds as: mkfs.xfs -f -d su=16384,sw=40 /dev/sdc * mounted… X25-M, probably X25-M in second generation has better performance characteristics ( I will post sysbench fileio benchmarks). Also what is…

Comment: Linux schedulers in tpcc like benchmark

… Linux). Very short recap with some numbers (40 simultaneous seq reads): XFS+noop: 140MB/s EXT3+noop: 133MB/s EXT4+noop: 111MB…) EXT2+noop: 97MB/s XFS+cfq: 30MB/s Some comments on this setup: – XFS beats EXT*, with EXT4 performing badly and also being…

Post: linux.conf.au 2012 roundup

…on a variety of topics – everything from filesystem performance to open hardware, to repurposing existing hardware … Corbet You can skip this only if you read every single mail on LKML, run your … a lot of the recent improvements in XFS. Especially interesting for those with metadata heavy workloads….

Post: RAID throughput on FusionIO

…in the previous experiment, as I am running XFS with nobarrier mount options. OS is CentOS 5…usable, and how it performs on regular hard drives or SSD disks. The performance drop in RAID settings…disks read/110810.08 read/1666316.29 write/18830.49 write/1618687.97 raid10 n2 read/111612.89 read/1699170…