-
Notifications
You must be signed in to change notification settings - Fork 0
/
sysbench.oltp_read_only.hash-partition.dynamic.2
57 lines (47 loc) · 2.84 KB
/
sysbench.oltp_read_only.hash-partition.dynamic.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:25:08 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: 1448.88 qps: 23240.44 (r/w/o: 20336.28/0.00/2904.16) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00
[ 20s ] thds: 64 tps: 1347.86 qps: 21569.03 (r/w/o: 18873.60/0.00/2695.43) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00
[ 30s ] thds: 64 tps: 1378.75 qps: 22061.51 (r/w/o: 19303.81/0.00/2757.70) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 40s ] thds: 64 tps: 1381.10 qps: 22090.56 (r/w/o: 19328.35/0.00/2762.21) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 50s ] thds: 64 tps: 1381.43 qps: 22104.51 (r/w/o: 19341.66/0.00/2762.85) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 60s ] thds: 64 tps: 1379.86 qps: 22074.83 (r/w/o: 19315.11/0.00/2759.72) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 70s ] thds: 64 tps: 1376.10 qps: 22024.78 (r/w/o: 19272.47/0.00/2752.31) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 80s ] thds: 64 tps: 1375.90 qps: 22010.21 (r/w/o: 19258.41/0.00/2751.80) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 90s ] thds: 64 tps: 1375.68 qps: 22012.94 (r/w/o: 19261.58/0.00/2751.35) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 100s ] thds: 64 tps: 1375.53 qps: 22011.77 (r/w/o: 19260.71/0.00/2751.06) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 110s ] thds: 64 tps: 1379.00 qps: 22055.13 (r/w/o: 19297.34/0.00/2757.79) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
[ 120s ] thds: 64 tps: 1377.41 qps: 22042.49 (r/w/o: 19287.58/0.00/2754.91) lat (ms,95%): 57.87 err/s: 0.00 reconn/s: 0.00
SQL statistics:
queries performed:
read: 2321774
write: 0
other: 331682
total: 2653456
transactions: 165841 (1381.62 per sec.)
queries: 2653456 (22105.99 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
Throughput:
events/s (eps): 1381.6241
time elapsed: 120.0334s
total number of events: 165841
Latency (ms):
min: 15.69
avg: 46.31
max: 173.61
95th percentile: 57.87
sum: 7680846.23
Threads fairness:
events (avg/stddev): 2591.2656/7.41
execution time (avg/stddev): 120.0132/0.01
real 2m0,062s
user 0m27,241s
sys 0m34,963s
ma 31 mei 2021 1:27:08 CEST