Publication: Performance evaluation of TPC-H queries on MySQL cluster
| dc.contributor.author | Sudsanguan Ngamsuriyaroj | en_US |
| dc.contributor.author | Rangsan Pornpattana | en_US |
| dc.contributor.other | Mahidol University | en_US |
| dc.contributor.other | Assumption College | en_US |
| dc.date.accessioned | 2018-09-24T08:57:36Z | |
| dc.date.available | 2018-09-24T08:57:36Z | |
| dc.date.issued | 2010-07-26 | en_US |
| dc.description.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. | en_US |
| dc.identifier.citation | 24th IEEE International Conference on Advanced Information Networking and Applications Workshops, WAINA 2010. (2010), 1035-1040 | en_US |
| dc.identifier.doi | 10.1109/WAINA.2010.167 | en_US |
| dc.identifier.other | 2-s2.0-77954778412 | en_US |
| dc.identifier.uri | https://repository.li.mahidol.ac.th/handle/20.500.14594/29021 | |
| dc.rights | Mahidol University | en_US |
| dc.rights.holder | SCOPUS | en_US |
| dc.source.uri | https://www.scopus.com/inward/record.uri?partnerID=HzOxMe3b&scp=77954778412&origin=inward | en_US |
| dc.subject | Computer Science | en_US |
| dc.title | Performance evaluation of TPC-H queries on MySQL cluster | en_US |
| dc.type | Conference Paper | en_US |
| dspace.entity.type | Publication | |
| mu.datasource.scopus | https://www.scopus.com/inward/record.uri?partnerID=HzOxMe3b&scp=77954778412&origin=inward | en_US |