…Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0…here reduced single-thread performance by 5-10%. Sequential write results were a…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 HighPoint…. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5” 15K RPM disks, with price 190… space, or ~ 5.2$ per GB. For SSD I can get 32GB card for 390$, which is ~12.1$ per GB For…
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: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
…–num-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… you need to use XtraDB or MySQL 5.4 ® However there may be small problem …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot of performance differences… and sequential which can be very well taken care of RAID Battery Backed Up cache and when sequentially written to the…, say 512M memory which is battery backed up just as RAID cache so it can handle system restarts. When putting log…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id | select_type | table | type | possible_keys | …1.02 3.21 3.21 102.11 almost all time. As you see 1285 rkB/s is pretty small for RAID…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…. In case innodb_flush_log_at_trx_commit=1 (default) this will be synchronous operation and thread … drives to pick reading any block. RAID controller (and even software RAID driver) typically tracks disk head position … both cases we have 2.2 vs 5.5ms which is 2.5 times difference – This is a lot, …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… performance boost and it would write at 100MBps vs 33MBps. Any plans to enable tuning of the …) for additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_… in 5.0 because of group commit being broken. Most do not have RAID with BBU. With good RAID …
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… on your RAID card). This scenario may also appear when being on battery and your RAID card dies,… 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 when…
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
… about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. …it is already 0.85ms, and for 16 threads – 1.55ms (which is still very good). And something happens…show also results for RAID10 on 8 disks, 2.5” , 15K RPMS each. Random reads: From this graph we…
