==================================================================================================== SYSBENCH BENCHMARK REPORT ==================================================================================================== MACHINE: r815-test2 RUN ID: 814 RUN DATE: 2011-06-18T23:26:55.764490 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 902.06 +0.44% 3.96 887.77 910.54 898.10 6.42 32 1100.47 +1.67% 18.03 1029.06 1133.59 1082.44 27.80 64 1142.39 -10.01% -127.03 1088.20 1396.18 1269.42 110.11 128 709.09 +5.41% 36.42 612.65 734.49 672.67 41.04 256 461.15 -1.17% -5.48 457.65 479.27 466.63 6.14 512 320.92 +0.13% 0.41 316.31 324.29 320.50 2.25 1024 202.39 -0.37% -0.76 201.68 205.19 203.15 1.24 ==================================================================================================== TRENDING OVER Last 20 runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 902.06 +0.53% 4.76 868.23 916.45 897.30 9.11 32 1100.47 +0.82% 8.99 1029.06 1159.53 1091.48 27.08 64 1142.39 -11.71% -151.50 1088.20 1396.18 1293.89 77.13 128 709.09 +8.71% 56.78 608.46 791.70 652.31 38.12 256 461.15 -0.35% -1.60 452.05 479.27 462.75 5.34 512 320.92 -0.33% -1.06 315.53 330.54 321.98 3.35 1024 202.39 -0.62% -1.26 200.08 206.81 203.64 1.82 ==================================================================================================== TRENDING OVER ALL runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 902.06 -43.93% -706.87 868.23 1869.76 1608.93 269.87 32 1100.47 -41.55% -782.27 1029.06 2395.61 1882.75 318.85 64 1142.39 -19.28% -272.89 878.49 1721.72 1415.29 86.10 128 709.09 -31.60% -327.52 608.46 1345.78 1036.61 153.92 256 461.15 -44.60% -371.28 449.38 1034.59 832.43 143.70 512 320.92 -45.17% -264.32 311.90 781.01 585.24 104.59 1024 202.39 -46.34% -174.76 198.22 487.49 377.15 68.90 ==================================================================================================== 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
