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 |
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
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"
ffffffff
indicates that 32 CPU cores are used (one f
represents four CPU cores).
Was this page helpful?