-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsysbench.oltp_read_only.hash-partition.static.2
57 lines (47 loc) · 2.83 KB
/
sysbench.oltp_read_only.hash-partition.static.2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
ma 31 mei 2021 1:22:47 CEST
sysbench 1.1.0-ead2689 (using bundled LuaJIT 2.1.0-beta3)
Running the test with following options:
Number of threads: 64
Report intermediate results every 10 second(s)
Initializing random number generator from current time
Initializing worker threads...
Threads started!
[ 10s ] thds: 64 tps: 770.08 qps: 12396.49 (r/w/o: 10849.93/0.00/1546.56) lat (ms,95%): 106.75 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 64 tps: 733.01 qps: 11717.54 (r/w/o: 10251.53/0.00/1466.02) lat (ms,95%): 114.72 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 64 tps: 736.80 qps: 11787.85 (r/w/o: 10314.24/0.00/1473.61) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 64 tps: 736.40 qps: 11784.18 (r/w/o: 10311.39/0.00/1472.80) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 64 tps: 738.40 qps: 11816.16 (r/w/o: 10339.36/0.00/1476.79) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 64 tps: 737.20 qps: 11779.07 (r/w/o: 10304.97/0.00/1474.10) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 64 tps: 736.30 qps: 11797.74 (r/w/o: 10324.83/0.00/1472.90) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 64 tps: 737.40 qps: 11796.07 (r/w/o: 10321.28/0.00/1474.80) lat (ms,95%): 110.66 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 64 tps: 734.70 qps: 11760.79 (r/w/o: 10291.39/0.00/1469.40) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 64 tps: 736.70 qps: 11779.99 (r/w/o: 10306.59/0.00/1473.40) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 64 tps: 736.30 qps: 11783.91 (r/w/o: 10311.61/0.00/1472.30) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 64 tps: 737.30 qps: 11784.44 (r/w/o: 10309.63/0.00/1474.80) lat (ms,95%): 112.67 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 1242794
write: 0
other: 177542
total: 1420336
transactions: 88771 (739.35 per sec.)
queries: 1420336 (11829.55 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 739.3469
time elapsed: 120.0668s
total number of events: 88771
Latency (ms):
min: 35.56
avg: 86.54
max: 209.29
95th percentile: 110.66
sum: 7682647.91
Threads fairness:
events (avg/stddev): 1387.0469/5.83
execution time (avg/stddev): 120.0414/0.02
real 2m0,095s
user 0m17,379s
sys 0m19,692s
ma 31 mei 2021 1:24:47 CEST