Performance Evaluation of TPC-H Queries on MySQL Cluster

This paper evaluates the performance of TPC-H queries on MySQL cluster via our designed vParNDB middleware based on the storage engine called NDB. The middleware combines both inter-query and intra-query parallelism to provide better query performance over the original MySQL cluster. Many strategies such as query rewriting and SQL hints are applied to optimize query execution plans of all queries as they can be simultaneously executed as subqueries on each MySQL node before the final results are aggregated at the front end node. The performance of all 22 TPC-H queries is evaluated, and the results illustrate significant speedup as well as better throughput.