sudo apt update && sudo apt install -y sysbench # Ubuntu
# 准备测试数据： 使用 MySQL 数据库初始化测试数据表。
sysbench oltp_read_write --mysql-host=192.168.88.250 --mysql-port=3307 --mysql-user=root \
--mysql-password=your_password --mysql-db=test --tables=10 \
--table-size=100000 prepare
# 执行读写测试：
sysbench oltp_read_write --mysql-host=192.168.88.250 --mysql-user=root \
--mysql-password=your_password --mysql-db=test --mysql-port=3307 --tables=10 \
--table-size=100000 --threads=16 --time=60 run
# -----------------------------------------------------
# 下面是运行的日志，这里只跑了1各表。
sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
Running the test with following options:
Number of threads: 16
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 10094
write: 2884
other: 1442
total: 14420
transactions: 721 (11.68 per sec.) # TPS
queries: 14420 (233.57 per sec.) # 查询性能
ignored errors: 0 (0.00 per sec.) # 错误
reconnects: 0 (0.00 per sec.) # 重连
General statistics:
total time: 61.7359s # 耗时
total number of events: 721
Latency (ms):
min: 484.58
avg: 1355.66
max: 3497.64
95th percentile: 2238.47
sum: 977431.05
Threads fairness:
events (avg/stddev): 45.0625/0.90
execution time (avg/stddev): 61.0894/0.21
# -----------------------------------------------------
# 清理测试数据：
sysbench oltp_read_write --mysql-host=127.0.0.1 --mysql-user=root \
--mysql-password=your_password --mysql-db=test cleanup