TencentDB for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Database Architecture
- Database Instance
- Kernel Features
- Kernel Version Release Notes
- Functionality Features
- Performance Features
- Parallel Query
- Security Features
- Stability Features
- Purchase Guide
- Getting Started
- Connecting to MySQL Instance
- Database Audit
- Audit Rule Template
- MySQL Cluster Edition
- Maintenance Management Instance
- Operation Guide
- Instance Management and Maintenance
- Instance Upgrade
- CPU Elastic Expansion
- Read-Only/Disaster Recovery Instances
- Database Proxy
- Database Proxy Kernel Features
- Database Proxy Management
- Automatic Read/Write Separation Feature
- Connection Pool Feature
- Other Features
- Account Management
- Database Management Center (DMC)
- Parameter Configuration
- Network and Security
- Backup and Rollback
- Restoring Database from Backup File
- Monitoring and Alarms
- Operation Logs
- Practical Tutorial
- Calling MySQL APIs in Python
- White Paper
- Performance White Paper
- Performance Test Report
- Troubleshooting
- Connections
- API Documentation
- Data Import APIs
- Rollback APIs
- Parameter APIs
- Making API Requests
- Instance APIs
- Database Proxy APIs
- Database Audit APIs
- Security APIs
- Account APIs
- Backup APIs
- Database APIs
- Monitoring APIs
- Log-related API
- FAQs
- Backup
- Connection and Login
- Instance Upgrade
- Performance and Memory
- Service Agreement
- Reference
DocumentationTencentDB for MySQLWhite PaperPerformance White PaperPerformance Test ReportTest MethodsTest Tools
Test Tools
Last updated: 2024-07-23 17:41:00
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
Parameter | Description |
db-driver | Database engine |
mysql-host | MySQL server host |
mysql-port | MySQL server port |
mysql-user | MySQL user |
mysql-password | MySQL password |
mysql-db | MySQL database name |
table_size | Test table size |
tables | Number of test tables |
events | Number of test requests |
time | Test time |
threads | Number of test threads |
percentile | The percentile range to be counted, which is 95% by default, i.e., the execution times of requests in 95% of the cases |
report-interval | Interval for outputting a test progress report in seconds. 0 indicates to output only the final result but not the test progress report |
skip-trx | Whether to skip transactions 1: Yes 0: No |
How to Install
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 mysqlgit clone https://github.com/akopytov/sysbench.git##Download SysBench from GitHubcd sysbench##Open the SysBench directorygit checkout 1.0.20##Switch to SysBench 1.0.20./autogen.sh##Run `autogen.sh`./configure --prefix=/usr --mandir=/usr/share/manmake##Compilemake 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).Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No