All Products
Search
Document Center

AnalyticDB for MySQL:Overview

Last Updated:Dec 12, 2023

This performance test is completed in the basic environments of Alibaba Cloud. The TPC-H results of AnalyticDB for MySQL and Presto 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. For more information, see TPC-H dataset.

Note

This implementation of TPC-H is derived from the TPC-H Benchmark and is not comparable to published TPC-H Benchmark results, as this implementation does not comply with all the requirements of the TPC-H Benchmark.

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. For more information, see TPC-DS dataset.

Note

This implementation of TPC-DS is derived from the TPC-DS Benchmark and is not comparable to published TPC-DS Benchmark results, as this implementation does not comply with all the requirements of the TPC-DS Benchmark.

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.