… the write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe… server and give ZFS a try. So I trashed the raid-10 arrays, configure JBODs and gave all those drives to ZFS… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…write 100,000 queries in about 50-60 seconds to mysql 5.1 and in about 6-9 seconds on … 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: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid)…And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic…different MySQL configurations, I didn’t try out different MySQL…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same… 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…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… relevant. It was and still is, however, relevant with HDD RAID storage – technology we have been using for many years – when… more interesting alignment example, let’s assume we have a RAID with 256k stripe element size and a misalignment in partition… 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
…_time=1000 on MySQL 5.5.30 and testing multiple buffer pools on MySQL 5.5.30. Finally, MySQL 5.6.10 has many… memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 vs 5… see above, MySQL 5.6 outperformed MySQL 5.5.30 with the big buffer pool. Why is the MySQL 5.6.10 with default…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… which switches RAID cache in write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… only modest slowdown when data doubles, while in other case 10-20% difference in data size can be the difference between…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…over time: mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB Version: 10 Row_format: …of workloads indeed work better with O_DIRECT mode. The RAID controller also can make significant difference here as O_…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… RAID 10 system we have on this server. This is because of Random I/O we had during execution of query, as MySQL…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
…about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). …———————————————————————- Logical device number 0 Logical device name : RAID10-A RAID level : 10 Status of logical device : Optimal Size : 571382 MB…
