tencent cloud

This document describes how to install SysBench, a performance testing tool for TencentDB for MySQL, in a CVM instance.

SysBench Overview

SysBench is a modular, cross-platform, and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load. The idea of this benchmark suite is to quickly get an impression about system performance without setting up complex database benchmarks or even without installing a database at all.

SysBench Testing Model

• In a standard mixed OLTP read/write scenario of SysBench, a transaction contains 18 read/write SQL statements.
• In a standard OLTP read-only scenario of SysBench, a transaction contains 14 SQL read statements (ten primary key-based POINT SELECT queries and four range queries).
• In a standard OLTP write-only scenario of SysBench, a transaction contains four write SQL statements (two UPDATE statements, one DELETE statement, and one INSERT statement).

SysBench Parameter Description

How to Install

This stress test uses SysBench 1.0.20. For more information, see here.

1. Run the following command to install SysBench in a CVM instance:

   yum install gcc gcc-c++ autoconf automake make libtool bzr mysql-devel git mysql
   git clone https://github.com/akopytov/sysbench.git
   ##Download SysBench from GitHub
   cd sysbench
   ##Open the SysBench directory
   git checkout 1.0.20
   ##Switch to SysBench 1.0.20
   ./autogen.sh
   ##Run `autogen.sh`
   ./configure --prefix=/usr --mandir=/usr/share/man
   make
   ##Compile
   make install
   

2. Run the following command to configure the client, so that the kernel can use all CPU cores to process data packets and reduce context switches within each CPU core.

   sudo sh -c 'for x in /sys/class/net/eth0/queues/rx-*; do echo ffffffff>$x/rps_cpus; done'
   sudo sh -c "echo 32768 > /proc/sys/net/core/rps_sock_flow_entries"
   sudo sh -c "echo 4096 > /sys/class/net/eth0/queues/rx-0/rps_flow_cnt"
   sudo sh -c "echo 4096 > /sys/class/net/eth0/queues/rx-1/rps_flow_cnt"
   

Note：

ffffffff indicates that 32 CPU cores are used (one f represents four CPU cores).