Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… got a lot of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got a lot of…,sub_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command…,sub_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… is good order of magnitude better compared to MySQL results on 10G database. TPC does discourage from comparing results against different database… 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…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted… ? Why TPC-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries… 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: Introducing tpce-like workload for MySQL
February 8, 2010 By 6 Comments
… TPCE. Yasufumi made some efforts to make TPCE working with MySQL, and we are making it available for public consideration. You…/tpcemysql Important DISCLAIMER: Using this package you should agree with TPC-E License Agreement, which in human words is: You can… performance research and/or compare with available Storage Engines for MySQL. The workload in tpce is quite different from tpcc. Tpcc…
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: 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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… MRR works. What else worth to mention here is that MySQL is wrong choosing index scan here. If we try to…
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… 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… 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…
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… patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just…
