sysbench生产数据库压测
生产数据库压测
压测准备
生产机器配置
| CPU | 内存 | 带宽 |
|---|---|---|
| 2核 | 4G | 5M |
下载sysbench
sudo yum -y install sysbench
sysbench --version
建立测试库
create database test_db
character set utf8mb4 collate utf8mb4_bin;
准备测试表和测试表
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_read_write --db-ps-mode=disable prepare
Creating table 'sbtest5'...
Creating table 'sbtest6'...
Creating table 'sbtest2'...
Creating table 'sbtest9'...
Creating table 'sbtest1'...
Creating table 'sbtest7'...
Creating table 'sbtest3'...
Creating table 'sbtest4'...
Creating table 'sbtest8'...
Creating table 'sbtest10'...
Inserting 1000000 records into 'sbtest2'
Inserting 1000000 records into 'sbtest10'
Inserting 1000000 records into 'sbtest9'
Inserting 1000000 records into 'sbtest6'
Inserting 1000000 records into 'sbtest8'
Inserting 1000000 records into 'sbtest4'
Inserting 1000000 records into 'sbtest7'
Inserting 1000000 records into 'sbtest5'
Inserting 1000000 records into 'sbtest1'
Inserting 1000000 records into 'sbtest3'
测试指标
- thds 压测线程数
- tps 每秒事务数
- qps 每秒请求数
- (r/w/o) 每秒的请求数中读请求个数/写请求个数/其他请求个数
- lat(ms,95%) 95% 的请求延迟都在多少以下
- err/s 错误数
- reconn/s 重连数
开始测试
综合TPS-oltp_read_write
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_read_write --db-ps-mode=disable run
测试数据
[ 291s ] thds: 10 tps: 118.00 qps: 2310.99 (r/w/o: 1613.00/462.00/236.00) lat (ms,95%): 502.20 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 121.00 qps: 2515.99 (r/w/o: 1769.00/505.00/242.00) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 115.00 qps: 2277.98 (r/w/o: 1590.98/457.00/230.00) lat (ms,95%): 411.96 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 93.00 qps: 1866.01 (r/w/o: 1311.01/369.00/186.00) lat (ms,95%): 397.39 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 109.00 qps: 2120.01 (r/w/o: 1480.01/422.00/218.00) lat (ms,95%): 450.77 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 123.97 qps: 2525.45 (r/w/o: 1773.61/503.89/247.95) lat (ms,95%): 442.73 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 105.02 qps: 2041.43 (r/w/o: 1417.30/414.09/210.04) lat (ms,95%): 511.33 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 105.00 qps: 2172.99 (r/w/o: 1535.00/428.00/210.00) lat (ms,95%): 411.96 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 93.98 qps: 1877.68 (r/w/o: 1304.77/384.93/187.97) lat (ms,95%): 530.08 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 94.03 qps: 1917.53 (r/w/o: 1338.37/391.11/188.05) lat (ms,95%): 657.93 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 403326
write: 115236
other: 57618
total: 576180
transactions: 28809 (96.00 per sec.)
queries: 576180 (1920.04 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0868s
total number of events: 28809
Latency (ms):
min: 6.25
avg: 104.15
max: 882.75
95th percentile: 475.79
sum: 3000372.79
Threads fairness:
events (avg/stddev): 2880.9000/13.82
execution time (avg/stddev): 300.0373/0.01
只读性能-oltp_read_only
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_read_only --db-ps-mode=disable run
测试数据
[ 290s ] thds: 10 tps: 298.00 qps: 4773.00 (r/w/o: 4177.00/0.00/596.00) lat (ms,95%): 32.53 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 326.00 qps: 5228.01 (r/w/o: 4576.01/0.00/652.00) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 300.00 qps: 4767.97 (r/w/o: 4167.97/0.00/600.00) lat (ms,95%): 34.33 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 254.00 qps: 4100.01 (r/w/o: 3592.01/0.00/508.00) lat (ms,95%): 70.55 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 326.00 qps: 5194.04 (r/w/o: 4542.04/0.00/652.01) lat (ms,95%): 31.37 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 289.00 qps: 4599.02 (r/w/o: 4021.02/0.00/578.00) lat (ms,95%): 34.33 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 260.00 qps: 4166.93 (r/w/o: 3646.93/0.00/519.99) lat (ms,95%): 39.65 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 306.01 qps: 4902.08 (r/w/o: 4290.07/0.00/612.01) lat (ms,95%): 41.85 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 332.00 qps: 5334.94 (r/w/o: 4670.95/0.00/663.99) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 306.00 qps: 4857.00 (r/w/o: 4245.00/0.00/612.00) lat (ms,95%): 28.67 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 278.00 qps: 4484.02 (r/w/o: 3928.02/0.00/556.00) lat (ms,95%): 29.72 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 1285144
write: 0
other: 183592
total: 1468736
transactions: 91796 (305.66 per sec.)
queries: 1468736 (4890.53 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.3210s
total number of events: 91796
Latency (ms):
min: 1.83
avg: 32.71
max: 783.57
95th percentile: 36.24
sum: 3002551.43
Threads fairness:
events (avg/stddev): 9179.6000/45.24
execution time (avg/stddev): 300.2551/0.01
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_delete --db-ps-mode=disable run
删除性能-oltp_delete
测试数据
[ 290s ] thds: 10 tps: 1476.46 qps: 1476.46 (r/w/o: 0.00/632.77/843.69) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 1719.47 qps: 1719.47 (r/w/o: 0.00/748.21/971.27) lat (ms,95%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 1268.76 qps: 1268.76 (r/w/o: 0.00/560.89/707.87) lat (ms,95%): 48.34 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 1247.49 qps: 1247.49 (r/w/o: 0.00/547.21/700.27) lat (ms,95%): 48.34 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 1635.47 qps: 1635.47 (r/w/o: 0.00/699.35/936.13) lat (ms,95%): 37.56 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 2025.78 qps: 2025.78 (r/w/o: 0.00/871.76/1154.01) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 1692.32 qps: 1692.32 (r/w/o: 0.00/733.71/958.62) lat (ms,95%): 40.37 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 1988.50 qps: 1988.50 (r/w/o: 0.00/873.22/1115.28) lat (ms,95%): 13.22 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 1472.85 qps: 1472.85 (r/w/o: 0.00/641.94/830.92) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 2026.89 qps: 2026.89 (r/w/o: 0.00/833.96/1192.94) lat (ms,95%): 18.61 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 1312.49 qps: 1312.49 (r/w/o: 0.00/548.21/764.29) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 0
write: 182205
other: 101024
total: 283229
transactions: 283229 (943.98 per sec.)
queries: 283229 (943.98 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0344s
total number of events: 283229
Latency (ms):
min: 0.05
avg: 10.59
max: 763.43
95th percentile: 57.87
sum: 2999680.58
Threads fairness:
events (avg/stddev): 28322.9000/136.64
execution time (avg/stddev): 299.9681/0.00
更新索引字段性能-oltp_update_index
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_update_index --db-ps-mode=disable run
测试数据
[ 290s ] thds: 10 tps: 1890.91 qps: 1890.91 (r/w/o: 0.00/817.96/1072.95) lat (ms,95%): 17.95 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 1658.97 qps: 1658.97 (r/w/o: 0.00/720.99/937.98) lat (ms,95%): 36.24 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 1869.31 qps: 1869.31 (r/w/o: 0.00/776.71/1092.60) lat (ms,95%): 16.41 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 1407.62 qps: 1407.62 (r/w/o: 0.00/613.40/794.22) lat (ms,95%): 46.63 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 1943.94 qps: 1943.94 (r/w/o: 0.00/850.29/1093.65) lat (ms,95%): 17.63 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 1423.61 qps: 1423.61 (r/w/o: 0.00/619.83/803.78) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 2085.37 qps: 2085.37 (r/w/o: 0.00/863.15/1222.21) lat (ms,95%): 11.24 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 1501.89 qps: 1501.89 (r/w/o: 0.00/630.95/870.94) lat (ms,95%): 45.79 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 2033.84 qps: 2033.84 (r/w/o: 0.00/859.93/1173.91) lat (ms,95%): 19.65 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 1684.48 qps: 1684.48 (r/w/o: 0.00/668.79/1015.69) lat (ms,95%): 44.98 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 1717.67 qps: 1717.67 (r/w/o: 0.00/707.28/1010.39) lat (ms,95%): 43.39 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 0
write: 204775
other: 282872
total: 487647
transactions: 487647 (1625.19 per sec.)
queries: 487647 (1625.19 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0548s
total number of events: 487647
Latency (ms):
min: 0.06
avg: 6.15
max: 614.80
95th percentile: 37.56
sum: 2999767.73
Threads fairness:
events (avg/stddev): 48764.7000/185.22
execution time (avg/stddev): 299.9768/0.01
更新非索引字段性能-oltp_update_non_index
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_update_non_index --db-ps-mode=disable run
测试数据
[ 290s ] thds: 10 tps: 2196.09 qps: 2196.09 (r/w/o: 0.00/931.04/1265.05) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 2224.92 qps: 2224.92 (r/w/o: 0.00/958.97/1265.96) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 2616.11 qps: 2616.11 (r/w/o: 0.00/1057.05/1559.07) lat (ms,95%): 10.84 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 1803.49 qps: 1803.49 (r/w/o: 0.00/755.79/1047.70) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 2506.47 qps: 2506.47 (r/w/o: 0.00/1066.20/1440.27) lat (ms,95%): 13.46 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 2560.25 qps: 2560.25 (r/w/o: 0.00/1060.10/1500.15) lat (ms,95%): 11.04 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 2256.95 qps: 2256.95 (r/w/o: 0.00/955.98/1300.97) lat (ms,95%): 11.45 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 1565.05 qps: 1565.05 (r/w/o: 0.00/649.02/916.03) lat (ms,95%): 14.46 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 2476.96 qps: 2476.96 (r/w/o: 0.00/1004.98/1471.97) lat (ms,95%): 10.84 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 2466.95 qps: 2466.95 (r/w/o: 0.00/1054.98/1411.97) lat (ms,95%): 13.46 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 2496.07 qps: 2496.07 (r/w/o: 0.00/1018.03/1478.04) lat (ms,95%): 11.65 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 0
write: 268866
other: 372813
total: 641679
transactions: 641679 (2138.56 per sec.)
queries: 641679 (2138.56 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0498s
total number of events: 641679
Latency (ms):
min: 0.06
avg: 4.67
max: 577.42
95th percentile: 12.98
sum: 2999560.42
Threads fairness:
events (avg/stddev): 64167.9000/272.04
execution time (avg/stddev): 299.9560/0.01
插入性能-oltp_insert
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_insert --db-ps-mode=disable run
测试数据
[ 290s ] thds: 10 tps: 1243.86 qps: 1243.86 (r/w/o: 0.00/1243.86/0.00) lat (ms,95%): 12.98 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 1377.96 qps: 1377.96 (r/w/o: 0.00/1377.96/0.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 1298.12 qps: 1298.12 (r/w/o: 0.00/1298.12/0.00) lat (ms,95%): 21.50 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 1498.70 qps: 1498.70 (r/w/o: 0.00/1498.70/0.00) lat (ms,95%): 11.87 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 1517.32 qps: 1517.32 (r/w/o: 0.00/1517.32/0.00) lat (ms,95%): 12.30 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 1386.00 qps: 1386.00 (r/w/o: 0.00/1386.00/0.00) lat (ms,95%): 13.70 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 1447.00 qps: 1447.00 (r/w/o: 0.00/1447.00/0.00) lat (ms,95%): 11.65 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 1168.01 qps: 1168.01 (r/w/o: 0.00/1168.01/0.00) lat (ms,95%): 15.27 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 1108.01 qps: 1108.01 (r/w/o: 0.00/1108.01/0.00) lat (ms,95%): 18.28 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 1488.89 qps: 1488.89 (r/w/o: 0.00/1488.89/0.00) lat (ms,95%): 12.75 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 1528.07 qps: 1528.07 (r/w/o: 0.00/1528.07/0.00) lat (ms,95%): 12.52 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 0
write: 313992
other: 0
total: 313992
transactions: 313992 (1046.43 per sec.)
queries: 313992 (1046.43 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0593s
total number of events: 313992
Latency (ms):
min: 1.87
avg: 9.55
max: 700.03
95th percentile: 35.59
sum: 2999519.55
Threads fairness:
events (avg/stddev): 31399.2000/42.71
execution time (avg/stddev): 299.9520/0.01
写入性能-otpl_write_only
测试命令
sysbench --db-driver=mysql --time=300 --threads=10 --report-interval=1 --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=test_db --tables=20 --table_size=1000000 oltp_write_only --db-ps-mode=disable run
测试数据
[ 290s ] thds: 10 tps: 645.95 qps: 3870.69 (r/w/o: 0.00/2086.83/1783.86) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00
[ 291s ] thds: 10 tps: 400.01 qps: 2402.07 (r/w/o: 0.00/1309.04/1093.03) lat (ms,95%): 66.84 err/s: 0.00 reconn/s: 0.00
[ 292s ] thds: 10 tps: 512.07 qps: 3040.43 (r/w/o: 0.00/1629.23/1411.20) lat (ms,95%): 63.32 err/s: 0.00 reconn/s: 0.00
[ 293s ] thds: 10 tps: 697.18 qps: 4180.07 (r/w/o: 0.00/2297.59/1882.48) lat (ms,95%): 64.47 err/s: 0.00 reconn/s: 0.00
[ 294s ] thds: 10 tps: 598.63 qps: 3605.78 (r/w/o: 0.00/1979.78/1626.00) lat (ms,95%): 69.29 err/s: 0.00 reconn/s: 0.00
[ 295s ] thds: 10 tps: 395.11 qps: 2393.68 (r/w/o: 0.00/1344.38/1049.30) lat (ms,95%): 62.19 err/s: 0.00 reconn/s: 0.00
[ 296s ] thds: 10 tps: 591.98 qps: 3546.87 (r/w/o: 0.00/1913.93/1632.94) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 297s ] thds: 10 tps: 545.06 qps: 3236.34 (r/w/o: 0.00/1750.18/1486.15) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00
[ 298s ] thds: 10 tps: 717.09 qps: 4305.56 (r/w/o: 0.00/2350.31/1955.25) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00
[ 299s ] thds: 10 tps: 672.85 qps: 4062.12 (r/w/o: 0.00/2254.51/1807.61) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 300s ] thds: 10 tps: 441.07 qps: 2646.40 (r/w/o: 0.00/1477.22/1169.18) lat (ms,95%): 65.65 err/s: 0.00 reconn/s: 0.00
测试结果
SQL statistics:
queries performed:
read: 0
write: 512113
other: 565747
total: 1077860
transactions: 179642 (598.71 per sec.)
queries: 1077860 (3592.29 per sec.)
ignored errors: 2 (0.01 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: 300.0468s
total number of events: 179642
Latency (ms):
min: 2.28
avg: 16.70
max: 478.35
95th percentile: 59.99
sum: 2999512.27
Threads fairness:
events (avg/stddev): 17964.2000/41.97
execution time (avg/stddev): 299.9512/0.00
测试完成-cleanup
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
Dropping table 'sbtest3'...
Dropping table 'sbtest4'...
Dropping table 'sbtest5'...
Dropping table 'sbtest6'...
Dropping table 'sbtest7'...
Dropping table 'sbtest8'...
Dropping table 'sbtest9'...
Dropping table 'sbtest10'...
Dropping table 'sbtest11'...
Dropping table 'sbtest12'...
Dropping table 'sbtest13'...
Dropping table 'sbtest14'...
Dropping table 'sbtest15'...
Dropping table 'sbtest16'...
Dropping table 'sbtest17'...
Dropping table 'sbtest18'...
Dropping table 'sbtest19'...
Dropping table 'sbtest20'...
测试汇总
| condition | read | write | other | total | transactions | tps | qps | min | avg | max | 95th |
|---|---|---|---|---|---|---|---|---|---|---|---|
| oltp_read_write | 403326 | 115236 | 57618 | 576180 | 28809 | 96.00 | 1920.04 | 6.25ms | 104.15ms | 882.75ms | 475.76ms |
| oltp_read_only | 1285144 | 0 | 183592 | 1468736 | 91796 | 305.66 | 4890.53 | 1.83ms | 32.71ms | 783.57ms | 36.24ms |
| oltp_delete | 0 | 182205 | 101024 | 283229 | 283229 | 943.98 | 943.98 | 0.05ms | 10.59ms | 763.43ms | 57.87ms |
| oltp_update_index | 0 | 204775 | 282872 | 487647 | 487647 | 1625.19 | 1625.19 | 0.06ms | 6.15ms | 614.80ms | 37.56ms |
| oltp_update_non_index | 0 | 268866 | 372813 | 641679 | 641679 | 2138.56 | 2138.56 | 0.06ms | 4.67ms | 577.42ms | 12.98ms |
| oltp_insert | 0 | 313992 | 0 | 313992 | 313992 | 1046.43 | 1046.43 | 1.87ms | 9.55ms | 700.03ms | 35.59ms |
| oltp_write_only | 0 | 512113 | 565747 | 1077860 | 179642 | 598.71 | 3592.29 | 2.28ms | 16.70ms | 478.35ms | 59.99ms |
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 被坑几百块钱后，我竟然真的恢复了删除的微信聊天记录！
· 没有Manus邀请码？试试免邀请码的MGX或者开源的OpenManus吧
· 【自荐】一款简洁、开源的在线白板工具 Drawnix
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· Docker 太简单，K8s 太复杂？w7panel 让容器管理更轻松！