TDSQL-C for MySQL
- Release Notes and Announcements
- Announcements
- Product Introduction
- Suggestions on Usage Specifications
- Kernel Features
- Kernel Version Release Notes
- Optimized Kernel Version
- Functionality Features
- Performance Features
- Security Features
- Stability Feature
- Analysis Engine Features
- Purchase Guide
- Value-Added Services Billing Overview
- Database Audit
- Audit Rule Template
- Serverless Service
- Serverless Introduction
- Serverless Resource Pack
- Configuration Change
- Operation Guide
- Database Connection
- Configuring Network Address
- Instance Management
- Configuration Adjustment
- Instance Mode Management
- Cluster Management
- Scaling Instance
- Database Proxy
- Database Proxy Kernel Features
- Managing Database Proxy
- Automatic Read/Write Separation
- Connection Pool Feature
- Other Features
- Account Management
- Console Account
- Database Account
- Configuring Custom Password Strength
- Database Management
- Database Management Tool
- Columnar Storage Index (CSI)
- Utilization of Columnar Storage Indexes
- Read-Only Analysis Engine
- Feature Limits and Compatibility
- Description of Functions and Operators
- Read-Only Analysis Engine Management
- Data Loading
- Executing Queries
- Exclusive Features
- Performance Optimization
- Performance White Paper
- Parameter Configuration
- Multi-AZ Deployment
- Backup and Restoration
- Performing Backup
- Managing Backup
- Rollback
- Restoring Data from Logical Backups
- Restoring Data Through the Console
- Restoring Data from Snapshot Backup
- Data Migration
- Parallel Query
- Setting Parallel Query
- Database Security and Encryption
- Access and Authorization
- Security Group Management
- TencentDB Security Group Management
- Monitoring and Alarms
- Monitoring
- Alarms
- Monitoring Metric Alarm
- Practical Tutorial
- Data Rollback
- Database/Table-Level Rollback
- Rolling back Entire Cluster
- White Paper
- Security White Paper
- Performance White Paper
- Troubleshooting
- Connection Issues
- API Documentation
- Making API Requests
- Instance APIs
- Account APIs
- Audit APIs
- Database Proxy APIs
- Backup and Restoration APIs
- Parameter Management APIs
- Performance Analysis APIs
- Serverless APIs
- ResourcePackage APIs
- Other APIs
- FAQs
- Service Agreement
- TDSQL-C Policy
- General References
Test Tools
Last updated: 2023-03-01 14:33:46
This document describes how to install SysBench, a performance testing tool for TDSQL-C 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 parameter description
Parameter | Description |
db-driver | Database engine |
mysql-host | TDSQL-C for MySQL server host |
mysql-port | TDSQL-C for MySQL server port |
mysql-user | TDSQL-C for MySQL account |
mysql-password | TDSQL-C for MySQL password |
mysql-db | TDSQL-C for 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 |
Installation method
This stress test uses SysBench 1.0.20 (using bundled LuaJIT 2.1.0-beta2). For more information, see here.
Note:
One client offers a concurrency of 1,000. One more client is added after the concurrency exceeds 1,000, and so on.
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