[...] MySQL 6.0 vs 5.1 in TPC-H queries If you had issues with subqueries in MySQL 4.1 or 5.0 and pulled away from using them I’d encourage you to try MySQL 6.0 and see if your issues are fixed or described in the documentation published. [...]
Comment: TPC-H Run on MySQL 5.1 and 6.0
July 14, 2008 By 16 Comments
… application requirements is one of the hardest DBA tasks. The TPC-H and similar applications are meant to aid in this process… is, did the performance team produce better results on the MySQL versions as presented by Peter at the beginning of this… to learn those from the insiders, because the performance of MySQL does not stand out against the fullscale (OLTP +DW) version…
Comment: MySQL 6.0 vs 5.1 in TPC-H queries
April 10, 2008 By 17 Comments
… queries within 3hours run time allowed for each query and MySQL 6.0 has similar number of queries it can execute… reasonable time frame. There 2 queries (Query8 and Query20) which MySQL 6.0 does better but there is also Query11 in… is observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post [...]
Comment: MySQL 6.0 vs 5.1 in TPC-H queries
March 26, 2008 By 17 Comments
… is explain with index you suggested (in MySQL 6.0) mysql> explain select sum(l_extendedprice * l_discount) … 1 row in set (0.12 sec) And worse thing – TPC-H does not allow additional …
Comment: MySQL wins C'T Database Contest
November 18, 2006 By 27 Comments
… the ‘newcomer on the block’ MonetDB/SQL has beaten the MySQL in the java strand. Moreover, we have run many examples… processing of MySQL has questionable performance. A educated DBA is necessary to improve it. A simple run of a TPC-H SF-N… technology point of view, it would be nice if the MySQL guys again re-installed and publicly sql-bench results on…
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
…/). Addressing these issues, I took Star Schema Benchmark, which is TPC-H modification, and tried run queries against InfoBright, InfiniDB, LucidDB and… be resolved by InfoBright optimizer and I need to enable MySQL optimizer. InfiniDB is otherwise was IO-bound, and processed data… scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html SSB…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 6, 2009 By 16 Comments
… on a system that I beleive will put MySQL at the top of the TPC-H charts. My dilemma is that I do… is to be loaded as referrenced in the file: load_mysql.sh – PATH_DATA=/usb/rawdata/dbgen.10G Is that information…
Comment: TPC-H Run on MySQL 5.1 and 6.0
April 14, 2008 By 16 Comments
[...] to speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL [...]
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 12, 2010 By 48 Comments
… some arbitrary components not yet cleaned up from it’s TPC-H legacy, including the randomized data generation. But it also appears… seconds instead of 1465 seconds). http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-queries-via-infinidb-.html Let…
Comment: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… be seen here: http://www.mysqlperformanceblog.com/2008/04/10/tpc-h-run-on-mysql-51-and-60/
