Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5…. new changes in optimizer, which should affect execution plan of TPC-H queries. In reality only two queries (from 22) have significantly… this number was dropped to 1200 finally. Probably we need to check how really MRR works. What else worth to mention here is that…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter 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 one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #10 and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor… when compared to MySQL 5.5, and this does not make sense to me. Probably its due to a bug in how counter is…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor…_orderdate LIMIT 10; In-memory workload Now let’s see how effective are the join optimizations when the workload fits entirely…
