sysbench
/usr/share/sysbench/oltp_read_only
.lua --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-socket=
/tmp/mysql
.sock --mysql-user=root --mysql-password=123456 --mysql-db=sysbench --tables=10 --table-size=500000 --report-interval=10 --
time
=120 --threads=50 run
sysbench
/usr/share/sysbench/oltp_read_write
.lua --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-socket=
/tmp/mysql
.sock --mysql-user=root --mysql-password=123456 --mysql-db=sysbench --tables=10 --table-size=500000 --report-interval=10 --
time
=120 --threads=50 run
[ 11s ] thds: 320 tps: 242.69 qps: 4209.17 (r
/w/o
: 3694.35
/0
.00
/514
.83) lat (ms,95%): 1678.14 err
/s
: 0.00 reconn
/s
: 0.00
[ 21s ] thds: 320 tps: 187.49 qps: 2996.82 (r
/w/o
: 2621.44
/0
.00
/375
.38) lat (ms,95%): 2120.76 err
/s
: 0.00 reconn
/s
: 0.00
[ 31s ] thds: 320 tps: 229.77 qps: 3649.12 (r
/w/o
: 3190.18
/0
.00
/458
.94) lat (ms,95%): 2159.29 err
/s
: 0.00 reconn
/s
: 0.00
[ 41s ] thds: 320 tps: 259.54 qps: 4175.73 (r
/w/o
: 3656.75
/0
.00
/518
.98) lat (ms,95%): 1803.47 err
/s
: 0.00 reconn
/s
: 0.00
[ 51s ] thds: 320 tps: 276.39 qps: 4406.96 (r
/w/o
: 3853.68
/0
.00
/553
.28) lat (ms,95%): 1589.90 err
/s
: 0.00 reconn
/s
: 0.00
[ 61s ] thds: 320 tps: 281.21 qps: 4496.82 (r
/w/o
: 3934.29
/0
.00
/562
.53) lat (ms,95%): 1561.52 err
/s
: 0.00 reconn
/s
: 0.00
[ 71s ] thds: 320 tps: 276.10 qps: 4435.70 (r
/w/o
: 3883.80
/0
.00
/551
.90) lat (ms,95%): 1648.20 err
/s
: 0.00 reconn
/s
: 0.00
[ 81s ] thds: 320 tps: 275.19 qps: 4392.43 (r
/w/o
: 3841.85
/0
.00
/550
.58) lat (ms,95%): 1618.78 err
/s
: 0.00 reconn
/s
: 0.00
[ 91s ] thds: 320 tps: 280.39 qps: 4491.68 (r
/w/o
: 3931.19
/0
.00
/560
.48) lat (ms,95%): 1589.90 err
/s
: 0.00 reconn
/s
: 0.00
[ 101s ] thds: 320 tps: 270.71 qps: 4334.41 (r
/w/o
: 3792.58
/0
.00
/541
.83) lat (ms,95%): 1678.14 err
/s
: 0.00 reconn
/s
: 0.00
[ 111s ] thds: 320 tps: 256.68 qps: 4100.25 (r
/w/o
: 3587.18
/0
.00
/513
.07) lat (ms,95%): 1771.29 err
/s
: 0.00 reconn
/s
: 0.00
[ 121s ] thds: 320 tps: 261.12 qps: 4087.48 (r
/w/o
: 3578.23
/0
.00
/509
.25) lat (ms,95%): 1708.63 err
/s
: 0.00 reconn
/s
: 0.00
SQL statistics:
queries performed:
read
: 438242
write: 0
other: 62606
total: 500848
transactions: 31303 (258.37 per sec.)
queries: 500848 (4133.87 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total
time
: 121.1541s
total number of events: 31303
Latency (ms):
min: 124.29
avg: 1232.39
max: 3681.62
95th percentile: 1836.24
sum
: 38577567.35
Threads fairness:
events (avg
/stddev
): 97.8219
/1
.70
execution
time
(avg
/stddev
): 120.5549
/0
.33
网友评论