=======================================================================================
DBT2 REPORT
=======================================================================================
MACHINE:  orisndriz01
RUN ID:   463
RUN DATE: 2010-07-29T23:25:25.485728
SERVER:   drizzled
VERSION:  staging
REVISION: 1673
COMMENT:  1673: Brian Aker 2010-07-29 [merge] Merge Stewart.

================================================================================================
TRENDING OVER LAST 5 runs
Connections TPM   % Diff from Avg Diff       Norm?       Min     Max     Avg    
 STD    
================================================================================================
2          127.23     +0.58%      0.74   within norms  122.93  128.99  126.49   
 2.01
4          127.62     -1.31%     -1.69  outside norms  127.62  131.92  129.31   
 1.46
8          121.95     -3.07%     -3.87  outside norms  121.95  128.96  125.82   
 2.24
16         130.75     +2.55%      3.25   within norms  120.39  134.85  127.50   
 4.97
32         129.22     +2.40%      3.03  outside norms  123.91  129.22  126.19   
 1.91
64         124.30     -1.25%     -1.57   within norms  121.95  129.58  125.87   
 2.62
128        129.80     +1.58%      2.02   within norms  123.91  131.14  127.78   
 2.54
256        127.82     -2.59%     -3.39  outside norms  127.21  136.03  131.21   
 3.31
512        132.90     +4.39%      5.59  outside norms  121.56  132.90  127.31   
 3.69
1024       124.69     -0.65%     -0.82   within norms  122.54  129.38  125.51   
 2.66

================================================================================================
TRENDING OVER LAST 20 runs
Connections TPM   % Diff from Avg Diff       Norm?       Min     Max     Avg    
 STD    
================================================================================================
2          127.23     +1.12%      1.41   within norms  122.15  128.99  125.83   
 2.20
4          127.62     -0.52%     -0.67   within norms  121.37  132.16  128.29   
 2.87
8          121.95     -3.91%     -4.96  outside norms  120.78  134.85  126.91   
 3.68
16         130.75     +2.51%      3.20   within norms  120.39  134.85  127.55   
 3.68
32         129.22     +1.75%      2.22   within norms  122.74  135.24  127.00   
 3.29
64         124.30     -2.02%     -2.56   within norms  121.56  131.73  126.86   
 3.13
128        129.80     +2.13%      2.71   within norms  120.58  131.14  127.09   
 2.79
256        127.82     -0.84%     -1.08   within norms  124.10  136.03  128.90   
 3.59
512        132.90     +3.73%      4.78  outside norms  121.56  134.46  128.13   
 3.39
1024       124.69     -1.76%     -2.24   within norms  122.54  131.57  126.93   
 3.08

================================================================================================
TRENDING OVER ALL runs
Connections TPM   % Diff from Avg Diff       Norm?       Min     Max     Avg    
 STD    
================================================================================================
2          127.23     +0.16%      0.21   within norms  115.60  134.66  127.02   
 3.78
4          127.62     +0.50%      0.63   within norms  112.06  139.35  126.99   
 4.01
8          121.95     -3.89%     -4.94  outside norms  113.82  137.25  126.89   
 3.97
16         130.75     +3.19%      4.04  outside norms  114.19  134.85  126.71   
 3.77
32         129.22     +1.79%      2.27   within norms  112.06  135.24  126.95   
 3.92
64         124.30     -1.82%     -2.31   within norms   88.73  134.27  126.61   
 4.49
128        129.80     +2.45%      3.11   within norms   21.11  136.22  126.69   
 7.96
256        127.82     +0.70%      0.89   within norms  114.02  136.03  126.93   
 3.85
512        132.90     +5.02%      6.35  outside norms   57.46  135.24  126.55   
 5.88
1024       124.69     -1.90%     -2.42   within norms   88.73  135.83  127.11   
 4.46

=========================================================================================================================
FULL REVISION COMMENTARY:

  1672.1.2: Brian Aker 2010-07-29 [merge] Merge Stewart
    1668.7.2: Stewart Smith 2010-07-28 test result fixes due to DATETIME 
default value now being actually stored as a DATETIME instead of whatever the 
heck
    1668.7.1: Stewart Smith 2010-07-28 default values for DATE columns were 
being stored in the original string that the user entered in CREATE TABLE while 
what actually happens is that this string is typecast to DATE (e.g. if it had a 
time as well the time vanishes silently). This patch fixes what's stored in the 
table proto. This is visible when you use statement_transform for SHOW CREATE 
TABLE
  1672.1.1: Brian Aker 2010-07-29 [merge] Merge Stewart
    1668.6.1: Stewart Smith 2010-07-28 use default_expression and 
update_expression instead of default_value and update_value in the table proto 
for NOW()

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help   : https://help.launchpad.net/ListHelp

Reply via email to