… numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H dataset…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Now let’s… 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
… numbers. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #10 and ran it on TPC-H dataset…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Ok so now… on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M…
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: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got …24 core system. For comparison you can checkSysbench Results which Vadim published. For read only workload …do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
We were doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish results which are… running queries to get results for others this means we can’t really get a valid TPC-H result from MySQL,though at least… to 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: Introducing tpce-like workload for MySQL
February 8, 2010 By 3 Comments
We have been using tpcc-mysql benchmark for long time, and there many results published in our blog, but that’s just… with TPC-E License Agreement, which in human words is: You can’t name results as “TPC Benchmark Results” You can’t compare results with results published on http://www.tpc.org/ and you can’t pretend the results are…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6.0. Do not get this post wrong. I’m not saying MySQL… 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: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29… very recent, though we do not think results will differ a lot with today versions. Results are as follows: The system was…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
…, I still know MySQL much better and so it would not be 100% correct. To get best results you need to make… ether can be done by some Industry body – such as TPC or SPEC or by mass media – eWeek benchmark or recent… even in TPC or SPEC benchmarks vendors try to avoid directly comparable results – for example Oracle and Microsoft would run TPC-C on…
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 … TIMES faster than result above (http://www.tpc.org/results/individual_results/Kickfire/Kickfire_2300_ES_TPCH_100G_041408.pdf) it appears MySQL/Sun have…
