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: 1, tps: 51.50, reads/s: 722.38, writes/s: 206.00
14
[ 20s] threads: 1, tps: 58.10, reads/s: 813.30, writes/s: 232.40
15
[ 30s] threads: 1, tps: 60.20, reads/s: 842.90, writes/s: 240.80
16
[ 40s] threads: 1, tps: 58.70, reads/s: 821.80, writes/s: 235.00
17
[ 50s] threads: 1, tps: 61.80, reads/s: 865.20, writes/s: 247.20
18
[ 60s] threads: 1, tps: 62.70, reads/s: 877.79, writes/s: 250.80
19
[ 70s] threads: 1, tps: 61.70, reads/s: 863.81, writes/s: 246.60
20
[ 80s] threads: 1, tps: 60.90, reads/s: 852.60, writes/s: 243.80
21
[ 90s] threads: 1, tps: 62.30, reads/s: 872.20, writes/s: 249.20
22
[ 100s] threads: 1, tps: 68.90, reads/s: 964.60, writes/s: 275.60
23
[ 110s] threads: 1, tps: 70.10, reads/s: 981.40, writes/s: 280.40
24
[ 120s] threads: 1, tps: 69.70, reads/s: 975.80, writes/s: 278.80
25
[ 130s] threads: 1, tps: 72.50, reads/s: 1014.99, writes/s: 290.00
26
[ 140s] threads: 1, tps: 72.90, reads/s: 1020.61, writes/s: 291.60
27
[ 150s] threads: 1, tps: 78.60, reads/s: 1100.40, writes/s: 314.60
28
[ 160s] threads: 1, tps: 81.20, reads/s: 1136.80, writes/s: 324.60
29
[ 170s] threads: 1, tps: 77.90, reads/s: 1090.60, writes/s: 311.60
30
[ 180s] threads: 1, tps: 78.00, reads/s: 1092.00, writes/s: 312.00
31
[ 190s] threads: 1, tps: 82.60, reads/s: 1156.39, writes/s: 330.50
32
[ 200s] threads: 1, tps: 86.90, reads/s: 1216.60, writes/s: 347.50
33
[ 210s] threads: 1, tps: 90.20, reads/s: 1262.80, writes/s: 360.60
34
[ 220s] threads: 1, tps: 93.40, reads/s: 1306.70, writes/s: 373.60
35
[ 230s] threads: 1, tps: 94.00, reads/s: 1316.90, writes/s: 376.00
36
[ 240s] threads: 1, tps: 95.80, reads/s: 1341.20, writes/s: 383.20
37
[ 250s] threads: 1, tps: 98.00, reads/s: 1372.01, writes/s: 392.30
38
[ 260s] threads: 1, tps: 101.20, reads/s: 1416.79, writes/s: 404.70
39
[ 270s] threads: 1, tps: 107.40, reads/s: 1503.50, writes/s: 429.40
40
[ 280s] threads: 1, tps: 108.30, reads/s: 1516.29, writes/s: 433.20
41
[ 290s] threads: 1, tps: 107.50, reads/s: 1505.01, writes/s: 430.00
42
[ 300s] threads: 1, tps: 111.90, reads/s: 1566.59, writes/s: 447.70
43
[ 310s] threads: 1, tps: 116.80, reads/s: 1635.21, writes/s: 467.30
44
[ 320s] threads: 1, tps: 108.20, reads/s: 1514.81, writes/s: 432.80
45
[ 330s] threads: 1, tps: 111.90, reads/s: 1566.40, writes/s: 447.40
46
[ 340s] threads: 1, tps: 117.00, reads/s: 1637.30, writes/s: 468.00
47
[ 350s] threads: 1, tps: 123.00, reads/s: 1722.80, writes/s: 492.00
48
[ 360s] threads: 1, tps: 123.10, reads/s: 1723.50, writes/s: 492.40
49
[ 370s] threads: 1, tps: 127.10, reads/s: 1779.40, writes/s: 508.60
50
[ 380s] threads: 1, tps: 122.50, reads/s: 1714.99, writes/s: 490.00
51
[ 390s] threads: 1, tps: 139.40, reads/s: 1951.60, writes/s: 557.40
52
[ 400s] threads: 1, tps: 143.60, reads/s: 2010.20, writes/s: 574.40
53
[ 410s] threads: 1, tps: 124.60, reads/s: 1744.61, writes/s: 498.60
54
[ 420s] threads: 1, tps: 139.80, reads/s: 1957.20, writes/s: 559.00
55
[ 430s] threads: 1, tps: 148.40, reads/s: 2077.60, writes/s: 593.60
56
[ 440s] threads: 1, tps: 149.80, reads/s: 2097.20, writes/s: 599.30
57
[ 450s] threads: 1, tps: 157.20, reads/s: 2200.79, writes/s: 629.10
58
[ 460s] threads: 1, tps: 153.70, reads/s: 2151.80, writes/s: 614.80
59
[ 470s] threads: 1, tps: 161.90, reads/s: 2266.21, writes/s: 647.20
60
[ 480s] threads: 1, tps: 161.80, reads/s: 2265.59, writes/s: 647.40
61
[ 490s] threads: 1, tps: 169.50, reads/s: 2373.00, writes/s: 678.00
62
[ 500s] threads: 1, tps: 176.40, reads/s: 2469.61, writes/s: 705.40
69
transactions: 51607 (103.21 per sec.)
70
deadlocks: 0 (0.00 per sec.)
71
read/write requests: 928926 (1857.84 per sec.)
72
other operations: 103214 (206.43 per sec.)
74
Test execution summary:
76
total number of events: 51607
77
total time taken by event execution: 499.9389s
78
per-request statistics:
82
approx. 95 percentile: 21.24ms
85
events (avg/stddev): 51607.0000/0.00
86
execution time (avg/stddev): 499.9389/0.00
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: 1, tps: 187.09, reads/s: 2620.63, writes/s: 748.38
101
[ 20s] threads: 1, tps: 224.50, reads/s: 3143.12, writes/s: 898.10
102
[ 30s] threads: 1, tps: 229.10, reads/s: 3206.99, writes/s: 916.30
103
[ 40s] threads: 1, tps: 238.80, reads/s: 3342.21, writes/s: 955.20
104
[ 50s] threads: 1, tps: 246.30, reads/s: 3449.60, writes/s: 985.20
105
[ 60s] threads: 1, tps: 247.70, reads/s: 3467.80, writes/s: 990.80
106
[ 70s] threads: 1, tps: 249.70, reads/s: 3495.80, writes/s: 999.20
107
[ 80s] threads: 1, tps: 259.10, reads/s: 3627.10, writes/s: 1036.00
108
[ 90s] threads: 1, tps: 267.70, reads/s: 3748.10, writes/s: 1071.00
109
[ 100s] threads: 1, tps: 265.80, reads/s: 3721.17, writes/s: 1062.99
110
[ 110s] threads: 1, tps: 230.40, reads/s: 3225.59, writes/s: 921.80
111
[ 120s] threads: 1, tps: 234.80, reads/s: 3286.42, writes/s: 939.01
112
[ 130s] threads: 1, tps: 253.40, reads/s: 3548.01, writes/s: 1013.60
113
[ 140s] threads: 1, tps: 290.10, reads/s: 4061.80, writes/s: 1160.40
114
[ 150s] threads: 1, tps: 294.80, reads/s: 4127.10, writes/s: 1179.20
115
[ 160s] threads: 1, tps: 297.40, reads/s: 4163.50, writes/s: 1189.60
116
[ 170s] threads: 1, tps: 300.00, reads/s: 4199.10, writes/s: 1200.00
117
[ 180s] threads: 1, tps: 305.30, reads/s: 4275.00, writes/s: 1221.20
118
[ 190s] threads: 1, tps: 305.50, reads/s: 4277.32, writes/s: 1222.20
119
[ 200s] threads: 1, tps: 319.20, reads/s: 4468.18, writes/s: 1276.60
120
[ 210s] threads: 1, tps: 312.10, reads/s: 4369.00, writes/s: 1248.40
121
[ 220s] threads: 1, tps: 325.40, reads/s: 4555.50, writes/s: 1301.60
122
[ 230s] threads: 1, tps: 329.20, reads/s: 4608.60, writes/s: 1316.80
123
[ 240s] threads: 1, tps: 328.70, reads/s: 4603.10, writes/s: 1315.00
124
[ 250s] threads: 1, tps: 328.00, reads/s: 4591.20, writes/s: 1311.80
125
[ 260s] threads: 1, tps: 335.30, reads/s: 4693.90, writes/s: 1341.20
126
[ 270s] threads: 1, tps: 334.40, reads/s: 4681.30, writes/s: 1337.60
127
[ 280s] threads: 1, tps: 274.80, reads/s: 3847.26, writes/s: 1099.19
128
[ 290s] threads: 1, tps: 288.20, reads/s: 4036.13, writes/s: 1152.91
129
[ 300s] threads: 1, tps: 302.40, reads/s: 4233.60, writes/s: 1209.50
130
OLTP test statistics:
136
transactions: 84053 (280.17 per sec.)
137
deadlocks: 0 (0.00 per sec.)
138
read/write requests: 1512954 (5043.10 per sec.)
139
other operations: 168106 (560.34 per sec.)
141
Test execution summary:
142
total time: 300.0045s
143
total number of events: 84053
144
total time taken by event execution: 299.9681s
145
per-request statistics:
149
approx. 95 percentile: 9.57ms
152
events (avg/stddev): 84053.0000/0.00
153
execution time (avg/stddev): 299.9681/0.00
155
sysbench 0.5: multi-threaded system evaluation benchmark
157
Running the test with following options:
159
Report intermediate results every 10 second(s)
160
Initializing random number generator from timer.
162
Random number generator seed is 0 and will be ignored
167
[ 10s] threads: 1, tps: 254.09, reads/s: 3558.72, writes/s: 1016.78
168
[ 20s] threads: 1, tps: 365.20, reads/s: 5112.50, writes/s: 1460.40
169
[ 30s] threads: 1, tps: 368.80, reads/s: 5163.40, writes/s: 1475.20
170
[ 40s] threads: 1, tps: 374.10, reads/s: 5236.10, writes/s: 1496.40
171
[ 50s] threads: 1, tps: 369.10, reads/s: 5168.80, writes/s: 1476.80
172
[ 60s] threads: 1, tps: 372.70, reads/s: 5217.80, writes/s: 1490.80
173
[ 70s] threads: 1, tps: 375.90, reads/s: 5262.60, writes/s: 1503.50
174
[ 80s] threads: 1, tps: 375.70, reads/s: 5259.70, writes/s: 1502.50
175
[ 90s] threads: 1, tps: 378.00, reads/s: 5292.10, writes/s: 1512.40
176
[ 100s] threads: 1, tps: 379.10, reads/s: 5307.20, writes/s: 1516.00
177
[ 110s] threads: 1, tps: 380.20, reads/s: 5323.00, writes/s: 1521.20
178
[ 120s] threads: 1, tps: 379.30, reads/s: 5310.20, writes/s: 1517.20
179
[ 130s] threads: 1, tps: 379.60, reads/s: 5314.30, writes/s: 1518.00
180
[ 140s] threads: 1, tps: 382.60, reads/s: 5356.50, writes/s: 1530.80
181
[ 150s] threads: 1, tps: 370.30, reads/s: 5182.80, writes/s: 1480.80
182
[ 160s] threads: 1, tps: 296.80, reads/s: 4156.50, writes/s: 1187.20
183
[ 170s] threads: 1, tps: 371.90, reads/s: 5206.30, writes/s: 1487.60
184
[ 180s] threads: 1, tps: 321.60, reads/s: 4502.79, writes/s: 1286.70
185
[ 190s] threads: 1, tps: 350.20, reads/s: 4902.60, writes/s: 1400.50
186
[ 200s] threads: 1, tps: 385.60, reads/s: 5397.20, writes/s: 1542.40
187
[ 210s] threads: 1, tps: 388.40, reads/s: 5438.60, writes/s: 1553.60
188
[ 220s] threads: 1, tps: 387.60, reads/s: 5426.30, writes/s: 1550.40
189
[ 230s] threads: 1, tps: 387.10, reads/s: 5419.70, writes/s: 1548.40
190
[ 240s] threads: 1, tps: 389.50, reads/s: 5452.40, writes/s: 1558.00
191
[ 250s] threads: 1, tps: 312.90, reads/s: 4381.40, writes/s: 1252.00
192
[ 260s] threads: 1, tps: 385.70, reads/s: 5399.81, writes/s: 1542.50
193
[ 270s] threads: 1, tps: 360.70, reads/s: 5049.69, writes/s: 1442.70
194
[ 280s] threads: 1, tps: 322.00, reads/s: 4508.00, writes/s: 1288.00
195
[ 290s] threads: 1, tps: 388.00, reads/s: 5432.10, writes/s: 1552.00
196
[ 300s] threads: 1, tps: 391.40, reads/s: 5479.40, writes/s: 1565.60
197
OLTP test statistics:
203
transactions: 109442 (364.80 per sec.)
204
deadlocks: 0 (0.00 per sec.)
205
read/write requests: 1969956 (6566.47 per sec.)
206
other operations: 218884 (729.61 per sec.)
208
Test execution summary:
209
total time: 300.0021s
210
total number of events: 109442
211
total time taken by event execution: 299.9569s
212
per-request statistics:
216
approx. 95 percentile: 3.35ms
219
events (avg/stddev): 109442.0000/0.00
220
execution time (avg/stddev): 299.9569/0.00
222
sysbench 0.5: multi-threaded system evaluation benchmark
224
Running the test with following options:
226
Report intermediate results every 10 second(s)
227
Initializing random number generator from timer.
229
Random number generator seed is 0 and will be ignored
234
[ 10s] threads: 1, tps: 248.60, reads/s: 3481.24, writes/s: 994.38
235
[ 20s] threads: 1, tps: 369.60, reads/s: 5174.70, writes/s: 1478.40
236
[ 30s] threads: 1, tps: 393.10, reads/s: 5503.50, writes/s: 1572.40
237
[ 40s] threads: 1, tps: 392.40, reads/s: 5493.70, writes/s: 1569.70
238
[ 50s] threads: 1, tps: 390.80, reads/s: 5471.00, writes/s: 1563.10
239
[ 60s] threads: 1, tps: 392.50, reads/s: 5494.40, writes/s: 1570.00
240
[ 70s] threads: 1, tps: 391.30, reads/s: 5478.30, writes/s: 1565.20
241
[ 80s] threads: 1, tps: 393.40, reads/s: 5508.30, writes/s: 1574.00
242
[ 90s] threads: 1, tps: 393.40, reads/s: 5507.60, writes/s: 1573.60
243
[ 100s] threads: 1, tps: 391.90, reads/s: 5485.40, writes/s: 1567.20
244
[ 110s] threads: 1, tps: 393.00, reads/s: 5503.20, writes/s: 1572.10
245
[ 120s] threads: 1, tps: 394.10, reads/s: 5517.00, writes/s: 1576.30
246
[ 130s] threads: 1, tps: 391.10, reads/s: 5475.70, writes/s: 1564.40
247
[ 140s] threads: 1, tps: 393.70, reads/s: 5511.90, writes/s: 1575.10
248
[ 150s] threads: 1, tps: 394.50, reads/s: 5522.90, writes/s: 1577.70
249
[ 160s] threads: 1, tps: 393.30, reads/s: 5506.00, writes/s: 1573.20
250
[ 170s] threads: 1, tps: 393.40, reads/s: 5507.90, writes/s: 1573.90
251
[ 180s] threads: 1, tps: 394.00, reads/s: 5514.60, writes/s: 1575.70
252
[ 190s] threads: 1, tps: 392.30, reads/s: 5493.60, writes/s: 1569.40
253
[ 200s] threads: 1, tps: 316.40, reads/s: 4429.18, writes/s: 1265.39
254
[ 210s] threads: 1, tps: 355.90, reads/s: 4982.96, writes/s: 1423.62
255
[ 220s] threads: 1, tps: 392.09, reads/s: 5488.53, writes/s: 1568.38
256
[ 230s] threads: 1, tps: 394.00, reads/s: 5516.13, writes/s: 1576.01
257
[ 240s] threads: 1, tps: 394.00, reads/s: 5516.30, writes/s: 1576.00
258
[ 250s] threads: 1, tps: 392.50, reads/s: 5495.20, writes/s: 1570.00
259
[ 260s] threads: 1, tps: 393.80, reads/s: 5513.50, writes/s: 1575.60
260
[ 270s] threads: 1, tps: 393.80, reads/s: 5513.20, writes/s: 1574.90
261
[ 280s] threads: 1, tps: 343.70, reads/s: 4810.67, writes/s: 1374.69
262
[ 290s] threads: 1, tps: 358.50, reads/s: 5020.10, writes/s: 1434.40
263
[ 300s] threads: 1, tps: 399.70, reads/s: 5595.71, writes/s: 1598.40
264
OLTP test statistics:
270
transactions: 114309 (381.03 per sec.)
271
deadlocks: 0 (0.00 per sec.)
272
read/write requests: 2057562 (6858.51 per sec.)
273
other operations: 228618 (762.06 per sec.)
275
Test execution summary:
276
total time: 300.0014s
277
total number of events: 114309
278
total time taken by event execution: 299.9541s
279
per-request statistics:
283
approx. 95 percentile: 3.14ms
286
events (avg/stddev): 114309.0000/0.00
287
execution time (avg/stddev): 299.9541/0.00