====================================================================================================
SYSBENCH BENCHMARK REPORT 
====================================================================================================
MACHINE:  r815-test1
RUN ID:   130
RUN DATE: 2011-06-18T23:17:33.839655
WORKLOAD: innodb_1000K_readonly
SERVER:   drizzled
VERSION:  staging
REVISION: 2341
COMMENT:  2341: Mark Atwood 2011-06-18 [merge] merge 
lp:~stewart/drizzle/bug658673-DD-use-MAXIMUM_IDENTIFIER_LENGTH
====================================================================================================

TRENDING OVER LAST 5 runs 
Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     2193.49       -0.09%      -1.99    2162.81    2232.26    2195.48      
20.72
32     2444.57       +0.74%      18.01    2354.58    2556.26    2426.57      
63.19
64     1666.26       -1.68%     -28.55    1659.30    1777.58    1694.81      
29.85
128    1422.03       +0.88%      12.37    1394.12    1423.58    1409.66      
10.56
256    1104.51       -1.19%     -13.26    1093.69    1146.54    1117.77      
16.53
512    755.36       +0.19%       1.44     744.19     767.58     753.92       
5.76
1024   488.85       -0.48%      -2.38     487.74     493.84     491.23       
2.21
====================================================================================================

TRENDING OVER Last 20 runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     2193.49       -0.10%      -2.14    2145.34    2249.21    2195.64      
25.09
32     2444.57       +1.90%      45.67    2216.27    2556.26    2398.90      
93.74
64     1666.26       -2.16%     -36.87    1629.03    1777.58    1703.13      
31.73
128    1422.03       +0.26%       3.67    1357.49    1491.19    1418.35      
31.63
256    1104.51       -1.09%     -12.22    1040.66    1173.24    1116.73      
25.99
512    755.36       +0.22%       1.66     732.07     768.59     753.70       
7.76
1024   488.85       -0.59%      -2.89     483.47     499.56     491.74       
3.50
====================================================================================================

TRENDING OVER ALL runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     2193.49       +0.87%      18.85    2065.18    2276.70    2174.65      
35.58
32     2444.57       +2.81%      66.85    2216.27    2566.42    2377.72      
67.88
64     1666.26       -1.97%     -33.56    1590.76    1783.76    1699.82      
37.04
128    1422.03       +1.08%      15.24    1327.93    1498.50    1406.79      
30.10
256    1104.51       -1.43%     -16.01    1030.78    1185.09    1120.53      
28.76
512    755.36       +1.62%      12.05     715.51     771.14     743.32      
10.56
1024   488.85       +0.82%       3.95     465.44     499.56     484.90       
6.34
====================================================================================================
FULL REVISION COMMENTARY:

  2338.2.23: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE columns
  2338.2.22: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.COLUMN_PRIVILEGES columns
  2338.2.21: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE columns
  2338.2.20: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE columns
  2338.2.19: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.ROUTINE_COLUMNS columns
  2338.2.18: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.ROUTINES columns
  2338.2.17: Stewart Smith 2011-06-18 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.TABLE_CONSTRAINTS columns
  2338.2.16: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.TABLE_PRIVILEGES columns
  2338.2.15: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.VIEW_COLUMN_USAGE columns
  2338.2.14: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.VIEW_TABLE_USAGE columns
  2338.2.13: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
INFORMATION_SCHEMA.VIEWS columns
  2338.2.12: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.INNODB_INTERNAL_TABLES columns
  2338.2.11: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.COLUMNS columns
  2338.2.10: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.FOREIGN_KEYS columns
  2338.2.9: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
INDEX_PARTS columns
  2338.2.8: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for INDEXES 
columns
  2338.2.7: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
TABLE_CONSTRAINTS columns
  2338.2.6: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
SHOW_TABLES columns
  2338.2.5: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
SHOW_TEMPORARY_TABLES columns
  2338.2.4: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.TABLE_CACHE columns
  2338.2.3: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.TABLE_DEFINITION_CACHE columns
  2338.2.2: Stewart Smith 2011-06-17 use MAXIMUM_IDENTIFIER_LENGTH for 
DATA_DICTIONARY.TABLES columns
  2338.2.1: Stewart Smith 2011-06-17 use TABLE_COMMENT_MAXLEN define in 
schema_dictionary instead of hard coded 2048

_______________________________________________
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