1
sysbench 0.5: multi-threaded system evaluation benchmark
3
Running the test with following options:
5
Report intermediate results every 10 second(s)
6
Initializing random number generator from timer.
8
Random number generator seed is 0 and will be ignored
13
[ 10s] threads: 2, tps: 549.29, reads/s: 7692.00, writes/s: 2197.17
14
[ 20s] threads: 2, tps: 640.50, reads/s: 8966.28, writes/s: 2561.99
15
[ 30s] threads: 2, tps: 639.50, reads/s: 8954.30, writes/s: 2558.00
16
[ 40s] threads: 2, tps: 643.80, reads/s: 9012.83, writes/s: 2575.21
17
[ 50s] threads: 2, tps: 643.30, reads/s: 9006.17, writes/s: 2573.19
18
[ 60s] threads: 2, tps: 642.00, reads/s: 8987.02, writes/s: 2568.01
19
[ 70s] threads: 2, tps: 636.20, reads/s: 8907.70, writes/s: 2544.80
20
[ 80s] threads: 2, tps: 643.00, reads/s: 9002.18, writes/s: 2571.99
21
[ 90s] threads: 2, tps: 645.20, reads/s: 9031.99, writes/s: 2581.10
22
[ 100s] threads: 2, tps: 642.90, reads/s: 9001.20, writes/s: 2571.30
23
[ 110s] threads: 2, tps: 641.50, reads/s: 8981.32, writes/s: 2566.01
24
[ 120s] threads: 2, tps: 642.30, reads/s: 8992.71, writes/s: 2569.20
25
[ 130s] threads: 2, tps: 642.60, reads/s: 8996.39, writes/s: 2570.90
26
[ 140s] threads: 2, tps: 641.80, reads/s: 8985.19, writes/s: 2567.50
27
[ 150s] threads: 2, tps: 644.50, reads/s: 9022.82, writes/s: 2577.20
28
[ 160s] threads: 2, tps: 641.10, reads/s: 8975.55, writes/s: 2565.18
29
[ 170s] threads: 2, tps: 643.40, reads/s: 9007.13, writes/s: 2572.81
30
[ 180s] threads: 2, tps: 644.80, reads/s: 9027.63, writes/s: 2579.21
31
[ 190s] threads: 2, tps: 645.00, reads/s: 9029.89, writes/s: 2580.40
32
[ 200s] threads: 2, tps: 643.40, reads/s: 9004.98, writes/s: 2573.20
33
[ 210s] threads: 2, tps: 643.70, reads/s: 9014.50, writes/s: 2575.20
34
[ 220s] threads: 2, tps: 643.90, reads/s: 9014.08, writes/s: 2575.60
35
[ 230s] threads: 2, tps: 642.70, reads/s: 8998.41, writes/s: 2571.20
36
[ 240s] threads: 2, tps: 645.90, reads/s: 9042.62, writes/s: 2583.21
37
[ 250s] threads: 2, tps: 646.50, reads/s: 9048.69, writes/s: 2585.60
38
[ 260s] threads: 2, tps: 643.80, reads/s: 9014.60, writes/s: 2575.20
39
[ 270s] threads: 2, tps: 649.00, reads/s: 9086.70, writes/s: 2596.00
40
[ 280s] threads: 2, tps: 643.50, reads/s: 9009.00, writes/s: 2574.00
41
[ 290s] threads: 2, tps: 645.20, reads/s: 9031.92, writes/s: 2580.81
42
[ 300s] threads: 2, tps: 646.30, reads/s: 9049.18, writes/s: 2585.19
43
[ 310s] threads: 2, tps: 646.20, reads/s: 9046.71, writes/s: 2584.80
44
[ 320s] threads: 2, tps: 646.40, reads/s: 9049.79, writes/s: 2586.30
45
[ 330s] threads: 2, tps: 645.90, reads/s: 9040.80, writes/s: 2582.90
46
[ 340s] threads: 2, tps: 647.00, reads/s: 9058.80, writes/s: 2588.00
47
[ 350s] threads: 2, tps: 646.70, reads/s: 9053.70, writes/s: 2586.80
48
[ 360s] threads: 2, tps: 646.70, reads/s: 9054.72, writes/s: 2586.81
49
[ 370s] threads: 2, tps: 647.50, reads/s: 9062.57, writes/s: 2589.99
50
[ 380s] threads: 2, tps: 637.20, reads/s: 8923.26, writes/s: 2548.82
51
[ 390s] threads: 2, tps: 643.90, reads/s: 9013.34, writes/s: 2575.58
52
[ 400s] threads: 2, tps: 645.30, reads/s: 9034.02, writes/s: 2581.20
53
[ 410s] threads: 2, tps: 646.90, reads/s: 9058.09, writes/s: 2587.60
54
[ 420s] threads: 2, tps: 645.30, reads/s: 9033.82, writes/s: 2581.20
55
[ 430s] threads: 2, tps: 647.10, reads/s: 9059.88, writes/s: 2588.89
56
[ 440s] threads: 2, tps: 646.00, reads/s: 9043.81, writes/s: 2583.70
57
[ 450s] threads: 2, tps: 643.70, reads/s: 9011.79, writes/s: 2574.60
58
[ 460s] threads: 2, tps: 644.50, reads/s: 9023.02, writes/s: 2578.01
59
[ 470s] threads: 2, tps: 644.00, reads/s: 9015.98, writes/s: 2575.99
60
[ 480s] threads: 2, tps: 642.00, reads/s: 8987.80, writes/s: 2568.00
61
[ 490s] threads: 2, tps: 643.70, reads/s: 9012.20, writes/s: 2575.40
62
[ 500s] threads: 2, tps: 638.90, reads/s: 8944.30, writes/s: 2555.00
69
transactions: 321017 (642.03 per sec.)
70
deadlocks: 0 (0.00 per sec.)
71
read/write requests: 5778306 (11556.57 per sec.)
72
other operations: 642034 (1284.06 per sec.)
74
Test execution summary:
76
total number of events: 321017
77
total time taken by event execution: 999.8441s
78
per-request statistics:
82
approx. 95 percentile: 3.30ms
85
events (avg/stddev): 160508.5000/160.50
86
execution time (avg/stddev): 499.9220/0.01
88
sysbench 0.5: multi-threaded system evaluation benchmark
90
Running the test with following options:
92
Report intermediate results every 10 second(s)
93
Initializing random number generator from timer.
95
Random number generator seed is 0 and will be ignored
100
[ 10s] threads: 2, tps: 471.99, reads/s: 6610.66, writes/s: 1888.36
101
[ 20s] threads: 2, tps: 631.70, reads/s: 8842.43, writes/s: 2526.81
102
[ 30s] threads: 2, tps: 644.80, reads/s: 9028.52, writes/s: 2578.90
103
[ 40s] threads: 2, tps: 645.00, reads/s: 9029.70, writes/s: 2579.90
104
[ 50s] threads: 2, tps: 645.20, reads/s: 9033.00, writes/s: 2580.80
105
[ 60s] threads: 2, tps: 646.50, reads/s: 9051.20, writes/s: 2586.60
106
[ 70s] threads: 2, tps: 645.40, reads/s: 9034.98, writes/s: 2581.00
107
[ 80s] threads: 2, tps: 636.80, reads/s: 8915.61, writes/s: 2547.60
108
[ 90s] threads: 2, tps: 634.50, reads/s: 8883.19, writes/s: 2538.20
109
[ 100s] threads: 2, tps: 639.30, reads/s: 8950.02, writes/s: 2556.61
110
[ 110s] threads: 2, tps: 644.10, reads/s: 9016.78, writes/s: 2576.39
111
[ 120s] threads: 2, tps: 641.50, reads/s: 8981.70, writes/s: 2566.00
112
[ 130s] threads: 2, tps: 642.23, reads/s: 8990.70, writes/s: 2568.91
113
[ 140s] threads: 2, tps: 631.57, reads/s: 8842.61, writes/s: 2526.29
114
[ 150s] threads: 2, tps: 643.60, reads/s: 9010.20, writes/s: 2574.40
115
[ 160s] threads: 2, tps: 646.80, reads/s: 9054.37, writes/s: 2587.59
116
[ 170s] threads: 2, tps: 641.00, reads/s: 8974.51, writes/s: 2563.60
117
[ 180s] threads: 2, tps: 643.70, reads/s: 9011.90, writes/s: 2574.80
118
[ 190s] threads: 2, tps: 644.40, reads/s: 9021.80, writes/s: 2577.60
119
[ 200s] threads: 2, tps: 644.30, reads/s: 9019.52, writes/s: 2577.61
120
[ 210s] threads: 2, tps: 645.00, reads/s: 9030.70, writes/s: 2579.60
121
[ 220s] threads: 2, tps: 644.10, reads/s: 9017.58, writes/s: 2576.49
122
[ 230s] threads: 2, tps: 645.20, reads/s: 9031.02, writes/s: 2580.71
123
[ 240s] threads: 2, tps: 643.70, reads/s: 9012.94, writes/s: 2574.78
124
[ 250s] threads: 2, tps: 643.00, reads/s: 9002.65, writes/s: 2572.82
125
[ 260s] threads: 2, tps: 642.20, reads/s: 8989.98, writes/s: 2568.00
126
[ 270s] threads: 2, tps: 641.90, reads/s: 8986.10, writes/s: 2567.60
127
[ 280s] threads: 2, tps: 644.40, reads/s: 9022.60, writes/s: 2577.60
128
[ 290s] threads: 2, tps: 645.50, reads/s: 9036.41, writes/s: 2582.00
129
OLTP test statistics:
135
transactions: 191033 (636.77 per sec.)
136
deadlocks: 0 (0.00 per sec.)
137
read/write requests: 3438594 (11461.92 per sec.)
138
other operations: 382066 (1273.55 per sec.)
140
Test execution summary:
141
total time: 300.0016s
142
total number of events: 191033
143
total time taken by event execution: 599.9033s
144
per-request statistics:
148
approx. 95 percentile: 3.31ms
151
events (avg/stddev): 95516.5000/441.50
152
execution time (avg/stddev): 299.9517/0.00
154
sysbench 0.5: multi-threaded system evaluation benchmark
156
Running the test with following options:
158
Report intermediate results every 10 second(s)
159
Initializing random number generator from timer.
161
Random number generator seed is 0 and will be ignored
166
[ 10s] threads: 2, tps: 559.25, reads/s: 7831.99, writes/s: 2237.40
167
[ 20s] threads: 2, tps: 588.52, reads/s: 8238.64, writes/s: 2353.87
168
[ 30s] threads: 2, tps: 657.40, reads/s: 9204.51, writes/s: 2629.61
169
[ 40s] threads: 2, tps: 657.36, reads/s: 9202.61, writes/s: 2629.23
170
[ 50s] threads: 2, tps: 649.96, reads/s: 9098.18, writes/s: 2599.83
171
[ 60s] threads: 2, tps: 644.79, reads/s: 9028.72, writes/s: 2579.98
172
[ 70s] threads: 2, tps: 649.77, reads/s: 9096.80, writes/s: 2598.99
173
[ 81s] threads: 2, tps: 618.30, reads/s: 8656.22, writes/s: 2473.30
174
[ 90s] threads: 2, tps: 661.02, reads/s: 9251.75, writes/s: 2643.20
175
[ 100s] threads: 2, tps: 653.08, reads/s: 9145.39, writes/s: 2613.01
176
[ 110s] threads: 2, tps: 539.43, reads/s: 7552.03, writes/s: 2157.13
177
[ 120s] threads: 2, tps: 643.51, reads/s: 9006.97, writes/s: 2573.95
178
[ 130s] threads: 2, tps: 646.45, reads/s: 9052.49, writes/s: 2586.60
179
[ 140s] threads: 2, tps: 644.33, reads/s: 9020.64, writes/s: 2577.33
180
[ 151s] threads: 2, tps: 568.88, reads/s: 7964.30, writes/s: 2275.52
181
[ 160s] threads: 2, tps: 580.86, reads/s: 8132.09, writes/s: 2323.46
182
[ 171s] threads: 2, tps: 615.42, reads/s: 8614.87, writes/s: 2460.93
183
[ 181s] threads: 2, tps: 559.67, reads/s: 7836.42, writes/s: 2239.26
184
[ 190s] threads: 2, tps: 651.33, reads/s: 9117.14, writes/s: 2605.11
185
[ 200s] threads: 2, tps: 648.93, reads/s: 9086.26, writes/s: 2595.33
186
[ 210s] threads: 2, tps: 654.27, reads/s: 9160.04, writes/s: 2617.49
187
[ 220s] threads: 2, tps: 629.24, reads/s: 8809.09, writes/s: 2516.54
188
[ 230s] threads: 2, tps: 621.31, reads/s: 8698.55, writes/s: 2486.03
189
[ 240s] threads: 2, tps: 516.85, reads/s: 7235.89, writes/s: 2067.30
190
[ 250s] threads: 2, tps: 645.96, reads/s: 9043.41, writes/s: 2583.93
191
[ 261s] threads: 2, tps: 647.82, reads/s: 9068.15, writes/s: 2590.48
192
[ 270s] threads: 2, tps: 647.46, reads/s: 9063.00, writes/s: 2589.82
193
[ 280s] threads: 2, tps: 646.90, reads/s: 9058.40, writes/s: 2587.60
194
[ 290s] threads: 2, tps: 644.90, reads/s: 9029.22, writes/s: 2579.60
195
[ 300s] threads: 2, tps: 647.70, reads/s: 9067.81, writes/s: 2590.80
196
OLTP test statistics:
202
transactions: 187351 (624.50 per sec.)
203
deadlocks: 0 (0.00 per sec.)
204
read/write requests: 3372318 (11240.99 per sec.)
205
other operations: 374702 (1249.00 per sec.)
207
Test execution summary:
208
total time: 300.0018s
209
total number of events: 187351
210
total time taken by event execution: 599.9083s
211
per-request statistics:
215
approx. 95 percentile: 3.50ms
218
events (avg/stddev): 93675.5000/91.50
219
execution time (avg/stddev): 299.9542/0.00
221
sysbench 0.5: multi-threaded system evaluation benchmark
223
Running the test with following options:
225
Report intermediate results every 10 second(s)
226
Initializing random number generator from timer.
228
Random number generator seed is 0 and will be ignored
233
[ 10s] threads: 2, tps: 538.09, reads/s: 7535.38, writes/s: 2152.36
234
[ 20s] threads: 2, tps: 634.30, reads/s: 8880.50, writes/s: 2537.20
235
[ 30s] threads: 2, tps: 642.20, reads/s: 8988.52, writes/s: 2568.81
236
[ 40s] threads: 2, tps: 641.40, reads/s: 8981.71, writes/s: 2565.60
237
[ 50s] threads: 2, tps: 644.10, reads/s: 9016.00, writes/s: 2576.40
238
[ 60s] threads: 2, tps: 645.00, reads/s: 9032.00, writes/s: 2580.80
239
[ 70s] threads: 2, tps: 644.90, reads/s: 9028.41, writes/s: 2578.80
240
[ 80s] threads: 2, tps: 642.00, reads/s: 8988.00, writes/s: 2568.00
241
[ 90s] threads: 2, tps: 629.80, reads/s: 8816.70, writes/s: 2519.20
242
[ 100s] threads: 2, tps: 624.60, reads/s: 8742.60, writes/s: 2498.40
243
[ 110s] threads: 2, tps: 627.70, reads/s: 8790.20, writes/s: 2511.20
244
[ 120s] threads: 2, tps: 634.80, reads/s: 8887.00, writes/s: 2538.80
245
[ 130s] threads: 2, tps: 644.50, reads/s: 9022.60, writes/s: 2578.00
246
[ 140s] threads: 2, tps: 637.80, reads/s: 8927.50, writes/s: 2551.20
247
[ 150s] threads: 2, tps: 644.30, reads/s: 9021.89, writes/s: 2577.20
248
[ 160s] threads: 2, tps: 643.40, reads/s: 9005.60, writes/s: 2573.60
249
[ 170s] threads: 2, tps: 643.60, reads/s: 9012.10, writes/s: 2574.40
250
[ 180s] threads: 2, tps: 641.20, reads/s: 8975.60, writes/s: 2564.80
251
[ 190s] threads: 2, tps: 643.70, reads/s: 9013.80, writes/s: 2574.80
252
[ 200s] threads: 2, tps: 642.20, reads/s: 8990.40, writes/s: 2568.80
253
[ 210s] threads: 2, tps: 643.80, reads/s: 9013.84, writes/s: 2576.01
254
[ 220s] threads: 2, tps: 630.60, reads/s: 8827.30, writes/s: 2521.60
255
[ 230s] threads: 2, tps: 647.60, reads/s: 9065.40, writes/s: 2590.40
256
[ 240s] threads: 2, tps: 644.40, reads/s: 9023.49, writes/s: 2577.60
257
[ 250s] threads: 2, tps: 641.60, reads/s: 8982.60, writes/s: 2566.90
258
[ 260s] threads: 2, tps: 642.50, reads/s: 8994.60, writes/s: 2569.50
259
[ 270s] threads: 2, tps: 643.80, reads/s: 9012.10, writes/s: 2575.20
260
[ 280s] threads: 2, tps: 640.80, reads/s: 8972.64, writes/s: 2563.78
261
[ 290s] threads: 2, tps: 645.50, reads/s: 9035.35, writes/s: 2581.42
262
[ 300s] threads: 2, tps: 643.00, reads/s: 9003.50, writes/s: 2572.00
263
OLTP test statistics:
269
transactions: 191134 (637.11 per sec.)
270
deadlocks: 0 (0.00 per sec.)
271
read/write requests: 3440412 (11467.98 per sec.)
272
other operations: 382268 (1274.22 per sec.)
274
Test execution summary:
275
total time: 300.0015s
276
total number of events: 191134
277
total time taken by event execution: 599.9058s
278
per-request statistics:
282
approx. 95 percentile: 3.42ms
285
events (avg/stddev): 95567.0000/502.00
286
execution time (avg/stddev): 299.9529/0.00