Publication: Performance evaluation of TPC-H queries on MySQL cluster
Issued Date
2010-07-26
Resource Type
Other identifier(s)
2-s2.0-77954778412
Rights
Mahidol University
Rights Holder(s)
SCOPUS
Bibliographic Citation
24th IEEE International Conference on Advanced Information Networking and Applications Workshops, WAINA 2010. (2010), 1035-1040
Suggested Citation
Sudsanguan Ngamsuriyaroj, Rangsan Pornpattana Performance evaluation of TPC-H queries on MySQL cluster. 24th IEEE International Conference on Advanced Information Networking and Applications Workshops, WAINA 2010. (2010), 1035-1040. doi:10.1109/WAINA.2010.167 Retrieved from: https://repository.li.mahidol.ac.th/handle/20.500.14594/29021
Research Projects
Organizational Units
Authors
Journal Issue
Thesis
Title
Performance evaluation of TPC-H queries on MySQL cluster
Author(s)
Other Contributor(s)
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. © 2010 IEEE.