tencent cloud

TencentDB for MySQL

DocumentationTencentDB for MySQLWhite PaperPerformance White PaperPerformance Test ReportTest MethodsTest Methods

Test Methods

Download
Focus Mode
Font Size
Last updated: 2024-07-23 17:41:22
This document describes the method of TencentDB for MySQL performance test.

Directions

Use SysBench to test the mixed read/write performance of the TencentDB for MySQL instance.
1. Prepare the data.
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 the 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. Clear the data.
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
Previous Topic: Test ToolsNext Topic: Test Metrics

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback