使用sysbench進行測驗，發現發送執行緒少的情況下，延遲反而高，請問哪些可能會造成這種現象？
機器：DELL R730 20C/256G
作業系統：centos7
資料庫版本：mysql8.0
補充：
1.測驗資料經過預熱
2.使用unix socket方式發送效果相同
--執行緒數為5
# sysbench select_random_ranges.lua --auto-inc=off --mysql-user=test --mysql-password='111' --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-db=db_test --db-ps-mode=disable --tables=100 --table_size=100000 --threads=5 --events=0 --time=30 --rand-type=special --report-interval=5 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 5
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 5 tps: 18559.75 qps: 18559.75 (r/w/o: 18559.75/0.00/0.00) lat (ms,95%): 0.32 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 5 tps: 18378.06 qps: 18378.06 (r/w/o: 18378.06/0.00/0.00) lat (ms,95%): 0.30 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 5 tps: 17994.46 qps: 17994.66 (r/w/o: 17994.66/0.00/0.00) lat (ms,95%): 0.35 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 5 tps: 17905.29 qps: 17905.09 (r/w/o: 17905.09/0.00/0.00) lat (ms,95%): 0.36 err/s: 0.00 reconn/s: 0.00
[ 25s ] thds: 5 tps: 18536.68 qps: 18536.68 (r/w/o: 18536.68/0.00/0.00) lat (ms,95%): 0.31 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 548087
write: 0
other: 0
total: 548087
transactions: 548087 (18267.22 per sec.)
queries: 548087 (18267.22 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 18267.2230
time elapsed: 30.0038s
total number of events: 548087
Latency (ms):
min: 0.14
avg: 0.27
max: 21.90
95th percentile: 0.34
sum: 149352.89
Threads fairness:
events (avg/stddev): 109617.4000/46844.87
execution time (avg/stddev): 29.8706/0.04
--執行緒數為1
# sysbench select_random_ranges.lua --auto-inc=off --mysql-user=test --mysql-password='111' --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-db=db_test --db-ps-mode=disable --tables=100 --table_size=100000 --threads=1 --events=0 --time=30 --rand-type=special --report-interval=5 run
sysbench 1.1.0 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 1
Report intermediate results every 5 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 5s ] thds: 1 tps: 644.83 qps: 644.83 (r/w/o: 644.83/0.00/0.00) lat (ms,95%): 1.96 err/s: 0.00 reconn/s: 0.00
[ 10s ] thds: 1 tps: 634.44 qps: 634.44 (r/w/o: 634.44/0.00/0.00) lat (ms,95%): 1.96 err/s: 0.00 reconn/s: 0.00
[ 15s ] thds: 1 tps: 611.43 qps: 611.43 (r/w/o: 611.43/0.00/0.00) lat (ms,95%): 2.07 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 1 tps: 611.72 qps: 611.72 (r/w/o: 611.72/0.00/0.00) lat (ms,95%): 2.03 err/s: 0.00 reconn/s: 0.00
[ 25s ] thds: 1 tps: 600.83 qps: 600.83 (r/w/o: 600.83/0.00/0.00) lat (ms,95%): 2.07 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 18548
write: 0
other: 0
total: 18548
transactions: 18548 (618.20 per sec.)
queries: 18548 (618.20 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 618.1982
time elapsed: 30.0033s
total number of events: 18548
Latency (ms):
min: 0.45
avg: 1.61
max: 15.20
95th percentile: 2.03
sum: 29942.56
Threads fairness:
events (avg/stddev): 18548.0000/0.00
execution time (avg/stddev): 29.9426/0.00
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/250917.html
標籤：MySQL