… majority of normal configurations. Are there ways to squeeze more performance out of a server by dividing the logical volumes: perhaps… want to use mysql on /dev/sda3, but how can we ensure that it is aligned with the RAID stripes? It takes… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
… write buffering and write merging. Performance is another story. RAID is usually easiest way to get extra performance from your IO subsystem. Spreading… solutions have comparable price/performance, though former depends on your application quite a lot. I think MySQL is pretty well supported by…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
…, so we can estimate a performance gain. Or in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50… pay attention is a density of results. In case with RAID it is much more dense. So I build a graph… 910 is suitable to use with MySQL / Percona Server, especially if you are looking for quick performance boost in IO heavy workload.
Post: RAID System performance surprises
March 5, 2008 By 7 Comments
Implementing MySQL database in 24/7 environments we typically hope for uniform component performance, or at least would like to be able… also tend to accumulate in predictable fashion. If you have RAID controller this well may not be the case – to protect your data RAID controller may implement bunch of algorithms which can affect performance dramatically. For example speaking about PERC5…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least not with Dell RAID controllers, H700 and… testing as part of complex IO subsystem performance testing – if you have RAID check what performance is going to be with failed hard…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… smart software instead of simple RAID you use with directly attach storage which can magically improve performance ? There are cases when it…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… time), it uses MySQL C API and the server side prepared statement. The server has 8core CPU and RAID storage (RAID10 / 6… is no enough free buffers. It helps if you have performance drops when data does not fit in memory. Attention!(Windows… buffer) In conclusion, If you are using fast RAID storage, and/or observe performance decrease caused by shortage of free buffers you…
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… you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not… get benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be small…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may… the case. There are whole classes of systems where Disk performance is not that important – consider for example systems where most… LVM for backups while assuming you have BBU on the raid volume impact on transactional log write speed is usually minimal…
