All Products
Search

This Product

    :Test procedure

    Document Center

    :Test procedure

    Last Updated:Aug 24, 2023

    This topic describes how to test the performance of an ApsaraDB RDS for MySQL instance.

    Procedure

    Follow these steps to test the read/write performance of an ApsaraDB RDS for MySQL instance:

    1. Prepare the data used for the test. 
      sysbench --db-driver=mysql --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=600  oltp_read_write prepare
    2. Run your workload. 
      sysbench --db-driver=mysql  --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=600   --threads=XXX --percentile=95 --report-interval=1 oltp_read_write run
    3. Delete the data used for the test. 
      sysbench --db-driver=mysql  --mysql-host=XXX --mysql-port=XXX --mysql-user=XXX --mysql-password=XXX --mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=600   --threads=XXX --percentile=95  oltp_read_write cleanup