====================================================================================================
SYSBENCH BENCHMARK REPORT 
====================================================================================================
MACHINE:  drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID:   1123
RUN DATE: 2011-06-18T19:22:15.704790
WORKLOAD: innodb_1000K_readwrite
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     1323.12       +1.21%      15.80    1263.85    1359.09    1307.32      
30.02
32     1477.48       -1.06%     -15.88    1404.47    1617.05    1493.36      
63.81
64     1679.33       +0.63%      10.53    1560.79    1718.72    1668.80      
43.35
128    1701.22       -0.48%      -8.29    1681.88    1754.57    1709.51      
20.69
256    1674.86       -1.27%     -21.61    1669.85    1738.14    1696.47      
21.13
512    1488.18       +0.18%       2.67    1474.29    1493.28    1485.51       
4.77
1024   923.66       -0.68%      -6.29     918.55     960.97     929.95      
11.33
====================================================================================================

TRENDING OVER Last 20 runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1323.12       +0.21%       2.80    1263.85    1361.76    1320.32      
27.29
32     1477.48       -2.29%     -34.63    1404.47    1641.29    1512.11      
64.17
64     1679.33       +2.11%      34.63    1523.73    1724.05    1644.71      
48.12
128    1701.22       -0.28%      -4.83    1623.29    1801.81    1706.05      
37.58
256    1674.86       -0.54%      -9.04    1616.20    1738.14    1683.90      
27.44
512    1488.18       +0.22%       3.28    1451.69    1520.45    1484.91      
10.64
1024   923.66       -2.47%     -23.38     913.25    1013.26     947.04      
25.26
====================================================================================================

TRENDING OVER ALL runs 

Conc   TPS     % Diff from Avg   Diff       Min        Max        Avg        
STD       
====================================================================================================
16     1323.12       +1.37%      17.92     345.67    1503.03    1305.20      
73.76
32     1477.48       -7.22%    -115.05     616.39    1870.18    1592.53     
116.00
64     1679.33       -2.38%     -41.00     683.67    2059.46    1720.33     
136.71
128    1701.22       -4.09%     -72.53    1289.29    2051.37    1773.75     
107.15
256    1674.86       -1.71%     -29.19    1223.81    1824.49    1704.05      
61.91
512    1488.18       +7.18%      99.69     661.33    1554.29    1388.49     
166.66
1024   923.66      -11.30%    -117.63     859.21    1143.07    1041.29      
66.25
====================================================================================================
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