==================================================================================================== 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

