Mahidol University Logo
Faculty of ICT, Mahidol University
 

Admissions

Printable Version

 

TPC-H QUERY OPTIMIZATION FOR LOAD BALANCING ON MYSQL CLUSTER

 

TITLE TPC-H QUERY OPTIMIZATION FOR LOAD BALANCING ON MYSQL CLUSTER
AUTHOR RANGSAN PORNPATTANA
DEGREE MASTER OF SCIENCE PROGRAMME IN COMPUTER SCIENCE
FACULTY FACULTY OF SCIENCE
ADVISOR SUDSANGUAN NGAMSURIYAROJ
CO-ADVISOR SONGSRI TANGSRIPAIROJ
SRISUPA PALAKVANGSA NA AYUDHYA
 
ABSTRACT
Efficient query processing is vital to the performance of the database especially when the data size is huge and most queries are complex. One way to improve the performance is to do a parallel query processing on a database cluster. In addition, the query optimization plays a crucial role in choosing the most efficient strategy for executing a query. However, query optimization strategies and event execution plans depend on the complexity of individual queries. Currently, MySQL cluster is the extension of MySQL adapted to run on a cluster system with the new storage engine called NDB or NDBCLUSTER. Although it provides high availability, good scalability, and high performance, NDB does not give accurate statistics to MySQL that would allow MySQL optimizer to always make the right decision for query optimization. While query optimization issues are not directly addressed in MySQL cluster, the query rewriting opens up the possibility of high efficient query processing in several cases. This research aims to apply many execution strategies and optimization techniques for complex SQL queries, including subqueries and nested queries, and run them as distributed queries on each MySQL server while the execution plans are controlled at the SQL statement levels, which are the results of having optimal query plans by adding SQL hints or information, and rewriting SQL. The performance of our work is evaluated using the TPC-H, the decision support benchmark widely used in testing the data warehousing performance. The experimental results are compared among several configurations including one node, two nodes, and four nodes.
KEYWORD MYSQL CLUSTER / TPC-H / QUERY OPTIMIZATION / LOAD BALANCING

 

 

Go to Top

 

ICT Building, Mahidol University, 999 Phuttamonthon 4 Road, Salaya, Nakhonpathom 73170 Tel. +66 02 441-0909 Fax. +66 02 849-6099
Mahidol University Computing Center, The Faculty of ICT, Mahidol University , Rama 6 Road, Rajathevi, Bangkok 10400 Tel. +66 02 354-4333 Fax. +66 02 354-7333