=================================================================================================
DRIZZLESLAP REPORT
=======================================================================================
MACHINE: orisndriz04
RUN ID: 54
RUN DATE: 2010-05-20T02:09:47.452086
SERVER: drizzled
VERSION: build
REVISION: 1552
COMMENT: 1552: Brian Aker 2010-05-19 It is somewhat amazing that EXPLAIN works
at all...
======================================================================================================================
TRENDING OVER LAST 5 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 11.991 -2.82% 0.33 outside
norms 11.450 11.991 11.662 0.206
blackhole guid_bh 50 24.089 -3.36% 0.78 outside
norms 22.890 24.089 23.305 0.445
blackhole write-scale_bh 50 6.276 +0.24% -0.02 within
norms 6.248 6.341 6.291 0.030
blackhole write_bh 50 12.372 +1.19% -0.15 outside
norms 12.372 12.592 12.521 0.083
innodb guid 50 515.626 +0.22% -1.16 within
norms 512.151 524.449 516.784 4.143
innodb guid-scale 50 222.822 -0.42% 0.94 within
norms 219.165 224.438 221.885 1.738
innodb key 50 19.952 -0.18% 0.04 within
norms 19.842 20.043 19.917 0.075
innodb key-scale 50 10.209 -0.03% 0.00 within
norms 10.143 10.279 10.206 0.048
innodb mixed 50 148.643 -0.20% 0.30 within
norms 144.008 150.080 148.347 2.219
innodb mixed-commit 50 75.118 -0.06% 0.04 within
norms 74.112 75.524 75.074 0.500
innodb mixed-commit-scale 50 38.246 -1.48% 0.56 outside
norms 37.091 38.246 37.689 0.447
innodb mixed-scale 50 67.128 +8.54% -6.27 outside
norms 67.128 79.827 73.393 4.068
innodb scan 50 91.087 -0.19% 0.17 within
norms 90.510 91.374 90.914 0.295
innodb scan-scale 50 45.634 +0.36% -0.17 outside
norms 45.634 45.943 45.799 0.115
innodb update 50 431.162 +0.25% -1.09 within
norms 429.981 435.244 432.249 1.753
innodb update-commit 50 43.249 +0.40% -0.17 within
norms 42.241 44.098 43.422 0.658
innodb update-commit-scale 50 21.788 -0.06% 0.01 within
norms 20.941 22.354 21.775 0.503
innodb update-scale 50 215.255 +0.32% -0.69 within
norms 214.395 218.691 215.947 1.556
innodb write 50 271.101 +2.19% -6.06 outside
norms 271.101 282.967 277.165 4.337
innodb write-commit 50 123.841 +0.82% -1.02 within
norms 123.554 126.167 124.859 1.090
innodb write-commit-scale 50 61.246 +1.95% -1.22 outside
norms 61.246 63.821 62.462 0.902
innodb write-scale 50 135.939 +1.36% -1.87 within
norms 132.963 141.823 137.807 3.272
======================================================================================================================
TRENDING OVER LAST 20 runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 11.991 -2.60% 0.30 outside
norms 11.271 12.063 11.687 0.245
blackhole guid_bh 50 24.089 -3.35% 0.78 outside
norms 22.492 24.089 23.308 0.491
blackhole write-scale_bh 50 6.276 +0.47% -0.03 within
norms 6.169 6.422 6.305 0.066
blackhole write_bh 50 12.372 +1.23% -0.15 outside
norms 12.305 12.723 12.527 0.126
innodb guid 50 515.626 +3.57% -19.10 outside
norms 512.151 559.162 534.721 14.956
innodb guid-scale 50 222.822 +4.99% -11.70 outside
norms 219.165 245.749 234.523 8.905
innodb key 50 19.952 +0.00% 0.00 within
norms 19.842 20.079 19.953 0.072
innodb key-scale 50 10.209 +0.00% 0.00 within
norms 10.120 10.310 10.209 0.049
innodb mixed 50 148.643 +5.78% -9.12 outside
norms 144.008 177.319 157.767 9.062
innodb mixed-commit 50 75.118 +2.87% -2.22 outside
norms 74.112 80.324 77.341 1.899
innodb mixed-commit-scale 50 38.246 +0.63% -0.24 within
norms 36.824 40.170 38.490 1.029
innodb mixed-scale 50 67.128 +13.54% -10.52 outside
norms 67.128 85.583 77.644 4.841
innodb scan 50 91.087 -0.13% 0.12 within
norms 90.510 91.613 90.967 0.235
innodb scan-scale 50 45.634 +0.47% -0.22 outside
norms 45.464 46.149 45.852 0.174
innodb update 50 431.162 +3.74% -16.73 outside
norms 429.981 469.003 447.892 11.713
innodb update-commit 50 43.249 +1.52% -0.67 within
norms 42.241 47.302 43.917 1.041
innodb update-commit-scale 50 21.788 +0.13% -0.03 within
norms 20.876 22.749 21.816 0.587
innodb update-scale 50 215.255 +3.86% -8.65 outside
norms 214.395 232.762 223.903 6.167
innodb write 50 271.101 +7.07% -20.62 outside
norms 271.101 315.883 291.720 12.226
innodb write-commit 50 123.841 +3.58% -4.60 outside
norms 123.554 135.091 128.437 3.482
innodb write-commit-scale 50 61.246 +4.66% -3.00 outside
norms 61.246 67.873 64.241 1.722
innodb write-scale 50 135.939 +6.71% -9.78 outside
norms 132.963 160.193 145.715 6.782
======================================================================================================================
TRENDING OVER ALL runs
Engine Test Conc Time % Diff from Avg Diff Norm?
Min Max Avg STD
======================================================================================================================
blackhole guid-scale_bh 50 11.991 -2.550 0.300 outside
norms 11.271 12.063 11.692 0.228
blackhole guid_bh 50 24.089 -3.340 0.780 outside
norms 22.492 24.089 23.311 0.450
blackhole write-scale_bh 50 6.276 0.610 -0.040 within
norms 6.169 6.422 6.315 0.059
blackhole write_bh 50 12.372 1.270 -0.160 outside
norms 12.305 12.723 12.531 0.118
innodb guid 50 515.626 4.380 -23.610 outside
norms 512.151 569.692 539.236 14.198
innodb guid-scale 50 222.822 6.000 -14.230 outside
norms 219.165 251.259 237.057 8.202
innodb key 50 19.952 0.010 0.000 within
norms 19.827 20.159 19.954 0.076
innodb key-scale 50 10.209 0.070 -0.010 within
norms 10.120 10.310 10.216 0.049
innodb mixed 50 148.643 7.530 -12.100 outside
norms 144.008 177.319 160.740 8.869
innodb mixed-commit 50 75.118 3.510 -2.730 outside
norms 74.112 82.281 77.851 1.879
innodb mixed-commit-scale 50 38.246 1.480 -0.570 within
norms 36.824 40.995 38.820 1.052
innodb mixed-scale 50 67.128 14.740 -11.610 outside
norms 67.128 88.360 78.737 4.653
innodb scan 50 91.087 -0.120 0.110 within
norms 90.470 91.950 90.978 0.324
innodb scan-scale 50 45.634 0.530 -0.240 outside
norms 45.464 46.149 45.877 0.176
innodb update 50 431.162 4.510 -20.370 outside
norms 429.981 480.264 451.535 11.342
innodb update-commit 50 43.249 1.300 -0.570 within
norms 42.241 47.302 43.820 0.874
innodb update-commit-scale 50 21.788 0.460 -0.100 within
norms 20.876 22.859 21.889 0.543
innodb update-scale 50 215.255 4.500 -10.150 outside
norms 214.395 238.508 225.402 5.675
innodb write 50 271.101 8.370 -24.750 outside
norms 271.101 324.769 295.849 12.057
innodb write-commit 50 123.841 4.490 -5.820 outside
norms 123.554 135.919 129.659 3.335
innodb write-commit-scale 50 61.246 5.350 -3.460 outside
norms 61.246 68.306 64.705 1.681
innodb write-scale 50 135.939 7.780 -11.470 outside
norms 132.963 162.418 147.409 6.449
======================================================================================================================
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp