================================================================================================= DRIZZLESLAP REPORT ======================================================================================= MACHINE: orisndriz04 RUN ID: 62 RUN DATE: 2010-05-21T23:45:37.415598 SERVER: drizzled VERSION: build REVISION: 1562 COMMENT: 1562: Brian Aker 2010-05-21 [merge] Merge Brian, includes changes to add Inn...
====================================================================================================================== TRENDING OVER LAST 5 runs Engine Test Conc Time % Diff from Avg Diff Norm? Min Max Avg STD ====================================================================================================================== blackhole guid-scale_bh 50 11.682 +1.09% -0.13 within norms 11.557 11.980 11.811 0.163 blackhole guid_bh 50 23.388 +0.97% -0.23 within norms 23.124 23.871 23.617 0.306 blackhole write-scale_bh 50 7.255 -6.10% 0.42 within norms 6.257 7.255 6.838 0.461 blackhole write_bh 50 14.457 -6.13% 0.84 within norms 12.442 14.457 13.622 0.911 innodb guid 50 416.254 +5.89% -26.06 within norms 394.289 506.426 442.316 45.951 innodb guid-scale 50 173.800 +6.73% -12.54 within norms 160.845 215.428 186.338 21.819 innodb key 50 21.069 -2.03% 0.42 within norms 19.903 21.185 20.649 0.584 innodb key-scale 50 10.624 -1.41% 0.15 within norms 10.195 10.705 10.476 0.217 innodb mixed 50 112.456 +4.20% -4.93 within norms 101.229 139.208 117.390 12.762 innodb mixed-commit 50 75.704 -1.13% 0.84 within norms 71.525 76.744 74.862 2.011 innodb mixed-commit-scale 50 37.479 -0.82% 0.30 within norms 35.720 38.700 37.174 1.059 innodb mixed-scale 50 55.666 +6.47% -3.85 within norms 49.118 71.911 59.516 8.483 innodb scan 50 90.280 +0.50% -0.45 outside norms 90.280 91.481 90.729 0.436 innodb scan-scale 50 45.286 +0.78% -0.35 outside norms 45.249 45.931 45.641 0.306 innodb update 50 339.995 +7.69% -28.31 within norms 321.975 439.613 368.307 47.188 innodb update-commit 50 41.445 +1.84% -0.78 within norms 41.441 44.150 42.222 1.038 innodb update-commit-scale 50 20.384 +1.42% -0.29 within norms 19.564 22.299 20.678 0.913 innodb update-scale 50 171.009 +5.71% -10.35 within norms 157.750 210.197 181.356 21.622 innodb write 50 219.651 +3.58% -8.16 within norms 194.311 265.856 227.811 25.439 innodb write-commit 50 127.189 -4.59% 5.59 outside norms 118.897 127.189 121.603 3.052 innodb write-commit-scale 50 62.272 -2.34% 1.42 outside norms 59.281 62.272 60.850 1.072 innodb write-scale 50 109.941 +1.44% -1.60 within norms 94.873 132.171 111.545 13.276 ====================================================================================================================== TRENDING OVER LAST 20 runs Engine Test Conc Time % Diff from Avg Diff Norm? Min Max Avg STD ====================================================================================================================== blackhole guid-scale_bh 50 11.682 +0.53% -0.06 within norms 11.324 12.007 11.744 0.216 blackhole guid_bh 50 23.388 +0.20% -0.05 within norms 22.492 24.089 23.434 0.439 blackhole write-scale_bh 50 7.255 -12.45% 0.80 outside norms 6.248 7.255 6.452 0.324 blackhole write_bh 50 14.457 -12.63% 1.62 outside norms 12.372 14.457 12.835 0.647 innodb guid 50 416.254 +17.05% -85.53 outside norms 394.289 538.580 501.784 42.052 innodb guid-scale 50 173.800 +19.81% -42.93 outside norms 160.845 240.936 216.726 21.653 innodb key 50 21.069 -4.64% 0.93 outside norms 19.842 21.185 20.135 0.421 innodb key-scale 50 10.624 -3.30% 0.34 outside norms 10.143 10.705 10.285 0.162 innodb mixed 50 112.456 +20.73% -29.41 outside norms 101.229 161.260 141.866 16.220 innodb mixed-commit 50 75.704 -0.41% 0.31 within norms 71.525 78.200 75.395 1.669 innodb mixed-commit-scale 50 37.479 +0.03% -0.01 within norms 35.720 39.001 37.491 0.844 innodb mixed-scale 50 55.666 +21.36% -15.12 outside norms 49.118 80.412 70.785 8.470 innodb scan 50 90.280 +0.73% -0.66 outside norms 90.280 91.613 90.944 0.338 innodb scan-scale 50 45.286 +1.16% -0.53 outside norms 45.249 46.149 45.818 0.227 innodb update 50 339.995 +19.18% -80.70 outside norms 321.975 452.749 420.700 38.921 innodb update-commit 50 41.445 +4.01% -1.73 outside norms 41.441 47.302 43.178 1.258 innodb update-commit-scale 50 20.384 +4.56% -0.97 outside norms 19.564 22.354 21.358 0.730 innodb update-scale 50 171.009 +18.32% -38.35 outside norms 157.750 227.938 209.356 19.822 innodb write 50 219.651 +17.89% -47.87 outside norms 194.311 294.272 267.520 27.133 innodb write-commit 50 127.189 -2.01% 2.51 within norms 118.897 129.352 124.680 2.743 innodb write-commit-scale 50 62.272 +0.15% -0.09 within norms 59.281 64.257 62.363 1.372 innodb write-scale 50 109.941 +17.21% -22.85 outside norms 94.873 148.002 132.789 14.462 ====================================================================================================================== TRENDING OVER ALL runs Engine Test Conc Time % Diff from Avg Diff Norm? Min Max Avg STD ====================================================================================================================== blackhole guid-scale_bh 50 11.682 0.190 -0.020 within norms 11.271 12.063 11.704 0.221 blackhole guid_bh 50 23.388 -0.190 0.040 within norms 22.492 24.089 23.343 0.439 blackhole write-scale_bh 50 7.255 -13.720 0.880 outside norms 6.169 7.255 6.380 0.244 blackhole write_bh 50 14.457 -14.130 1.790 outside norms 12.305 14.457 12.667 0.495 innodb guid 50 416.254 20.720 -108.800 outside norms 394.289 569.692 525.059 38.165 innodb guid-scale 50 173.800 24.220 -55.560 outside norms 160.845 251.259 229.357 20.020 innodb key 50 21.069 -5.120 1.030 outside norms 19.827 21.185 20.043 0.316 innodb key-scale 50 10.624 -3.630 0.370 outside norms 10.120 10.705 10.252 0.124 innodb mixed 50 112.456 27.000 -41.600 outside norms 101.229 177.319 154.057 17.179 innodb mixed-commit 50 75.704 1.880 -1.450 within norms 71.525 82.281 77.152 2.318 innodb mixed-commit-scale 50 37.479 2.550 -0.980 within norms 35.720 40.995 38.460 1.251 innodb mixed-scale 50 55.666 26.590 -20.160 outside norms 49.118 88.360 75.826 8.221 innodb scan 50 90.280 0.750 -0.680 outside norms 90.280 91.950 90.959 0.343 innodb scan-scale 50 45.286 1.210 -0.560 outside norms 45.249 46.149 45.843 0.213 innodb update 50 339.995 22.650 -99.580 outside norms 321.975 480.264 439.573 33.711 innodb update-commit 50 41.445 4.830 -2.100 outside norms 41.441 47.302 43.548 1.030 innodb update-commit-scale 50 20.384 6.140 -1.330 outside norms 19.564 22.859 21.718 0.712 innodb update-scale 50 171.009 21.930 -48.030 outside norms 157.750 238.508 219.040 17.208 innodb write 50 219.651 23.040 -65.750 outside norms 194.311 324.769 285.398 26.780 innodb write-commit 50 127.189 0.830 -1.060 within norms 118.897 135.919 128.247 4.295 innodb write-commit-scale 50 62.272 2.700 -1.730 within norms 59.281 68.306 63.998 2.113 innodb write-scale 50 109.941 22.560 -32.020 outside norms 94.873 162.418 141.962 14.101 ====================================================================================================================== FULL REVISION COMMENTARY: 1556.1.3: Brian Aker 2010-05-21 First pass on a table function to see the ... 1556.1.2: Brian Aker 2010-05-21 Creates a "cleanup" of Innodb's temp files... _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : drizzle-benchmark@lists.launchpad.net Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp