Prepare for a TPC-DS test on AnalyticDB - AnalyticDB

Transaction Processing Performance Council-Decision Support (TPC-DS) is a decision support benchmark for evaluating the analytical performance of big data systems. This topic walks you through the steps required before running a TPC-DS benchmark test on an AnalyticDB for MySQL cluster.

Note

The TPC-DS implementation described here is derived from the TPC-DS benchmark and is not comparable to published TPC-DS benchmark results. It does not comply with all requirements of the TPC-DS benchmark.

Prerequisites

Before you begin, ensure that you have:

An AnalyticDB for MySQL cluster. See Create a cluster.
An IP address whitelist configured for the cluster. See Configure an IP address whitelist.
A database account for the cluster. See Create a database account.
(Optional) A public endpoint, if you plan to connect to the cluster over the Internet. See Apply for or release a public endpoint.

Install TPC-DS tools

Go to the TPC-DS official website. In the top navigation bar, choose Downloads > Download Programs and Specifications.
Click the download link for the TPC-DS tools. On the registration page that appears, enter a valid email address to receive the download link.
Download the installation package using the link sent to your email. Rename the package as tpc-ds-tool.zip.
Decompress the package, go to the tools directory, and compile the tools.
```
unzip tpc-ds-tool.zip
cd v2.13.0rc1/tools
make
```

Verify the compiled output.

ls -l

The output is similar to:

drwxr-xr-x 2 root root  4096 January  21 11:47 answer_sets
-rw-r--r-- 1 root root 17809 April  29 2020 EULA.txt
drwxr-xr-x 2 root root  4096 January  21 10:47 query_templates
drwxr-xr-x 2 root root  4096 May  12 2020 query_variants
drwxr-xr-x 2 root root  4096 May  12 2020 specification
drwxr-xr-x 2 root root  4096 May  12 2020 tests
drwxr-xr-x 7 root root 20480 January  21 21:40 tools

Note

The tools directory contains tpcds.sql, which has the table creation statements you will use in later steps.