… MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need… server and give ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS…, the storage will still be working. Also, instead of having 1 or 2 spare drives per controller, I have 2 for…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on mariadb 5….14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 … mysqlslap –concurrency=25,50,100,200,500,1000,2000 –iterations=10 –number-int-cols=6 –number-char-cols=6 –auto-…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… NULL, `l_comment` varchar(44) NOT NULL, `l_shipmode` char(10) NOT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber`), KEY `lineitem….62 2441.07 4.93 1220.53 2.46 8.10 1.02 3.39 3.39 102.18 Device: rrqm/s….82 2570.49 9.84 1285.25 4.92 8.10 1.02 3.20 3.20 102.01 dm-0 0… 1.02 3.21 3.21 102.11 almost all time. As you see 1285 rkB/s is pretty small for RAID 10… 0.21 1091.94 3.10 8763.64 26.45 4381.82 13.22 8.03 1.02 0.94 0.93…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32…= VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-0) 2…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly aligned to disk sectors… 1MB boundary. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB if storage… working on partition table. RAID stripe Further down below on the storage stack there’s a group of RAID stripe units (elements…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… and keeping in mind future growth. 8-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you… disks in the RAID. This turns out to be the same as the size formulas I gave above: RAID 1+0: is a…, so the number here is num drives – 1. In our case, it is RAID 1+0 64k stripe with 8 drives. Since those…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… for SSD (note it is single device, in comparison to RAID 10 on 8 disks) and FusionIO are impressive, it is worth… price/performance parameter. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5″ 15K RPM disks… I can get 32GB card for 390$, which is ~12.1$ per GB For FusionIO I really not sure what is…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… (software RAID over 2x200GB devices) Filesystem: ext4 Software OS: Ubuntu 12.04.1 MySQL Version: Percona Server 5.5.27-28.1 Benchmark… Results There is a jitter graph of Throughput taken every 10 sec: I put number of median throughput, so we can… in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50 GB55231825.76 75 GB109457295.24 So gain is…
Comment: Cache Performance Comparison
January 24, 2007 By 74 Comments
… 2 giga of memory, 2 disks SAS 140 giga in RAID 1 I obtain the following results: Array Cache Time: 146546 Gets….shm_prune_period=”0″ eaccelerator.shm_only=”0″ eaccelerator.compress=”1” eaccelerator.compress_level=”9″ eaccelerator.keys = “shm” eaccelerator.sessions = “shm… coma_bug : no fpu : yes fpu_exception : yes cpuid level : 10 wp : yes bogomips : 3993.56 Linux version 2.6.16…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
…’42” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID 5 16000 88 232 124 99 330 1359 10’28” RAID 5… chose RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID 10 in… from previous RAID 10 without LVM (Dell poweredge, database size 600G). We scaled out the database so the new database is 1/3…
