====================================================================================================
SYSBENCH BENCHMARK REPORT 
====================================================================================================
MACHINE:  Drizzle-build-n03
RUN ID:   242
RUN DATE: 2011-06-18T23:18:43.375947
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     2311.72       -1.03%     -24.14    2227.85    2427.33    2335.86      
59.85
32     2666.34       +2.42%      62.91    2433.20    2717.25    2603.43      
93.93
64     2715.87       +1.03%      27.60    2621.20    2733.64    2688.27      
30.35
128    2624.24       -0.58%     -15.39    2616.58    2664.13    2639.63      
14.34
256    2385.13       -0.52%     -12.41    2365.37    2420.87    2397.54      
17.35
512    1971.94       -0.15%      -3.01    1953.41    1998.24    1974.96      
13.04
1024   1260.32       -0.24%      -3.08    1230.10    1290.73    1263.40      
15.29
====================================================================================================

TRENDING OVER Last 20 runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     2311.72       -1.87%     -43.94    2227.85    2526.44    2355.66      
57.30
32     2666.34       +1.05%      27.61    2433.20    2720.99    2638.73      
72.48
64     2715.87       +1.40%      37.48    2512.65    2760.38    2678.39      
52.25
128    2624.24       -0.33%      -8.61    2560.04    2678.92    2632.86      
28.36
256    2385.13       -0.83%     -20.02    2359.75    2443.82    2405.15      
21.41
512    1971.94       -0.31%      -6.08    1950.85    2003.35    1978.02      
13.97
1024   1260.32       -0.93%     -11.85    1230.10    1304.60    1272.17      
18.18
====================================================================================================

TRENDING OVER ALL runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     2311.72       -0.83%     -19.26    2171.92    2556.87    2330.98      
56.34
32     2666.34       +2.43%      63.25    2290.10    2774.27    2603.09      
92.16
64     2715.87       +1.34%      35.83    2489.95    2831.41    2680.04      
55.61
128    2624.24       +0.38%       9.91    2531.85    2725.58    2614.34      
37.76
256    2385.13       +0.12%       2.85    2297.47    2500.38    2382.29      
38.73
512    1971.94       +0.93%      18.11    1877.86    2051.13    1953.83      
35.83
1024   1260.32       -4.34%     -57.22    1190.29    1445.26    1317.54      
48.69
====================================================================================================
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