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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… 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…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Now let’s… #3, in fact disabling both of these provided the best result for MariaDB 5.5 for in-memory workload. I intend…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… that do not belong to the secondary index definition can result in a lot of Random I/O. The purpose of… 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…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Ok so now…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… TPC-H queries for the client and they kindly allowed us to publish results which are very interesting. This is obviously not audited TPC-H… long running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL,though at… MySQL results on 10G database. TPC does discourage from comparing results against different database sizes so let’s see 100G data set results. In…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6… most of TPC-H Queries. I personally (before doing what exactly queries are part of TPC-H) was expecting to see gains in TPC-H and… ? Why TPC-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries or…
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 37 … on Q1 it’s 100 TIMES faster than result above (http://www.tpc.org/results/individual_results/Kickfire/Kickfire_2300_ES_TPCH_100G_041408…
Comment: TPC-H Run on MySQL 5.1 and 6.0
September 1, 2008 By 16 Comments
…’m trying to execute the tpc-h queries on a mysql 5.0.27 system. Some of my results are somewhat similar to… have a look at your create table scripts for the tpc-h standard ? Thanks in advance.
Comment: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
February 6, 2011 By 11 Comments
Imressive results! Is there any chance to put the Percona Server to the TPC-H tests? http://www.tpc.org/tpch/results/tpch_results.asp?print=false&orderby=tpm&version=2%&sortby=desc
Comment: The performance effects of new patches
September 10, 2008 By 14 Comments
…, do not fully understand what you are asking. We show results when patches show good improvement. For sure there are cases…. We are testing it on our production system, on TPC-C, TPC-E, TPC-H emulation workloads, on intensive sysbench benchmarks and we have…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…, which is TPC-H modification, and tried run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I did not get results for MonetDB, will… also can utilize only singe thread with results sometime better, sometime worse than InfoBright. Results: QueryInfoBrightInfiniDB LucidDB Q1.1 48 min 21…
