… be connected together via software RAID. So I tested in two modes: single drive, and software RAID-0 over two drives. I should… for both single card and raid (Duo). Random writes, async: We see stable and predictable write performance, with throughput: 660 MiB/s…. 0.25ms and 0.19ms for 8 threads, single and Duo cases. In general ioDrive2 seems to provide better and more stable performance…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…/O Performance: High API name: m2.4xlarge As for the IO configuration I chose 8 x 200G EBS volumes in software RAID…_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer pool is sized… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
…most ALTER operations, but pt-online-schema-change performs the ALTER without any locking. Client applications …rapidly, for example, to support new types of RAID controllers. Percona Toolkit is a hot topic … today, there is also a version 1.0 GA release of the Percona Monitoring Plugins project…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
… asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided to write… by RAID cache and uncached IO performance. We’re interested in cached reads because they may show latency to the RAID cache if RAID… 5305556 86932 10534192 0 0 0 9634 1715 5033 0 0 74 26 1 1 90560 5305556 86932 10534192 0 0 0 9235 1643 5035 0 0 73 26 You…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-0) 2 2-…, single thread performance improvement is marginal however WB cache brings single thread random write performance close to what …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… majority of normal configurations. Are there ways to squeeze more performance out of a server by dividing the logical volumes: perhaps… out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU enabled…/O bound and need to squeeze every last ounce of performance from the box. Fiddling with how to allocate drives and…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_method = O…. ramfs), the bigger value may help the performance. * This test uses “innodb_read_ahead = 0” (The both of read-ahead are disabled… buffer) In conclusion, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you…
Post: Intel 320 SSD read performance
July 29, 2011 By 10 Comments
…://www.ssdperformanceblog.com/) While PCI-e Flash cards show great performance, I am often asked about alternatives, as price for PCI… strip RAID ratio RAID/Intel 320 ratio RAID/Intel 320 strip 1 0.53 0.56 6.13 11.57 10.95 2 0.72 0.59….22 22.02 As conclusion, this card provides great read performance. A single card provides 5-8x better throughput and 10…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect… \ –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 run \ >> sysbench-size-$size-mode-$mode-threads-$threads 2>&1… you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not…
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 8, 2010 By 20 Comments
… (usually 4 drives, they tried hardware RAID, software RAID, RAID 1+0 and RAID 0), but in all cases the RAID controller or software couldn’t predict… usable NAND flash on the FusionIO cards to improve write performance during emergency groomer maintenance when the card is out of… down format the cards by 25-35% to get that performance during LEB exhaustion. As for redundancy and stripping FIO cards…
