All Products
Search
Document Center

AnalyticDB for MySQL:Install TPC-DS tools

Last Updated:Dec 26, 2023

This topic describes how to install TPC-DS tools.

Background information

Before you perform a performance test, you must install TPC-DS tools.

Note

TPC-DS is a decision support benchmark developed by the Transaction Processing Performance Council (TPC). For more information, visit the TPC-DS official website.

Procedure

  1. Visit the TPC-DS official website. In the top navigation bar, choose Downloads > Download Programs and Specifications.

  2. Click the download link of the TPC-DS tool set. The registration page appears.

    Note

    Make sure that you specify the correct email address to receive the download link of the TPC-DS tools.

  3. Obtain the download link in your email and download the installation package.

  4. Rename the installation package as tpc-ds-tool.zip.

  5. Decompress the installation package and go to the tools directory to compile the tools.

    # unzip tpc-ds-tool.zip
    # cd v2.13.0rc1/tools/
    # make
    
    # ls -l
    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

    You can obtain the file that contains table creation statements in the following tools directory: tools/tpcds.sql.