… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… purpose of this benchmark, I have used TPC-H Query #10 and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor… are greater than both MySQL 5.5 and MySQL 5.6 IO bound workload Now let’s see how effective is MRR when… MySQL 5.6 code? As MRR was used in both MySQL 5.6 and MariaDB 5.5. Handler_mrr_rowid_refills counts how…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H dataset (InnoDB tables) with a Scale…LIMIT 10; In-memory workload Now let’s see how effective are the join optimizations when the workload …look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M &…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here… new changes in optimizer, which should affect execution plan of TPC-H queries. In reality only two queries (from 22) have significantly…-by-row but in batches reads. So let us see how perform 5.1 and 6.0 in cold mode (I…
Comment: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… sure how many of them are fixed now) can be seen here: http://www.mysqlperformanceblog.com/2008/04/10/tpc-h-run-on-mysql…
Comment: MySQL 6.0 vs 5.1 in TPC-H queries
April 8, 2008 By 17 Comments
Hi Vadim, – Which scale factor are you using? – How MySQL 5.1/6.0 scales with TPC-H (e.g.: scale factors 1,3,5,10,30,100)? Thanks, Noah
