Performance Evaluation of TPC-H Queries on MySQL Cluster

Authors:
Sudsanguan Ngamsuriyaroj;Rangsan Pornpattana
Affiliations:
-;-
Venue:
WAINA '10 Proceedings of the 2010 IEEE 24th International Conference on Advanced Information Networking and Applications Workshops
Year:
2010

Citing 0
Cited 2

Implementing an affordable high-performance computing for teaching-oriented computer science curriculum

ACM Transactions on Computing Education (TOCE)
Red Fox: An Execution Environment for Relational Query Processing on GPUs

Proceedings of Annual IEEE/ACM International Symposium on Code Generation and Optimization

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.