производительность первого сервера

OLTP test statistics:
queries performed:
read: 719180
write: 256850
other: 102740
total: 1078770
transactions: 51370 (856.03 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 976030 (16264.61 per sec.)
other operations: 102740 (1712.06 per sec.)

Test execution summary:
total time: 60.0094s
total number of events: 51370
total time taken by event execution: 359.7804
per-request statistics:
min: 1.73ms
avg: 7.00ms
max: 2173.50ms
approx. 95 percentile: 14.09ms

Threads fairness:
events (avg/stddev): 8561.6667/39.81
execution time (avg/stddev): 59.9634/0.00

OLTP test statistics:
queries performed:
read: 707168
write: 252560
other: 101024
total: 1060752
transactions: 50512 (841.82 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 959728 (15994.50 per sec.)
other operations: 101024 (1683.63 per sec.)

Test execution summary:
total time: 60.0036s
total number of events: 50512
total time taken by event execution: 359.7955
per-request statistics:
min: 1.75ms
avg: 7.12ms
max: 1219.00ms
approx. 95 percentile: 14.96ms

Threads fairness:
events (avg/stddev): 8418.6667/59.86
execution time (avg/stddev): 59.9659/0.00

OLTP test statistics:
queries performed:
read: 719866
write: 257095
other: 102838
total: 1079799
transactions: 51419 (842.27 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 976961 (16003.08 per sec.)
other operations: 102838 (1684.53 per sec.)

Test execution summary:
total time: 61.0483s
total number of events: 51419
total time taken by event execution: 365.3702
per-request statistics:
min: 1.49ms
avg: 7.11ms
max: 1385.05ms
approx. 95 percentile: 14.85ms

Threads fairness:
events (avg/stddev): 8569.8333/101.29
execution time (avg/stddev): 60.8950/0.08

 

Производительность второго сервера

OLTP test statistics:
queries performed:
read: 700434
write: 250155
other: 100062
total: 1050651
transactions: 50031 (832.48 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 950589 (15817.13 per sec.)
other operations: 100062 (1664.96 per sec.)

Test execution summary:
total time: 60.0987s
total number of events: 50031
total time taken by event execution: 360.4194
per-request statistics:
min: 1.14ms
avg: 7.20ms
max: 2036.16ms
approx. 95 percentile: 6.87ms

Threads fairness:
events (avg/stddev): 8338.5000/371.76
execution time (avg/stddev): 60.0699/0.00

 

OLTP test statistics:
queries performed:
read: 695772
write: 248490
other: 99396
total: 1043658
transactions: 49698 (826.02 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 944262 (15694.38 per sec.)
other operations: 99396 (1652.04 per sec.)

Test execution summary:
total time: 60.1656s
total number of events: 49698
total time taken by event execution: 360.5134
per-request statistics:
min: 1.19ms
avg: 7.25ms
max: 1319.26ms
approx. 95 percentile: 5.07ms

Threads fairness:
events (avg/stddev): 8283.0000/368.65
execution time (avg/stddev): 60.0856/0.03

 

OLTP test statistics:
queries performed:
read: 931266
write: 332595
other: 133038
total: 1396899
transactions: 66519 (1087.21 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 1263861 (20657.01 per sec.)
other operations: 133038 (2174.42 per sec.)

Test execution summary:
total time: 61.1831s
total number of events: 66519
total time taken by event execution: 366.8684
per-request statistics:
min: 1.19ms
avg: 5.52ms
max: 1678.80ms
approx. 95 percentile: 4.54ms

Threads fairness:
events (avg/stddev): 11086.5000/411.55
execution time (avg/stddev): 61.1447/0.00

 

 

Производительность кластера ( запуск на одном из серверов )

OLTP test statistics:
queries performed:
read: 488110
write: 174325
other: 69730
total: 732165
transactions: 34865 (581.06 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 662435 (11040.17 per sec.)
other operations: 69730 (1162.12 per sec.)

Test execution summary:
total time: 60.0023s
total number of events: 34865
total time taken by event execution: 359.8805
per-request statistics:
min: 1.49ms
avg: 10.32ms
max: 2036.03ms
approx. 95 percentile: 13.14ms

Threads fairness:
events (avg/stddev): 5810.8333/314.74
execution time (avg/stddev): 59.9801/0.00

 

 

OLTP test statistics:
queries performed:
read: 443324
write: 158330
other: 63332
total: 664986
transactions: 31666 (527.73 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 601654 (10026.89 per sec.)
other operations: 63332 (1055.46 per sec.)

Test execution summary:
total time: 60.0041s
total number of events: 31666
total time taken by event execution: 359.8562
per-request statistics:
min: 1.69ms
avg: 11.36ms
max: 963.49ms
approx. 95 percentile: 16.52ms

Threads fairness:
events (avg/stddev): 5277.6667/35.56
execution time (avg/stddev): 59.9760/0.00

 

OLTP test statistics:
queries performed:
read: 491106
write: 175395
other: 70158
total: 736659
transactions: 35079 (584.29 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 666501 (11101.49 per sec.)
other operations: 70158 (1168.58 per sec.)

Test execution summary:
total time: 60.0371s
total number of events: 35079
total time taken by event execution: 360.0896
per-request statistics:
min: 1.45ms
avg: 10.27ms
max: 2413.69ms
approx. 95 percentile: 40.58ms

Threads fairness:
events (avg/stddev): 5846.5000/200.95
execution time (avg/stddev): 60.0149/0.00

 

Производительность кластера ( одновременный запуск теста )

Прогон 1

OLTP test statistics:
queries performed:
read: 172718
write: 61681
other: 24672
total: 259071
transactions: 12289 (204.81 per sec.)
deadlocks: 48 (0.80 per sec.)
read/write requests: 234399 (3906.52 per sec.)
other operations: 24672 (411.19 per sec.)

Test execution summary:
total time: 60.0020s
total number of events: 12289
total time taken by event execution: 359.9584
per-request statistics:
min: 1.57ms
avg: 29.29ms
max: 1473.89ms
approx. 95 percentile: 180.14ms

Threads fairness:
events (avg/stddev): 2048.1667/13.51
execution time (avg/stddev): 59.9931/0.00

 

 

OLTP test statistics:
queries performed:
read: 327810
write: 117068
other: 46824
total: 491702
transactions: 23390 (389.82 per sec.)
deadlocks: 25 (0.42 per sec.)
read/write requests: 444878 (7414.29 per sec.)
other operations: 46824 (780.36 per sec.)

Test execution summary:
total time: 60.0028s
total number of events: 23390
total time taken by event execution: 359.9052
per-request statistics:
min: 1.92ms
avg: 15.39ms
max: 1027.32ms
approx. 95 percentile: 60.16ms

Threads fairness:
events (avg/stddev): 3898.3333/42.27
execution time (avg/stddev): 59.9842/0.00

 

Прогон 2

OLTP test statistics:
queries performed:
read: 281792
write: 100631
other: 40252
total: 422675
transactions: 20107 (335.11 per sec.)
deadlocks: 21 (0.35 per sec.)
read/write requests: 382423 (6373.57 per sec.)
other operations: 40252 (670.85 per sec.)

Test execution summary:
total time: 60.0013s

total number of events: 20107
total time taken by event execution: 359.9158
per-request statistics:
min: 1.97ms
avg: 17.90ms
max: 1484.35ms
approx. 95 percentile: 79.42ms

 

Threads fairness:
events (avg/stddev): 3351.1667/16.96
execution time (avg/stddev): 59.9860/0.00

 

OLTP test statistics:
queries performed:
read: 169148
write: 60408
other: 24163
total: 253719
transactions: 12052 (200.53 per sec.)
deadlocks: 30 (0.50 per sec.)
read/write requests: 229556 (3819.60 per sec.)
other operations: 24163 (402.05 per sec.)

Test execution summary:
total time: 60.0995s
total number of events: 12052
total time taken by event execution: 360.2361
per-request statistics:
min: 1.62ms
avg: 29.89ms
max: 1495.48ms
approx. 95 percentile: 181.33ms

Threads fairness:
events (avg/stddev): 2008.6667/34.12
execution time (avg/stddev): 60.0393/0.02