… is no enough free buffers. It helps if you have performance drops when data does not fit in memory. Attention!(Windows… of “Ibuf: size” (like > 1000) may tend to losing the performance. If you have powerful IO system, you might set bigger… buffer) In conclusion, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… 750GB, 2.5″, 7200RPM, 16MB, SATA. Intel SSD 910 (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04…, so we can estimate a performance gain. Or in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50… MySQL / Percona Server, especially if you are looking for quick performance boost in IO heavy workload.
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
… 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… you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10… mode with n2 layout Latest mode you can get creating RAID as: mdadm –create –verbose /dev/md0 –level=10 –layout=n2… really usable, and how it performs on regular hard drives or SSD disks. The performance drop in RAID settings is unexpected. I am…
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… you have to consider a lot of topics – security, manageability, performance. I tend to advice different things depending on what is… LVM for backups while assuming you have BBU on the raid volume impact on transactional log write speed is usually minimal…
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… will be cheaper than FusionIO), but it also may improve performance as such setup will be able to handle IO requests…
Post: Intel 320 SSD read performance
July 29, 2011 By 11 Comments
…://www.ssdperformanceblog.com/) While PCI-e Flash cards show great performance, I am often asked about alternatives, as price for PCI…) threads Intel 320 SSD Intel 320 SSD strip RAID ratio RAID/Intel 320 ratio RAID/Intel 320 strip 1 0.53 0.56….22 22.02 As conclusion, this card provides great read performance. A single card provides 5-8x better throughput and 10…
Comment: Intel 320 SSD read performance
August 1, 2011 By 11 Comments
… RAID 10 would be compared to a single drive or RAID 0 SSD array, unless it’s just a baseline for standard RAID performance. RAID 10 is pretty much the preferred RAID method…
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 55 Comments
… in all the testing I’ve done – even for RAID 0. Hardware RAID makes assumptions about the minimum amount of time that…. I’ve tested Adaptec, LSI, 3ware, Highpoint and software RAID. Software RAID performs best for all SSD that I’ve tested, even the…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…, but at the same time you should not have hardware RAID or have one without battery backed up cache (BBU unit… has its overhead anyway so you may not get same performance as with MySQL 4.1 Disable Binary Logging This allows… with MySQL 4.0. MySQL 5.0 can offer substantial performance improvements in variety of cases as well as has other…
