…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.5….: Percona Server has ported the Atomic write support for Fusion-io devices patch from MariaDB. This feature adds atomic write support for directFS filesystem on Fusion-io devices. This feature implementation is considered BETA quality. Percona Server…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… sure to stripe the LV when we need to and align the partition correctly. We got decent tpcc performance, nearly 37k… run a server with hundreds of snapshots. With LVM, your IO performance drops to 33% after the first snapshot so keeping…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… is perform IO mapping from physical to direct addresses. I also wonder whenever it can be also caused by different alignment by…. It is great to leave at times when amount of IO you can push to the storage on the single node…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…caption id=”attachment_12668″ align=”alignleft” width=”229″] Percona XtraBackup 2.0.7 was released … fixed #1116177. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…’t do anything with respect to IO alignment. 2. Misalignment on the partition table, but proper alignment options on the file system. This… with respect to IO alignment yourself. In this case offset is correct, but file system is unaware how to align files properly. 4… plan to look at IO alignment on Flash cards to see what benefits we can get there from proper alignment. You can find…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… on the process of alignment, if you’re curious about benchmark results, here they are. What is IO alignment I would like to start with some background on IO alignment. So what is IO alignment and how does a misaligned IO look like… 10.04 (verified) would by default align to 1MB if storage does not support IO alignment hints which is good enough for most…
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. I wanted to try to put… of operational work which should be spent only when needed. Aligning the Partitions Once you have the partitions, it could look… Aurimas posted two excellent blogs on both the theory of Aligning IO on hardware RAID and some good benchmarks to emphasize the…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & …_RATE: 1240.5728847456533 READ_AHEAD_EVICTED_RATE: 0 LRU_IO_TOTAL: 531 LRU_IO_CURRENT: 0 UNCOMPRESS_TOTAL: 0 UNCOMPRESS_CURRENT: 0… * READ_AHEAD_EVICTED_RATE: 0 LRU_IO_TOTAL: 531 * LRU_IO_TOTAL: 431 LRU_IO_CURRENT: 0 * LRU_IO_CURRENT: 0 UNCOMPRESS_TOTAL: 0…
Comment: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
Vadim, Can you talk more about aligned IO request? Does “size=4096″ always lead to aligned IO or does the actual value of “size” depend on the actual SSD used?
Comment: MySQL: what read_buffer_size value is optimal ?
September 18, 2007 By 25 Comments
… – aligned 128K read will have to be read from single hard drive while 256K could use both hard drives for parallel IO… able to do even more optimization – say you do 2MB aligned read with 128M size – RAID could perform 1M read for… has more hard drives and so in theory must love IO in large blocks.
