tencent cloud

Feedback

Test Methods

Last updated: 2023-11-20 17:08:38
    This document describes the method of TDSQL-C for MySQL performance test.

    Scenario 1: Full Cache

    List of table sizes and table quantities in the full cache test scenario:
    Specification
    Table Size (table_size)
    Total Tables (tables)
    2-core 16 GB MEM
    25000
    250
    4-core 16 GB MEM
    25000
    250
    2-core 32 GB MEM
    25000
    250
    8-core 32 GB MEM
    25000
    250
    8-core 64 GB MEM
    25000
    250
    16-core 64 GB MEM
    25000
    250
    16-core 96 GB MEM
    25000
    250
    16-core 128 GB MEM
    25000
    250
    32-core 128 GB MEM
    25000
    250
    32-core 256 GB MEM
    25000
    250
    64-core 256 GB MEM
    25000
    250

    Command execution

    Note:
    Replace XXX in the following commands with the private network address, port number, username, user password, and database name of the tested TDSQL-C for MySQL cluster, as well as the table_size and tables corresponding to the test scenario. Specific parameters are as described below:
    -host: Private network address of the tested instance
    -port: Port number
    -user: Username
    - password: Password of the username
    -table_size: Data volume in one single table
    -tables: Total number of tables
    -mysql-db: Database name
    1. Write
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only prepare
    ## Prepare data
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=192 --percentile=95 --report-interval=1 oltp_write_only run
    ## Run the workload
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_write_only cleanup
    ## Clear the data
    2. Read (POINT SELECT)
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare
    ## Prepare data
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=512 --percentile=95 --range_selects=0 --skip-trx=1 --report-interval=1 oltp_read_only run
    ## Run the workload
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup
    ## Clear the data
    3. Read (RANGE SELECT)
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only prepare
    ## Prepare data
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=512 --percentile=95 --skip-trx=1 --report-interval=1 oltp_read_only run
    ## Run the workload
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_only cleanup
    ## Clear the data
    4. Read-write (POINT SELECT)
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write run
    ## Prepare data
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --range_selects=0 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run
    ## Run the workload
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup
    ## Clear the data
    5. Read-write (RANGE SELECT)
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write run
    ## Prepare data
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX --events=0 --time=600 --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run
    ## Run the workload
    
    sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=XXX --table_size=XXX --tables=XXX oltp_read_write cleanup
    ## Clear the data

    Scenario 2: Big Dataset

    List of table sizes and table quantities in the big dataset test scenario:
    Specification
    Table Size (table_size)
    Total Tables (tables)
    2-core 16 GB MEM
    800000
    150
    4-core 16 GB MEM
    800000
    300
    4-core 32 GB MEM
    800000
    300
    8-core 32 GB MEM
    800000
    300
    8-core 64 GB MEM
    800000
    450
    16-core 64 GB MEM
    800000
    450
    16-core 96 GB MEM
    800000
    600
    16-core 128 GB MEM
    5000000
    300
    32-core 128 GB MEM
    5000000
    300
    32-core 256 GB MEM
    5000000
    400
    64-core 256 GB MEM
    6000000
    450

    Command execution

    The commands are the same as those in each full cache test scenario. You only need to replace the table_size and tables in the commands.

    Scenario 3: 1 TB Single Table

    List of table sizes and table quantities in the 1 TB single table test scenario:
    Specification
    Table Size (table_size)
    Total Tables (tables)
    2-core 16 GB MEM
    4000000000
    1
    4-core 16 GB MEM
    4000000000
    1
    4-core 32 GB MEM
    4000000000
    1
    8-core 32 GB MEM
    4000000000
    1
    8-core 64 GB MEM
    4000000000
    1
    16-core 64 GB MEM
    4000000000
    1
    16-core 96 GB MEM
    4000000000
    1
    16-core 128 GB MEM
    4000000000
    1
    32-core 128 GB MEM
    4000000000
    1
    32-core 256 GB MEM
    4000000000
    1
    64-core 256 GB MEM
    4000000000
    1

    Command execution

    The commands are the same as those in each full cache test scenario. You only need to replace the table_size and tables in the commands.
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support