…benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5…for MySQL 5.6 and MariaDB 5.5 jumps to ~11min (this is the query time for MySQL 5.5) While when it sticks to plan ‘b’ for MySQL 5.6 and MariaDB 5.5…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark…to 6M, the query time for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Some fun with R visualization
February 23, 2012 By 5 Comments
… won’t analyze causes, but rather I want to show some different ways to present results. I enjoy working with R, and… the benchmark are the same as in the previous post, with difference there are results for 4 and 16 tables cases running MySQL 5.5.20. Let me remind how I do measurements. I run benchmark for 1 hours, with…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…to compare. I want to pretend that we pioneered (not invented, but started to use widely) a benchmark…benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql… 0.5 sec, but 0.5 … 1 to 128. There are results for…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting to compare with results I posted… your workload to run fastest. Lets look at the graphs provided in these benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 respectively…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
…benchmarks comparing different MySQL versions … ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 …for this workload. To isolate effect of this patch we only use this patch not full patch set in testing. MySQL 5.1…. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with …
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…compare to commodity solid-state drives? Let’s put them in the ring and let them duke it out. I could do benchmarks…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… 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 aligned to disk sectors (again due to the… easy to check if you’re aligned – run a benchmark with an offset and compare to a base, but it’s much harder to figure…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
…look at MySQL 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs 4.1 presentation to have some…and openness is best practice. During my work for MySQL I recommended not to use MySQL for certain applications (ie when queries and schema could…
