… partition correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… want to start a war but ZFS performance level was less than half of xfs for the tpcc test and that’s… to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… test in asynchronous mode, read performance is an extremely steady 3202MiB/sec with almost no deviation. Write performance is also both very strong… that the card is quite capable of matching the asynchronous performance: Synchronous read reaches peak capacity somewhere between 32 and 64 threads… margin. The approximate raw numbers, in tabular format, are: – EXT4 XFS 13GiB BP 22000 7500 25GiB BP 17000 9000 50GiB BP…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… 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
May 12, 2009 By 4 Comments
… 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
June 15, 2010 By 19 Comments
… 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
November 1, 2007 By 75 Comments
… 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
June 9, 2011 By 13 Comments
… 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
February 9, 2009 By 55 Comments
…@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
May 10, 2010 By 18 Comments
…, 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
October 27, 2009 By 19 Comments
… 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…
