sysbench 测试mysql性能

最新推荐文章于 2025-08-22 15:10:27 发布

转载最新推荐文章于 2025-08-22 15:10:27 发布 · 86 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/liuwenping/p/5288336.html

文章标签：

#运维 #数据库

本文介绍如何使用Sysbench工具进行MySQL OLTP（在线事务处理）的压力测试。包括安装Sysbench、准备测试环境、执行测试及清理数据等步骤。测试结果显示了事务处理速度、读写请求处理速度等关键性能指标。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.安装sysbench

yum install sysbench

2.测试前准备

sysbench --test=oltp --oltp-table-size=80000000 \

--db-driver=mysql \

--mysql-socket=/var/lib/mysql/mysql.sock \

--mysql-user=root \

--mysql-password='root' \

--mysql-db=test \

prepare

在test数据库中创建sbtest表，并插入80000000数据，表引擎为InnoDB

3.测试

把上面的语句最后一行改为run即可

sysbench --test=oltp --oltp-table-size=80000000 \

--db-driver=mysql \

--mysql-socket=/var/lib/mysql/mysql.sock \

--mysql-user=root \

--mysql-password='root' \

--mysql-db=test \

run

4.结果

sysbench 0.4.12: multi-threaded system evaluation benchmark

Running the test with following options:
Number of threads: 1

Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases)
Using "BEGIN" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 10000
Threads started!
Done.

OLTP test statistics:
queries performed:
read: 140000
write: 50000
other: 20000
total: 210000
transactions: 10000 (27.14 per sec.) #每秒处理的事务数
deadlocks: 0 (0.00 per sec.)
read/write requests: 190000 (515.69 per sec.) #每秒处理的读写请求
other operations: 20000 (54.28 per sec.)

Test execution summary:
total time: 368.4417s
total number of events: 10000
total time taken by event execution: 368.3644
per-request statistics:
min: 3.72ms
avg: 36.84ms
max: 326.52ms
approx. 95 percentile: 76.04ms

Threads fairness:
events (avg/stddev): 10000.0000/0.00
execution time (avg/stddev): 368.3644/0.00

5.清理数据

sysbench --test=oltp --oltp-table-size=80000000 \

--db-driver=mysql \

--mysql-socket=/var/lib/mysql/mysql.sock \

--mysql-user=root \

--mysql-password='root' \

--mysql-db=test \

cleanup

PS：sysbench --test=oltp help 查看更多可用参数

转载于:https://www.cnblogs.com/liuwenping/p/5288336.html