…. Benchmark results For the purpose of this benchmark, I have used TPC-H Query #3 and ran it on TPC-H … look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & … provided the best result for MariaDB 5.5 for in-memory workload. I intend to run tests to see what …
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… for Power test which is good order of magnitude better compared 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: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… of attention such as Sysbench and DBT2/TPC-C scale pretty well a they got …important to test performance and scalability for your application on your hardware if you really want results …do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1… recent, though we do not think results will differ a lot with today versions. Results are as follows: The system… patch not full patch set in testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and…
Comment: The performance effects of new patches
September 10, 2008 By 14 Comments
… is less stable comparing to standard MySQL, as it is less tested. We are going to recommend this… fully understand what you are asking. We show results when patches show good improvement. For sure there…is less tested at this moment. We are testing it on our production system, on TPC-C, TPC-E, TPC-H…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 46 Comments
…TPC-H modification, and tried run queries against InfoBright, InfiniDB, LucidDB and MonetDB. I did not get results for MonetDB, will explain later why. Again primary goal for test was not …’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
… I took DBT2, an OSDL’s implementation of TPC-C. Hardware used The benchmark was run on…than a second to execute; logging every query; MySQL was run with default settings except following: [mysqld]…. The test was run with 1, 20 and 100 database connections Results To reduce random error the test was…
