… MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… server and give ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master… seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10… –concurrency=25,50,100,200,500,1000,2000 –iterations=10 –number-int-cols=6 –number-char-cols=6 –auto…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…_time=1000 on MySQL 5.5.30 and testing multiple buffer pools on MySQL 5.5.30. Finally, MySQL 5.6.10 has many additional tuning… 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5.6 response times…’t a disk problem, I pointed the MySQL 5.6.10 at the MySQL 5.5.30 data directory. Tthe speed was essentially the…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id | select_type | table | type | possible_keys | … see 1285 rkB/s is pretty small for RAID 10 system we have on this server. This …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…… # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | …Adding LVM here reduced single-thread performance by 5-10%. Sequential write results were a bit more …
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…. Here is my very rough calculation: For RAID 10 we use 8 73GB SAS 2.5” 15K RPM disks, with price 190$ per… simple dividing TPM on price of IO system, we have RAID 10 – 4.8 TPM / $ SSD – 27 TPM / $ FusionIO – 3.6 TPM…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… RAID0, 5, 6 or any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly… misalignment on the file system, you can see how RAID ends up doing 5 IO operations – two to D4 and one on… 1MB boundary. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB if storage…
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
…(R) Xeon(R) CPU X5650 RAID controller: Perc H800 RAID configuration: RAID 5 over 11 disks + 1 hot spare. RAID 5 is chosen for space purposes. In this configuration using 600GB disk, we can get 5… will show the best possible gain. I do measurements every 10 sec to see stability of results. Graphical result: Tabular: Tables…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU enabled… and keeping in mind future growth. 8-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you… gave above: RAID 1+0: is a set of mirrored drives, so the number here is num drives / 2. RAID 5: is striped…
Post: RAID throughput on FusionIO
March 24, 2010 By 7 Comments
… maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards. In short conclusion, RAID10… mount options. OS is CentOS 5.3 with 2.6.18-128.1.10.el5 kernel. For RAID modes I use: single card… Latest mode you can get creating RAID as: mdadm –create –verbose /dev/md0 –level=10 –layout=n2 –raid-devices=4 –chunk=64 /dev…
