… for both single card and raid (Duo). Random writes, async: We see stable and predictable write performance, with throughput: 660 MiB/s… Duo. Now with separation per thread for random read synchronous IO: There is also excellent response time characteristics. 0.25ms and…. In general ioDrive2 seems to provide better and more stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d…
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 10… traditional InnoDB log flushing, which can cause downward spikes in performance. Other then that, I have also disabled query cache to… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
I’m often asked how one can evaluate IO subsystem (Hard drive RAID or SAN) performance for MySQL needs so I’ve decided… by RAID cache and uncached IO performance. We’re interested in cached reads because they may show latency to the RAID cache if RAID read… executed with pretty uniform performance. Let us now do the test with single thread and write-through RAID cache (as if there…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… next graphs show the frequency of IO, and you can see we can get more IO performance with the new patches. Then, how…. It is not tested at all… control_io-threads.patch Generally RAID storage can parallelize IO accesses to several disks. This patch enables… buffer) In conclusion, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to… majority of normal configurations. Are there ways to squeeze more performance out of a server by dividing the logical volumes: perhaps…/O bound and need to squeeze every last ounce of performance from the box. Fiddling with how to allocate drives and…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
…-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect… steps: mdadm -v –create /dev/md0 –chunk=256 –level=raid1 –raid-devices=2 /dev/sdj /dev/sdk mdadm -v –create /dev… if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… the case. There are whole classes of systems where Disk performance is not that important – consider for example systems where most… not require too much IO capacity or high in memory fit. For large number of applications optimizing IO performance will be number one… LVM for backups while assuming you have BBU on the raid volume impact on transactional log write speed is usually minimal…
Post: RAID System performance surprises
March 5, 2008 By 7 Comments
… case – to protect your data RAID controller may implement bunch of algorithms which can affect performance dramatically. For example speaking about PERC5… it wakes up it will some IO resources (30% by default) which will affect your performance some way. Consistency Checks This is… stopped performance during the time you planned investor show case or other important event. Learn what cron jobs does your RAID card…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID…performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads can do, and IO…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
…, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is worth to consider price/performance parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS… gives 4800$. Now simple dividing TPM on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO…
