=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE: orisndriz04
RUN ID: 1079
RUN DATE: 2011-01-03T15:32:06.319637
SERVER: drizzled
VERSION: staging
REVISION: 2049
COMMENT: 2049: Brian Aker 2011-01-03 [merge] Refactor drop schema so that it
can be u...
======================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 252.179 -6.15% 14.60
228.270 252.179 237.575 8.328
innodb guid-scale 50 113.954 -5.93% 6.38
101.818 113.954 107.575 4.535
innodb key 50 21.922 +14.20% -3.63
21.899 40.122 25.550 7.286
innodb key-scale 50 11.088 +13.52% -1.73
11.044 19.828 12.822 3.503
innodb mixed 50 105.468 -10.95% 10.41
85.141 105.468 95.057 6.503
innodb mixed-commit 50 63.566 -1.67% 1.04
60.568 65.500 62.522 1.784
innodb mixed-commit-scale 50 30.181 -1.36% 0.40
28.604 31.050 29.776 0.893
innodb mixed-scale 50 46.933 -1.54% 0.71
42.666 48.196 46.221 1.909
innodb scan 50 96.253 +3.82% -3.83
95.794 116.260 100.079 8.093
innodb scan-scale 50 48.168 +4.20% -2.11
48.073 58.600 50.281 4.160
innodb update 50 245.231 -3.45% 8.19
227.160 245.231 237.043 5.899
innodb update-scale 50 120.957 -4.54% 5.25
110.151 120.957 115.703 3.716
innodb write 50 209.669 -7.36% 14.38
183.131 209.669 195.293 9.181
innodb write-commit 50 97.880 -2.61% 2.49
93.817 97.880 95.388 1.540
innodb write-commit-scale 50 48.051 -2.10% 0.99
46.391 48.051 47.063 0.560
innodb write-scale 50 99.956 -5.52% 5.23
91.187 99.956 94.730 3.174
======================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 252.179 -5.06% 12.13
215.107 268.311 240.044 14.662
innodb guid-scale 50 113.954 -5.44% 5.88
96.639 121.868 108.073 6.759
innodb key 50 21.922 +6.21% -1.45
21.848 40.122 23.374 3.865
innodb key-scale 50 11.088 +5.79% -0.68
10.993 19.828 11.769 1.860
innodb mixed 50 105.468 -9.05% 8.75
85.141 107.845 96.715 6.943
innodb mixed-commit 50 63.566 -2.11% 1.31
57.403 67.807 62.252 2.922
innodb mixed-commit-scale 50 30.181 -1.66% 0.49
27.016 32.551 29.689 1.525
innodb mixed-scale 50 46.933 -0.94% 0.44
40.196 52.631 46.497 3.234
innodb scan 50 96.253 +0.74% -0.72
95.610 116.260 96.968 4.431
innodb scan-scale 50 48.168 +1.12% -0.55
48.071 58.600 48.714 2.270
innodb update 50 245.231 -1.93% 4.64
212.330 269.308 240.591 15.234
innodb update-scale 50 120.957 -2.90% 3.41
98.865 132.389 117.549 8.555
innodb write 50 209.669 -6.22% 12.28
169.053 224.658 197.388 15.503
innodb write-commit 50 97.880 -2.00% 1.92
89.108 104.213 95.957 4.000
innodb write-commit-scale 50 48.051 -0.57% 0.27
44.254 52.188 47.778 2.088
innodb write-scale 50 99.956 -4.60% 4.40
80.718 108.676 95.556 7.234
======================================================================================================================
TRENDING OVER ALL runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 252.179 +20.92% -66.70
215.107 463.571 318.880 43.476
innodb guid-scale 50 113.954 +24.90% -37.77
96.639 371.518 151.727 32.354
innodb key 50 21.922 -0.38% 0.08
19.827 40.122 21.839 1.168
innodb key-scale 50 11.088 -0.47% 0.05
10.120 19.828 11.036 0.552
innodb mixed 50 105.468 +11.69% -13.96
85.141 235.464 119.431 17.158
innodb mixed-commit 50 63.566 +11.00% -7.85
57.403 110.784 71.420 5.279
innodb mixed-commit-scale 50 30.181 +14.47% -5.11
27.016 56.701 35.287 2.990
innodb mixed-scale 50 46.933 +19.59% -11.43
40.196 118.559 58.365 8.742
innodb scan 50 96.253 -2.05% 1.94
90.275 116.260 94.317 2.131
innodb scan-scale 50 48.168 -1.64% 0.78
45.180 58.600 47.390 1.077
innodb update 50 245.231 +3.77% -9.62
197.009 448.990 254.852 42.948
innodb update-scale 50 120.957 +3.99% -5.03
92.257 238.508 125.985 29.469
innodb write 50 209.669 +11.25% -26.58
169.021 329.376 236.251 26.728
innodb write-commit 50 97.880 +10.42% -11.39
89.108 181.491 109.267 9.197
innodb write-commit-scale 50 48.051 +11.65% -6.34
44.254 92.328 54.390 4.602
innodb write-scale 50 99.956 +14.36% -16.77
80.718 170.551 116.722 13.962
======================================================================================================================
FULL REVISION COMMENTARY:
2041.3.12: Brian Aker 2011-01-02 Move to private.
2041.3.11: Brian Aker 2011-01-02 Only change schemas if we DROP the schema.
2041.3.10: Brian Aker 2011-01-02 Put more of drop schema behind interface.
2041.3.9: Brian Aker 2010-12-31 Remove std::cerr messages
2041.3.8: Brian Aker 2010-12-31 Fixed issue with drop schema when working ...
2041.3.7: Brian Aker 2010-12-31 Cleanup for error, there is still a failur...
2041.3.6: Brian Aker 2010-12-31 Cleanup of drop table.
2041.3.5: Brian Aker 2010-12-30 Make it so that tables are sent not as raw...
2041.3.4: Brian Aker 2010-12-30 remove goto
2041.3.3: Brian Aker 2010-12-30 Just grab the identifiers, and run with them.
2041.3.2: Brian Aker 2010-12-30 Improve on drop schema temp tables.
2041.3.1: Brian Aker 2010-12-30 Move temp table schema drop inside of API.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp