…instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we… We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on …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
…it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave…. 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…
Comment: When would you use SAN with MySQL ?
March 11, 2009 By 18 Comments
… with, MySQL is fine with 6 SAS/SCSI disks in RAID 5 or RAID 10 before it needs to scale out. Though sure, it depends… find surprising is quite often people dedicate 2 disks in RAID-1 just for OS while OS uses these just to… nice from operations standpoint i.e. you can work with RAID online – format it, move disks around, but really how often…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…lot of information on the box’s hardware, including RAID controllers, installed memory, and so on in the … as mpstat or dstat, that I may also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If …to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By …
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… PE). The test results are consistent across tools used sometimes, or they are the opposite from different tools. So you need… 9’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, LVM… finally 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 my…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID… out different MySQL versions or settings. Moreover, I have… single-thread performance by 5-10%. Sequential write results were …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… with HDD RAID storage – technology we have been using for many years – when there’s striping like in RAID0, 5, 6 or any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly… 1MB boundary. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB if storage…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… is not a definitive conclusion about innodb_old_blocks_pct or innodb_old_blocks_time. It does highlight how a data…_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…
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 disks it gives us 1520$ for 292GB useful space, or ~ 5.2$ per GB. For SSD I can get 32GB card…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… posts out there that discuss RAID minutia. Make sure you cover the following: RAID type (usually 5 or 1+0) RAID stripe size BBU enabled with Write-back cache only No read cache or read-ahead… and keeping in mind future growth. 8-16G for Swap — 10-20G for the OS (/) Possibly 10G+ for /tmp (note you…
