=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE: orisndriz04
RUN ID: 645
RUN DATE: 2010-10-22T18:35:32.176279
SERVER: drizzled
VERSION: staging
REVISION: 1872
COMMENT: 1872: Brian Aker 2010-10-22 [merge] Merge in Brian. key creation
should be i...
======================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 330.547 +3.39% -11.60
330.547 351.169 342.143 7.122
innodb guid-scale 50 157.637 +0.90% -1.44
154.657 161.677 159.075 2.595
innodb key 50 22.183 -0.25% 0.06
22.073 22.183 22.128 0.035
innodb key-scale 50 11.199 -0.02% 0.00
11.110 11.259 11.197 0.049
innodb mixed 50 126.825 -0.30% 0.38
122.667 129.732 126.443 2.338
innodb mixed-commit 50 74.078 +2.43% -1.85
74.078 78.071 75.923 1.555
innodb mixed-commit-scale 50 36.671 +2.97% -1.12
36.616 39.731 37.795 1.214
innodb mixed-scale 50 58.249 +5.27% -3.24
58.249 64.378 61.491 2.112
innodb scan 50 96.088 +0.09% -0.08
95.980 96.478 96.170 0.171
innodb scan-scale 50 48.123 +0.28% -0.14
48.123 48.379 48.260 0.115
innodb update 50 286.580 +4.08% -12.19
286.580 312.674 298.775 9.105
innodb update-commit 50 40.511 -0.11% 0.05
39.674 41.159 40.466 0.472
innodb update-commit-scale 50 19.638 +2.15% -0.43
19.638 20.930 20.070 0.450
innodb update-scale 50 143.967 +0.56% -0.81
138.748 150.596 144.775 3.897
innodb write 50 241.820 +3.45% -8.64
241.820 260.229 250.460 6.494
innodb write-commit 50 109.252 +2.71% -3.04
109.252 116.056 112.295 2.485
innodb write-commit-scale 50 54.711 +2.10% -1.17
54.214 57.860 55.885 1.444
innodb write-scale 50 118.383 +3.34% -4.09
118.383 126.539 122.470 3.143
======================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 330.547 -1.19% 3.90
249.012 414.946 326.648 32.893
innodb guid-scale 50 157.637 -5.66% 8.44
104.424 190.089 149.196 17.606
innodb key 50 22.183 -1.15% 0.25
21.521 22.263 21.932 0.223
innodb key-scale 50 11.199 -1.19% 0.13
10.899 11.259 11.068 0.117
innodb mixed 50 126.825 -6.50% 7.74
96.431 154.212 119.084 12.395
innodb mixed-commit 50 74.078 -1.75% 1.28
62.096 84.328 72.802 4.939
innodb mixed-commit-scale 50 36.671 -2.43% 0.87
31.659 39.731 35.802 2.003
innodb mixed-scale 50 58.249 +0.81% -0.48
48.583 74.377 58.724 5.773
innodb scan 50 96.088 -0.27% 0.26
95.062 96.478 95.826 0.341
innodb scan-scale 50 48.123 +0.00% 0.00
47.725 48.394 48.124 0.165
innodb update 50 286.580 -1.30% 3.68
248.153 312.674 282.899 17.713
innodb update-commit 50 40.511 -0.91% 0.37
38.508 41.630 40.145 0.680
innodb update-commit-scale 50 19.638 +0.78% -0.15
18.059 21.063 19.792 0.667
innodb update-scale 50 143.967 -5.83% 7.94
113.543 150.596 136.031 9.472
innodb write 50 241.820 -4.03% 9.37
180.889 260.229 232.447 20.463
innodb write-commit 50 109.252 -1.00% 1.09
95.021 116.966 108.165 5.321
innodb write-commit-scale 50 54.711 -1.82% 0.98
47.313 58.046 53.734 2.674
innodb write-scale 50 118.383 -3.31% 3.79
93.770 129.628 114.591 9.358
======================================================================================================================
TRENDING OVER ALL runs
Engine Test Conc Time % Diff from Avg Diff Min
Max Avg STD
======================================================================================================================
innodb guid 50 330.547 +2.55% -8.66
249.012 463.571 339.203 24.962
innodb guid-scale 50 157.637 +3.71% -6.07
104.424 371.518 163.711 29.180
innodb key 50 22.183 -3.79% 0.81
19.827 22.709 21.373 0.580
innodb key-scale 50 11.199 -3.56% 0.38
10.120 11.470 10.814 0.258
innodb mixed 50 126.825 -1.19% 1.49
93.099 235.464 125.340 15.397
innodb mixed-commit 50 74.078 -0.90% 0.66
62.096 110.784 73.416 3.848
innodb mixed-commit-scale 50 36.671 -0.48% 0.18
31.659 56.701 36.495 2.004
innodb mixed-scale 50 58.249 +5.21% -3.20
48.583 118.559 61.452 7.629
innodb scan 50 96.088 -2.90% 2.71
90.275 98.490 93.376 1.565
innodb scan-scale 50 48.123 -2.54% 1.19
45.180 51.250 46.932 0.818
innodb update 50 286.580 -13.86% 34.89
197.009 448.990 251.690 48.271
innodb update-commit 50 40.511 +4.45% -1.89
38.508 116.667 42.397 5.334
innodb update-commit-scale 50 19.638 +6.84% -1.44
18.059 57.552 21.081 2.641
innodb update-scale 50 143.967 -14.43% 18.15
92.257 238.508 125.814 34.308
innodb write 50 241.820 +1.36% -3.34
180.889 329.376 245.161 23.063
innodb write-commit 50 109.252 +2.77% -3.11
95.021 181.491 112.365 8.093
innodb write-commit-scale 50 54.711 +2.25% -1.26
47.313 92.328 55.969 4.152
innodb write-scale 50 118.383 +2.61% -3.17
93.760 170.551 121.557 11.718
======================================================================================================================
FULL REVISION COMMENTARY:
1864.3.17: Brian Aker 2010-10-22 Simply the create of an identifier key.
1864.3.16: Brian Aker 2010-10-22 Remove dead createKey method.
1864.3.15: Brian Aker 2010-10-22 Fix placeholder to take identifier.
1864.3.14: Brian Aker 2010-10-22 Remove cases where we do not use an ident...
1864.3.13: Brian Aker 2010-10-22 Usage of find_temporary_table() to identi...
1864.3.12: Brian Aker 2010-10-22 REmove an older use of find_temporary_table
1864.3.11: Brian Aker 2010-10-22 Remove dead method
1864.3.10: Brian Aker 2010-10-21 Restore so that local is not added to sch...
1864.3.9: Brian Aker 2010-10-21 Remove a couple of memset and now just bui...
1864.3.8: Brian Aker 2010-10-21 Schema identifier is now testing actual path.
1864.3.7: Brian Aker 2010-10-21 Remove copy (we didn't need to be doing it).
1864.3.6: Brian Aker 2010-10-21 Merge in modification to how we encode out...
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
