tencent cloud

Feedback

Test Methods

Last updated: 2022-04-13 12:04:10

    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 Tables
    2-core 16 GB MEM25000250
    4-core 16 GB MEM25000250
    4-core 32 GB MEM25000250
    8-core 32 GB MEM25000250
    8-core 64 GB MEM25000250
    16-core 64 GB MEM25000250
    16-core 96 GB MEM25000250
    16-core 128 GB MEM25000250
    32-core 128 GB MEM25000250
    32-core 256 GB MEM25000250
    64-core 256 GB MEM25000250

    Running commands

    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 above 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 run
    ##Prepare the 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 a 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 the 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 a 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 the 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 a 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 the 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 a 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 the 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 a 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 Tables
    2-core 16 GB MEM800000150
    4-core 16 GB MEM800000300
    4-core 32 GB MEM800000300
    8-core 32 GB MEM800000300
    8-core 64 GB MEM800000450
    16-core 64 GB MEM800000450
    16-core 96 GB MEM800000600
    16-core 128 GB MEM5000000300
    32-core 128 GB MEM5000000300
    32-core 256 GB MEM5000000400
    64-core 256 GB MEM6000000450

    Running commands

    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 Tables
    2-core 16 GB MEM40000000001
    4-core 16 GB MEM40000000001
    4-core 32 GB MEM40000000001
    8-core 32 GB MEM40000000001
    8-core 64 GB MEM40000000001
    16-core 64 GB MEM40000000001
    16-core 96 GB MEM40000000001
    16-core 128 GB MEM40000000001
    32-core 128 GB MEM40000000001
    32-core 256 GB MEM40000000001
    64-core 256 GB MEM40000000001

    Running commands

    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