… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to share… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I made no code…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show the results of raw IO performance of this card. The benchmark methodology I described in previous posts, so let me jump directly to results… good question how does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand…
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
Following my previous benchmark of Samsung 830, today I want to show results for STEC MACH16 SATA card, 200GB size, this card…, and it seems suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC MACH16 cards. If you are interested more in SSD and MySQL questions – I…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
…cards. It really makes sense to test it under MySQL workload, but before getting to that, let me …0.7, rev 107053 Following the format of previous benchmarks, first is random write async 16KB case. We …patterns in the read synchronous case, let me unfold results and show them in timeline (from 0 to …
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
…: HP ProLiant DL380 G6, filesystem: ext4, mounted with nobarrier. The results for random write case (8 async IO threads): It seems… I was totally surprised them in random reads also. The results for random read case: I do not have a good… (some results for Intel 320). If you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and…
Comment: Testing Intel SSD 520
May 2, 2012 By 7 Comments
Can you benchmark actual MySQL performance on the SSD? Not sure how well sysbench results translate into actual MySQL results.
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…’s move on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC… pool. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Ok so now… captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…’s move on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC… pool. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Now let’s… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the final result… only a final result, but how the system behaves in dynamic. What’s wrong with existing benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql…
