This topic describes the performance tests of AnalyticDB for MySQL implemented based on the TPC-H benchmark in the basic Alibaba Cloud environment. This topic also describes the test results in different application scenarios. The performance tests were performed in December 2020.
AnalyticDB for MySQL is an online analytical processing (OLAP) warehouse service that can process petabytes of highly concurrent data in real time. The service uses relational models to store data and provides SQL statements to flexibly compute and analyze data. You do not need to create data models in advance. AnalyticDB for MySQL leverages a seamless scaling capability to compute tens of billions of data rows within milliseconds.
AnalyticDB for MySQL supports the pay-as-you-go and subscription billing methods and flexible scaling.
You can scale pay-as-you-go clusters at any time.
You can scale or renew subscription clusters at any time.
TPC-H is developed and released by the Transaction Processing Performance Council (TPC) to evaluate the query capabilities of databases. The TPC-H benchmark contains eight tables and 22 complex SQL queries. Most of the queries contain multi-table JOIN operations, subqueries, and GROUP BY clauses. For more information, see TPC-H test queries.
The TPC-H performance tests described in this topic are implemented based on the TPC-H benchmark test but do not meet all requirements of the TPC-H benchmark test. Therefore, the test results described in this topic cannot be compared with the published results of the TPC-H benchmark test.
TPC-DS is a decision support benchmark that is developed and released by the TPC Council to evaluate the analysis performance of big data services. The TPC-DS benchmark contains 99 SQL queries. For more information, see TPC-DS test queries.
The TPC-DS performance tests described in this topic are implemented based on the TPC-DS benchmark test but do not meet all requirements of the TPC-DS benchmark test. Therefore, the test results described in this topic cannot be compared with the published results of the TPC-DS benchmark test.