==================================================================================================== SYSBENCH BENCHMARK REPORT ==================================================================================================== MACHINE: Drizzle-build-n04 RUN ID: 355 RUN DATE: 2012-01-19T07:49:08.374325 WORKLOAD: innodb_1000K_readwrite SERVER: drizzled VERSION: staging REVISION: 2494 COMMENT: 2494: Mark Atwood 2012-01-18 [merge] merge lp:~stewart/drizzle/fix-create-schema-for-catalogs ====================================================================================================
TRENDING OVER LAST 5 runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1532.90 -2.10% -32.85 1517.68 1633.44 1565.75 33.72 32 1486.28 -5.18% -81.18 1483.85 1633.61 1567.45 54.47 64 1608.46 -0.42% -6.77 1588.04 1646.31 1615.23 16.70 128 1611.90 +0.81% 12.95 1561.57 1621.71 1598.96 19.18 256 1460.25 -0.26% -3.77 1455.37 1482.00 1464.02 8.33 512 1251.29 +0.07% 0.86 1211.60 1282.25 1250.43 20.06 1024 860.00 -1.73% -15.12 859.58 894.61 875.12 9.22 ==================================================================================================== TRENDING OVER Last 20 runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1532.90 -5.45% -88.36 1517.68 1794.03 1621.26 69.84 32 1486.28 -8.66% -140.87 1483.85 1748.26 1627.15 69.27 64 1608.46 -2.59% -42.80 1588.04 1736.31 1651.25 43.86 128 1611.90 -0.45% -7.32 1552.50 1685.96 1619.22 34.99 256 1460.25 -0.55% -8.06 1416.89 1503.88 1468.31 21.66 512 1251.29 -2.77% -35.60 1211.60 1334.07 1286.89 37.54 1024 860.00 -8.75% -82.47 859.58 1029.24 942.47 65.00 ==================================================================================================== TRENDING OVER ALL runs Conc TPS % Diff from Avg Diff Min Max Avg STD ==================================================================================================== 16 1532.90 -10.56% -180.95 1177.28 1913.94 1713.85 102.72 32 1486.28 -12.76% -217.35 1448.82 1853.08 1703.63 74.90 64 1608.46 -6.57% -113.18 1480.63 1872.32 1721.63 57.47 128 1611.90 -4.23% -71.21 1401.59 1771.41 1683.12 46.71 256 1460.25 -3.56% -53.94 1268.10 1580.87 1514.19 36.25 512 1251.29 -5.89% -78.38 1075.06 1380.41 1329.67 33.68 1024 860.00 -14.32% -143.76 639.68 1065.34 1003.76 39.64 ==================================================================================================== FULL REVISION COMMENTARY: 2478.3.16: Stewart Smith 2012-01-18 fix up problem with constant schema identifiers for DATA_DICTIONARY and INFORMATION_SCHEMA that came up on certain compilers choosing orders for static constructor execution. 2478.3.15: Stewart Smith 2012-01-17 fix up table_identifier unit tests to deal with identifier::Table constructor now also requiring a Catalog identifier 2478.3.14: Stewart Smith 2012-01-17 [merge] merge trunk 2478.3.13: Stewart Smith 2012-01-05 fix initialization of message::schema to be from the Schema identifier, which includes the CATALOG name, so that we can create schemas in catalogs other than LOCAL 2478.3.12: Stewart Smith 2012-01-05 force a identifier::Schema to be constructed with a identifier::Catalog. This is close to the final 'big' part for CATALOG support. We also have to modify all around the server that creates identifier::Schema so it does so properly. Since a single Session cannot span schemas, we get off a wee bit easy :) The big limitation in this patch is that INFORMATION_SCHEMA and DATA_DICTIONARY only appear in the LOCAL catalog (and this really needs to be fixed before CATALOGs other than LOCAL are supported). 2478.3.11: Stewart Smith 2012-01-05 use the table identifier and catalog in the identifier in constructing the path in build_table_filename instead of the global drizzled::catalog::local_identifier(). Another step towards full CATALOG support 2478.3.10: Stewart Smith 2012-01-05 [merge] merge table_identifier unittest fix 2478.3.9: Stewart Smith 2012-01-05 TableShare use a TableIdentifier instead of db,table strings. 2478.3.8: Stewart Smith 2012-01-04 [merge] merge print_transaction_message filename/path bug fix (also hit in testing CATALOG) 2478.3.7: Stewart Smith 2012-01-04 [merge] merge off-by-one error message fix (was hitting this) 2478.3.6: Stewart Smith 2011-12-28 Schema identifier has a Catalog identifier. Use it instead of catalog::local_identifier() in most places in Schema identifier code 2478.3.5: Stewart Smith 2011-12-28 update innodb-system-table-view.result to include CATALOG in path to table 2478.3.4: Stewart Smith 2011-12-28 modify tableprototester to include local/ in the path for the test tables 2478.3.3: Stewart Smith 2011-12-28 modify transaction_log plugin to default to local/transaction.log to keep backwards compatibility with old drizzled (before chdir to local/ was removed) 2478.3.2: Stewart Smith 2011-12-28 no longer chdir into local CATALOG. Instead, generate paths everywhere (well... in identifiers) that include the path to the correct CATALOG. Currently that's just LOCAL, but we get closer. Also added is some backwards compatibility code in InnoDB for old data dictionary entries that didn't include CATALOG in catalog/db/table but just had db/table. The next step is to construct the table and schema identifiers with the current CATALOG. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-benchmark Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-benchmark More help : https://help.launchpad.net/ListHelp
