All Products
Search

This Product

    AnalyticDB:Preparations

    Document Center

    AnalyticDB:Preparations

    Last Updated:Sep 20, 2024

    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. You can perform a complete TPC-DS benchmark test in AnalyticDB for MySQL to obtain information about the analytical performance of an AnalyticDB for MySQL cluster.

    Note

    The implementation of TPC-DS in this topic is derived from the TPC-DS benchmark and is not comparable to published TPC-DS benchmark results. The implementation does not comply with all the requirements of the TPC-DS benchmark.

    Before you perform a TPC-DS test in AnalyticDB for MySQL, make the following preparations:

    1. Create an AnalyticDB for MySQL cluster. For more information, see Create a cluster.

    2. Configure an IP address whitelist for the cluster. For more information, see Configure an IP address whitelist.

    3. Create a database account for the cluster. For more information, see Create a database account.

    4. To connect to the cluster over the Internet, apply for a public endpoint. For more information, see Apply for or release a public endpoint.

    5. Install TPC-DS tools.

      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 tools. The registration page appears.

        Note

        Make sure that you enter a valid 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.

        1. Decompress the installation package. 

          unzip tpc-ds-tool.zip

        2. Go to the tools directory to compile the tools. 

          cd v2.13.0rc1/tools
make

        3. View the compiled file. 

          ls -l

          The following output is returned:

          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

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