~percona-dev/percona-benchmark-result/mysql-versions

« back to all changes in this revision

Viewing changes to res7/sysbench.1024.res

  • Committer: root
  • Date: 2011-10-11 00:41:56 UTC
  • Revision ID: root@cisco.office.percona.com-20111011004156-80h3rle9t7ywnb92
results

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
sysbench 0.5:  multi-threaded system evaluation benchmark
 
2
 
 
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.
 
7
 
 
8
Random number generator seed is 0 and will be ignored
 
9
 
 
10
 
 
11
WARNING: timer was never started
 
12
Threads started!
 
13
 
 
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:
 
105
    queries performed:
 
106
        read:                            51886422
 
107
        write:                           0
 
108
        other:                           7412346
 
109
        total:                           59298768
 
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.)
 
114
 
 
115
General statistics:
 
116
    total time:                          900.3337s
 
117
    total number of events:              3706173
 
118
    total time taken by event execution: 921746.2402s
 
119
    response time:
 
120
         min:                                  1.55ms
 
121
         avg:                                248.71ms
 
122
         max:                               1194.41ms
 
123
         approx.  99 percentile:             858.66ms
 
124
 
 
125
Threads fairness:
 
126
    events (avg/stddev):           3619.3096/85.03
 
127
    execution time (avg/stddev):   900.1428/0.09
 
128