tencent cloud

Test Tool

Sysbench 1.0.20 is the tool used to test the database benchmark performance.

Tool installation

Run the following code to install Sysbench 1.0.20:

git clone https://github.com/akopytov/sysbench.git
git checkout 1.0.20
yum install gcc gcc-c++ autoconf automake make libtool bzr mysql-devel git mysql
cd sysbench
./autogen.sh
./configure
make -j
make install

Note：

The installation directions above apply to performance stress testing on a CentOS CVM instance. For directions on installing the tool on other operating systems, see the official Sysbench documentation.

Test Environment

• Note on client specification: High-spec client machines are used so as to ensure that the database instance performance can be measured through stress testing on a single client. For low-spec clients, we recommend you use multiple clients for concurrent stress testing and aggregate the results.
• Note on network latency: When performing the test, make sure that clients and database instances are in the same AZ to prevent the testing result from being affected by network factors.

Test Method

Test data preparations

sysbench --db-driver=mysql --mysql-host=xxxx --mysql-port=xxxx --mysql-user=xxxx --mysql-password=xxxx --mysql-db=sbtest --table_size=xxxx --tables=xxxx --events=0 --time=600 --threads=xxxx --percentile=95 --report-interval=1 oltp_read_write prepare

Command for performance stress testing

sysbench --db-driver=mysql --mysql-host=xxxx --mysql-port=xxxx --mysql-user=xxxx --mysql-password=xxxx --mysql-db=sbtest --table_size=xxxx --tables=xxxx --events=0 --time=600 --threads=xxxx --percentile=95 --report-interval=1 oltp_read_write run

Descriptions of stress testing parameters:

• oltp_read_write indicates to implement the OLTP test by calling the /usr/share/sysbench/oltp_read_write.lua script.
• --tables=xxxx indicates the number of tables in this test.
• --table_size=xxxx indicates the number of table rows in this test.
• --threads=xxxx indicates the number of concurrent connections of the client in this test.
• --report-interval=1 indicates that the test result is output once every second.
• --percentile=95 indicates the sampling rate, which is 95% by default.
• --time=600 indicates the execution time of this test, which is 600 seconds.

Scenario model

The test cases in this document all use the Lua script of sysbench.
For the common configurations, performance testing is conducted for different parameter templates. The test results are as follows:

Test result

v5.6 20210630

v5.7 20210630

v8.0 20210330