This performance test is completed in the basic environments of Alibaba Cloud. The TPC-H results of AnalyticDB for MySQL, Presto, and Apache Spark are compared based on similar or identical hardware configurations and the same data volume. Test results in different application scenarios are also compared. The test was performed in December, 2020.

TPC-H is developed and released by the Transaction Processing Performance (TPC) Council to evaluate query capabilities of databases. The TPC-H benchmark contains 8 tables and defines 22 complex SQL queries. Most of the queries contain JOIN operations on multiple tables, subqueries, and GROUP BY clauses. TPC-H queries are derived from the TPC-H benchmark, but do not produce results comparable to published TPC-H benchmark results. For more information, see TPC-H dataset.

Transaction Processing Performance Council-Decision Support (TPC-DS) is a decision support benchmark that is used to evaluate the analytical performance of big data systems. The TPC-DS benchmark contains 99 query statements for testing. TPC-DS queries are derived from the TPC-DS benchmark, but do not produce results comparable to published TPC-DS benchmark results. For more information, see TPC-DS dataset.

AnalyticDB for MySQL is a cloud-based warehouse that can process petabytes of highly concurrent data in real time. It is an online analytical processing (OLAP) database service. It uses relational models to store data and provides SQL statements to flexibly compute and analyze data. You do not need to create a data model in advance. Based on the seamless scaling capability of the cloud, AnalyticDB for MySQL can compute tens of billions of or more data records in milliseconds.

AnalyticDB for MySQL provides the pay-as-you-go and subscription billing methods and supports flexible scaling. You can configure AnalyticDB for MySQL clusters based on your business requirements.

  • You can scale pay-as-you-go clusters at any time.
  • You can scale or renew subscription clusters at any time.