1
sysbench 0.5: multi-threaded system evaluation benchmark
3
Running the test with following options:
4
Number of threads: 1024
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
11
WARNING: timer was never started
14
[ 10s] threads: 1024, tps: 3981.55, reads/s: 56675.99, writes/s: 0.00 response time: 855.58ms (99%)
15
[ 20s] threads: 1024, tps: 4015.60, reads/s: 56234.17, writes/s: 0.00 response time: 880.78ms (99%)
16
[ 30s] threads: 1024, tps: 4005.51, reads/s: 56045.80, writes/s: 0.00 response time: 872.39ms (99%)
17
[ 40s] threads: 1024, tps: 4201.49, reads/s: 58823.53, writes/s: 0.00 response time: 911.91ms (99%)
18
[ 50s] threads: 1024, tps: 4233.00, reads/s: 59279.44, writes/s: 0.00 response time: 891.93ms (99%)
19
[ 60s] threads: 1024, tps: 4203.90, reads/s: 58829.46, writes/s: 0.00 response time: 922.89ms (99%)
20
[ 70s] threads: 1024, tps: 4168.10, reads/s: 58322.75, writes/s: 0.00 response time: 845.39ms (99%)
21
[ 80s] threads: 1024, tps: 4168.60, reads/s: 58382.36, writes/s: 0.00 response time: 870.04ms (99%)
22
[ 90s] threads: 1024, tps: 4157.90, reads/s: 58222.48, writes/s: 0.00 response time: 885.54ms (99%)
23
[ 100s] threads: 1024, tps: 4172.10, reads/s: 58406.01, writes/s: 0.00 response time: 878.41ms (99%)
24
[ 110s] threads: 1024, tps: 4173.30, reads/s: 58410.36, writes/s: 0.00 response time: 848.94ms (99%)
25
[ 120s] threads: 1024, tps: 4133.90, reads/s: 57879.04, writes/s: 0.00 response time: 825.39ms (99%)
26
[ 130s] threads: 1024, tps: 4167.40, reads/s: 58339.21, writes/s: 0.00 response time: 838.59ms (99%)
27
[ 140s] threads: 1024, tps: 4152.71, reads/s: 58160.46, writes/s: 0.00 response time: 875.53ms (99%)
28
[ 150s] threads: 1024, tps: 4154.58, reads/s: 58138.78, writes/s: 0.00 response time: 848.18ms (99%)
29
[ 160s] threads: 1024, tps: 4149.90, reads/s: 58125.74, writes/s: 0.00 response time: 858.40ms (99%)
30
[ 170s] threads: 1024, tps: 4157.19, reads/s: 58212.15, writes/s: 0.00 response time: 895.67ms (99%)
31
[ 180s] threads: 1024, tps: 4157.72, reads/s: 58163.78, writes/s: 0.00 response time: 839.34ms (99%)
32
[ 190s] threads: 1024, tps: 4188.49, reads/s: 58663.94, writes/s: 0.00 response time: 857.12ms (99%)
33
[ 200s] threads: 1024, tps: 4175.58, reads/s: 58420.14, writes/s: 0.00 response time: 901.05ms (99%)
34
[ 210s] threads: 1024, tps: 4151.63, reads/s: 58175.31, writes/s: 0.00 response time: 926.21ms (99%)
35
[ 220s] threads: 1024, tps: 4178.70, reads/s: 58458.22, writes/s: 0.00 response time: 901.05ms (99%)
36
[ 230s] threads: 1024, tps: 4163.70, reads/s: 58348.13, writes/s: 0.00 response time: 893.53ms (99%)
37
[ 240s] threads: 1024, tps: 4171.30, reads/s: 58362.46, writes/s: 0.00 response time: 943.28ms (99%)
38
[ 250s] threads: 1024, tps: 4143.20, reads/s: 58018.93, writes/s: 0.00 response time: 873.96ms (99%)
39
[ 260s] threads: 1024, tps: 4159.20, reads/s: 58231.46, writes/s: 0.00 response time: 788.44ms (99%)
40
[ 270s] threads: 1024, tps: 4142.26, reads/s: 57998.86, writes/s: 0.00 response time: 804.17ms (99%)
41
[ 280s] threads: 1024, tps: 4140.14, reads/s: 57941.84, writes/s: 0.00 response time: 889.79ms (99%)
42
[ 290s] threads: 1024, tps: 4096.10, reads/s: 57354.44, writes/s: 0.00 response time: 819.24ms (99%)
43
[ 300s] threads: 1024, tps: 4088.61, reads/s: 57220.93, writes/s: 0.00 response time: 846.66ms (99%)
44
[ 310s] threads: 1024, tps: 4076.49, reads/s: 57074.64, writes/s: 0.00 response time: 793.41ms (99%)
45
[ 320s] threads: 1024, tps: 4078.99, reads/s: 57125.25, writes/s: 0.00 response time: 889.26ms (99%)
46
[ 330s] threads: 1024, tps: 4076.32, reads/s: 57012.76, writes/s: 0.00 response time: 809.24ms (99%)
47
[ 340s] threads: 1024, tps: 4117.19, reads/s: 57678.45, writes/s: 0.00 response time: 888.20ms (99%)
48
[ 350s] threads: 1024, tps: 4117.41, reads/s: 57671.52, writes/s: 0.00 response time: 882.10ms (99%)
49
[ 360s] threads: 1024, tps: 4090.00, reads/s: 57210.51, writes/s: 0.00 response time: 872.91ms (99%)
50
[ 370s] threads: 1024, tps: 4086.29, reads/s: 57237.89, writes/s: 0.00 response time: 783.50ms (99%)
51
[ 380s] threads: 1024, tps: 4114.47, reads/s: 57567.96, writes/s: 0.00 response time: 819.24ms (99%)
52
[ 390s] threads: 1024, tps: 4091.03, reads/s: 57328.01, writes/s: 0.00 response time: 868.22ms (99%)
53
[ 400s] threads: 1024, tps: 4116.80, reads/s: 57616.33, writes/s: 0.00 response time: 881.58ms (99%)
54
[ 410s] threads: 1024, tps: 4089.42, reads/s: 57270.27, writes/s: 0.00 response time: 830.59ms (99%)
55
[ 420s] threads: 1024, tps: 4090.78, reads/s: 57233.26, writes/s: 0.00 response time: 891.13ms (99%)
56
[ 430s] threads: 1024, tps: 4118.10, reads/s: 57710.46, writes/s: 0.00 response time: 846.66ms (99%)
57
[ 440s] threads: 1024, tps: 4124.10, reads/s: 57718.46, writes/s: 0.00 response time: 815.57ms (99%)
58
[ 450s] threads: 1024, tps: 4116.38, reads/s: 57602.17, writes/s: 0.00 response time: 883.69ms (99%)
59
[ 460s] threads: 1024, tps: 4113.21, reads/s: 57617.96, writes/s: 0.00 response time: 828.11ms (99%)
60
[ 470s] threads: 1024, tps: 4112.90, reads/s: 57561.35, writes/s: 0.00 response time: 855.83ms (99%)
61
[ 480s] threads: 1024, tps: 4114.29, reads/s: 57572.45, writes/s: 0.00 response time: 859.43ms (99%)
62
[ 490s] threads: 1024, tps: 4107.71, reads/s: 57555.20, writes/s: 0.00 response time: 892.46ms (99%)
63
[ 500s] threads: 1024, tps: 4108.71, reads/s: 57494.08, writes/s: 0.00 response time: 856.35ms (99%)
64
[ 510s] threads: 1024, tps: 4114.08, reads/s: 57614.31, writes/s: 0.00 response time: 851.49ms (99%)
65
[ 520s] threads: 1024, tps: 4131.73, reads/s: 57807.22, writes/s: 0.00 response time: 847.17ms (99%)
66
[ 530s] threads: 1024, tps: 4106.29, reads/s: 57539.28, writes/s: 0.00 response time: 850.22ms (99%)
67
[ 540s] threads: 1024, tps: 4104.39, reads/s: 57413.98, writes/s: 0.00 response time: 838.84ms (99%)
68
[ 550s] threads: 1024, tps: 4080.11, reads/s: 57141.38, writes/s: 0.00 response time: 831.34ms (99%)
69
[ 560s] threads: 1024, tps: 4138.18, reads/s: 57915.29, writes/s: 0.00 response time: 866.40ms (99%)
70
[ 570s] threads: 1024, tps: 4120.41, reads/s: 57686.39, writes/s: 0.00 response time: 863.04ms (99%)
71
[ 580s] threads: 1024, tps: 4124.41, reads/s: 57747.53, writes/s: 0.00 response time: 875.26ms (99%)
72
[ 590s] threads: 1024, tps: 4122.89, reads/s: 57722.38, writes/s: 0.00 response time: 866.40ms (99%)
73
[ 600s] threads: 1024, tps: 4083.80, reads/s: 57186.35, writes/s: 0.00 response time: 838.59ms (99%)
74
[ 610s] threads: 1024, tps: 4111.78, reads/s: 57562.27, writes/s: 0.00 response time: 845.14ms (99%)
75
[ 620s] threads: 1024, tps: 4092.92, reads/s: 57305.42, writes/s: 0.00 response time: 834.08ms (99%)
76
[ 630s] threads: 1024, tps: 4105.80, reads/s: 57464.87, writes/s: 0.00 response time: 822.43ms (99%)
77
[ 640s] threads: 1024, tps: 4115.50, reads/s: 57633.65, writes/s: 0.00 response time: 832.84ms (99%)
78
[ 650s] threads: 1024, tps: 4097.50, reads/s: 57336.89, writes/s: 0.00 response time: 822.18ms (99%)
79
[ 660s] threads: 1024, tps: 4110.90, reads/s: 57581.57, writes/s: 0.00 response time: 813.86ms (99%)
80
[ 670s] threads: 1024, tps: 4085.80, reads/s: 57192.95, writes/s: 0.00 response time: 847.67ms (99%)
81
[ 680s] threads: 1024, tps: 4078.91, reads/s: 57129.23, writes/s: 0.00 response time: 851.74ms (99%)
82
[ 690s] threads: 1024, tps: 4103.59, reads/s: 57404.51, writes/s: 0.00 response time: 849.45ms (99%)
83
[ 700s] threads: 1024, tps: 4077.20, reads/s: 57092.97, writes/s: 0.00 response time: 812.88ms (99%)
84
[ 710s] threads: 1024, tps: 4098.09, reads/s: 57371.51, writes/s: 0.00 response time: 812.64ms (99%)
85
[ 720s] threads: 1024, tps: 4107.01, reads/s: 57504.78, writes/s: 0.00 response time: 873.96ms (99%)
86
[ 730s] threads: 1024, tps: 4090.00, reads/s: 57266.34, writes/s: 0.00 response time: 866.66ms (99%)
87
[ 740s] threads: 1024, tps: 4127.81, reads/s: 57797.42, writes/s: 0.00 response time: 887.40ms (99%)
88
[ 750s] threads: 1024, tps: 4096.99, reads/s: 57330.52, writes/s: 0.00 response time: 845.14ms (99%)
89
[ 760s] threads: 1024, tps: 4091.40, reads/s: 57291.08, writes/s: 0.00 response time: 828.61ms (99%)
90
[ 770s] threads: 1024, tps: 4112.91, reads/s: 57582.78, writes/s: 0.00 response time: 894.60ms (99%)
91
[ 780s] threads: 1024, tps: 4098.79, reads/s: 57380.92, writes/s: 0.00 response time: 860.97ms (99%)
92
[ 790s] threads: 1024, tps: 4102.60, reads/s: 57432.61, writes/s: 0.00 response time: 830.10ms (99%)
93
[ 800s] threads: 1024, tps: 4105.00, reads/s: 57482.16, writes/s: 0.00 response time: 797.94ms (99%)
94
[ 810s] threads: 1024, tps: 4131.20, reads/s: 57844.87, writes/s: 0.00 response time: 878.68ms (99%)
95
[ 820s] threads: 1024, tps: 4084.70, reads/s: 57170.53, writes/s: 0.00 response time: 885.28ms (99%)
96
[ 830s] threads: 1024, tps: 4108.80, reads/s: 57535.20, writes/s: 0.00 response time: 822.68ms (99%)
97
[ 840s] threads: 1024, tps: 4092.50, reads/s: 57298.06, writes/s: 0.00 response time: 855.83ms (99%)
98
[ 850s] threads: 1024, tps: 4081.69, reads/s: 57153.07, writes/s: 0.00 response time: 886.87ms (99%)
99
[ 860s] threads: 1024, tps: 4106.80, reads/s: 57454.85, writes/s: 0.00 response time: 813.13ms (99%)
100
[ 870s] threads: 1024, tps: 4069.58, reads/s: 56989.01, writes/s: 0.00 response time: 869.00ms (99%)
101
[ 880s] threads: 1024, tps: 4099.73, reads/s: 57395.36, writes/s: 0.00 response time: 835.83ms (99%)
102
[ 890s] threads: 1024, tps: 4100.20, reads/s: 57399.44, writes/s: 0.00 response time: 831.84ms (99%)
103
[ 900s] threads: 1024, tps: 4088.90, reads/s: 57286.02, writes/s: 0.00 response time: 816.79ms (99%)
104
OLTP test statistics:
110
transactions: 3706173 (4116.44 per sec.)
111
deadlocks: 0 (0.00 per sec.)
112
read/write requests: 51886422 (57630.21 per sec.)
113
other operations: 7412346 (8232.89 per sec.)
116
total time: 900.3337s
117
total number of events: 3706173
118
total time taken by event execution: 921746.2402s
123
approx. 99 percentile: 858.66ms
126
events (avg/stddev): 3619.3096/85.03
127
execution time (avg/stddev): 900.1428/0.09