… MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL… reason ? Why TPC-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries or… it into final MySQL 6.0 release. Summary: Poor MySQL 6.0 performance on TPC-H queries does NOT mean to quantify MySQL Optimizer Team…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… this means we can’t really get a valid TPC-H result from MySQL,though at least we get to see performance of… it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run complex analytics queries, in particular those presented in TPC-H…
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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l…
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… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… purpose of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor… 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read…
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… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…, there is no difference in query times between MySQL 5.5 and MySQL 5.6/MariaDB 5.5 This is another area…
Comment: TPC-H Run on MySQL 5.1 and 6.0
September 1, 2008 By 16 Comments
Hi. I’m trying to execute the tpc-h queries on a mysql 5.0.27 system. Some of my results are somewhat… have a look at your create table scripts for the tpc-h standard ? Thanks in advance.
Comment: The performance effects of new patches
September 10, 2008 By 14 Comments
…, 1) We consider it is less stable comparing to standard MySQL, as it is less tested. We are going to recommend…. We are testing it on our production system, on TPC-C, TPC-E, TPC-H emulation workloads, on intensive sysbench benchmarks and we have…
Comment: TPC-H Run on MySQL 5.1 and 6.0
April 22, 2008 By 16 Comments
Given that Kickfire published 100GB TPC-H results (audited) where none of the queries took more than … above (http://www.tpc.org/results/individual_results/Kickfire/Kickfire_2300_ES_TPCH_100G_041408.pdf) it appears MySQL/Sun have some…
Comment: MySQL wins C'T Database Contest
November 19, 2006 By 27 Comments
… know. Speaking about OutOfTheBox performance of MySQL – simply forget about it. Out of the box MySQL is tuned to consume 16-32MB… not relevant benchmark results 
Regarding MySQL Performance – sure there are cases when performance is poor, TPC-H is one especially bad. It is also true you can run out of memory on misconfigured MySQL. All benchmarks…
