… 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: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same…, 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…
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… performance and you should stay on MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial performance…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… IO Subsystem – directly attached storage with plenty of spindles and RAID with battery backed up cache is a good bet. Typically… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… scenario may also appear when being on battery and your RAID card dies, automatically switching from write-back to write-through…. Write-back cache is must-have for an environment demanding performance, of course, yet batteries periodically die, and the fix provides… see, enabling binary logs with system without writeback cache impacts performance significantly. And the similar with writeback cache enabled thread trx…
Post: Innodb Double Write
August 4, 2006 By 24 Comments
… page upate operation or “former” in which case Innodb will perform update. If page is inconsistent recovery can’t proceed. Now… stripe border requiring multiple IO requests. Same happens with Hardware RAID on power failure if it does not have battery backed… double write buffer. How much does double write buffer affect MySQL Performance ? Even though double write requires each page written twice its…
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
…control the transaction log record size, as better performance may be gained with 4096 byte records …all, your transaction will never complete. Both the MySQL configuration and hardware will affect the speed …use a battery backed raid card. This allows updates to be written to the raid cards battery …
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
… a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when… good price for hardware with decent base specs – 64bit CPUs, RAID remote reboot and serial console, backup etc. Plus we had… less lucky and in about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I went…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… tuning was done. The goal was to see how MySQL 5.6 performs out-of-the-box as compared to 5.5… memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs… the MySQL 5.6 server, rebooted and verified again. Same issue. This was very different from MySQL 5.5.30, which performs significantly…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
… open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines… 7200rpm RAID10 battery backed RAID array was used as the underlying storage for the virtual machines. Baseline: The MySQL command line client… a small subset of the data, performance can be improved significantly: $ cat shards.ini [default] user=mysql db=ontime password= port=5029…
