… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… 1.02 3.21 3.21 102.11 almost all time. As you see 1285 rkB/s is pretty small for RAID…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0…5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql… was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This …
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
…two previous posts) I managed to setup all three devices (RAID was on board; Intel X25-E SSD connected to …IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same …space, or ~ 5.2$ per GB. For SSD I can get 32GB card for 390$, which is ~12.1$ per GB …
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
…-threads=$threads –init-rng=on \ –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 run…RAID setup. RAID5 does not show benefits comparing with others, and RAID10,f2 is worse than RAID10. But speaking RAID0 vs…multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…CPU bound, while to understand if MySQL goes through more rows than it… innodb_flush_log_at_trx_commit=1 (default) this will be synchronous …pick reading any block. RAID controller (and even software RAID driver) typically tracks disk…we have 2.2 vs 5.5ms which is 2.5 times difference – This is …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…also appear when being on battery and your RAID card dies, automatically switching from write-back to… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix …2188.38 There is still performance difference binlogs vs no-binlogs, but it is much smaller …
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… Read because of their importance: RAID 10 with LVM vs. RAID 10 only: Random Write: For…RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID…RAID 10 without LVM (Dell poweredge, database size 600G). We scaled out the database so the new database is 1…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…. This is one of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is … performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the … in 5.0 because of group commit being broken. Most do not have RAID with BBU. With good RAID …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1.14 because of all the bad…. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a… and sequential which can be very well taken care of RAID Battery Backed Up cache and when sequentially written to the…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…_at_trx_commit=1 and sync_binlog=1 you will have 4 “sync” operations in MySQL 5.0 – there is … network IO we’re speaking about 300 microseconds vs 5000 microseconds and DRBD overhead can be well … BBU (Battery backed up unit) on your hardware RAID card or something which has same effect, especially …
