=======================================================================================
DBT2 REPORT
=======================================================================================
MACHINE: orisndriz01
RUN ID: 511
RUN DATE: 2010-08-19T18:04:45.526784
SERVER: drizzled
VERSION: staging
REVISION: 1721
COMMENT: 1721: Patrick Crews 2010-08-19 [merge] Rollup patch - stewart's show
create table patch + a couple of fixes
================================================================================================
TRENDING OVER LAST 5 runs
Connections TPM % Diff from Avg Diff Norm? Min Max Avg
STD
================================================================================================
16 125.47 -2.36% -3.04 outside norms 125.47 130.16 128.51
1.61
32 123.91 -1.89% -2.38 within norms 123.12 128.99 126.29
2.39
64 127.82 -0.25% -0.31 within norms 125.88 131.14 128.13
1.93
128 128.40 -0.25% -0.32 within norms 122.94 133.29 128.72
3.49
256 131.18 +3.51% 4.45 outside norms 120.59 131.18 126.73
3.87
512 128.01 -0.06% -0.08 within norms 125.47 131.73 128.09
2.03
1024 129.77 +1.34% 1.72 outside norms 126.06 129.77 128.05
1.21
================================================================================================
TRENDING OVER LAST 20 runs
Connections TPM % Diff from Avg Diff Norm? Min Max Avg
STD
================================================================================================
16 125.47 -2.26% -2.90 within norms 121.95 133.53 128.37
3.07
32 123.91 -2.12% -2.68 outside norms 122.54 130.78 126.59
2.53
64 127.82 +0.12% 0.16 within norms 123.13 131.14 127.66
2.35
128 128.40 +0.94% 1.20 within norms 119.61 133.29 127.20
3.96
256 131.18 +3.75% 4.75 outside norms 120.59 131.18 126.43
2.90
512 128.01 -0.32% -0.41 within norms 123.33 133.49 128.42
2.75
1024 129.77 +0.83% 1.06 within norms 125.28 133.49 128.71
2.40
================================================================================================
TRENDING OVER ALL runs
Connections TPM % Diff from Avg Diff Norm? Min Max Avg
STD
================================================================================================
16 125.47 -1.17% -1.48 within norms 114.19 134.85 126.95
3.67
32 123.91 -2.43% -3.09 within norms 112.06 135.24 127.00
3.86
64 127.82 +0.89% 1.13 within norms 88.73 134.27 126.69
4.24
128 128.40 +1.34% 1.70 within norms 21.11 136.22 126.70
7.39
256 131.18 +3.28% 4.17 outside norms 114.02 136.03 127.01
3.74
512 128.01 +0.96% 1.22 within norms 57.46 135.24 126.79
5.49
1024 129.77 +1.96% 2.49 within norms 88.73 135.83 127.28
4.24
=========================================================================================================================
FULL REVISION COMMENTARY:
1720.1.3: Patrick Crews 2010-08-19 [merge] Merge Monty to make intltool
optional
1719.1.1: Monty Taylor 2010-08-19 _actually_ make OSX work with no
intltool. Sorry.
1720.1.2: Patrick Crews 2010-08-19 Updated pbxt tests due to inclusion of
COLLATE info in SHOW CREATE TABLE output now. Only re-recorded .result files
1720.1.1: Brian Aker 2010-08-19 [merge] Merging Stewart's show create table
patch.
1638.10.120: Stewart Smith 2010-08-17 [merge] merge trunk
1638.10.119: Stewart Smith 2010-08-17 make innobase plugin not directly
access the mysql_query_str for CREATE TABLE, and instead use the table protobuf
message and statement_transform to get a SQL string to pass to innobase for
parsing to get the foreign keys out of it.
1638.10.118: Stewart Smith 2010-08-17 fix naming of constraints to be more
standards compliant and correct. the index_name part of it just doesn't exist
in SQL-99
1638.10.117: Stewart Smith 2010-08-16 update innodb test for auto_increment
behaviour
1638.10.116: Stewart Smith 2010-08-16 only display AUTO_INCREMENT value if
explicitly set by user (and preserve across ALTER TABLE).
1638.10.115: Stewart Smith 2010-08-11 remove auto_increment in TableOptions
in Table protobuf message. It was unused and confusing
1638.10.114: Stewart Smith 2010-08-10 when creating a CreateField from a
Field, a auto_incremen column should not have a default value of 0 as that's
not magic.
1638.10.113: Stewart Smith 2010-08-10 [merge] link fix for
libdrizzled_message
1638.10.112: Stewart Smith 2010-08-10 [merge] fix linking of
drizzled/message lib and libcharset
1638.10.111: Stewart Smith 2010-08-09 fix drizzledump-max test result for
having explicit COLLATE in SHOW CREATE TABLE
1638.10.110: Stewart Smith 2010-08-09 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.109: Stewart Smith 2010-08-05 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.108: Stewart Smith 2010-08-04 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.107: Stewart Smith 2010-08-03 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.106: Stewart Smith 2010-08-03 fix null_values transaction_log
CREATE TABLE result
1638.10.105: Stewart Smith 2010-08-03 fix filesystem_engine test case
results for CREATE TABLE out of proto
1638.10.104: Stewart Smith 2010-08-02 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.103: Stewart Smith 2010-07-30 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.102: Stewart Smith 2010-07-29 [merge] merge trunk
1638.10.101: Stewart Smith 2010-07-28 [merge] merge test fixes for
DATE/DATETIME default
1638.10.100: Stewart Smith 2010-07-28 [merge] merge fix for default value
of DATE in proto
1638.10.99: Stewart Smith 2010-07-28 fix type_datetime.result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.98: Stewart Smith 2010-07-28 update transaction_log/update.result
to reflect correct CREATE TABLE statements. My code is correct, old
statement_transform wasn't reproducing the CREATE TABLE statement correctly.
1638.10.97: Stewart Smith 2010-07-28 [merge] merge in table comment fix
1638.10.96: Stewart Smith 2010-07-28 fix show_check test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.95: Stewart Smith 2010-07-28 fix archive_aio_posix test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.94: Stewart Smith 2010-07-28 [merge] merge fix for RENAME TABLE for
ARCHIVE
1638.10.93: Stewart Smith 2010-07-28 ARCHIVE test result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.92: Stewart Smith 2010-07-27 even more fixes due to SHOW CREATE
TABLE now actually working
1638.10.91: Stewart Smith 2010-07-27 test result fixes for the dictionary
suites: table names should be upper case as well as having explicit COLLATE in
SHOW CREATE TABLE
1638.10.90: Stewart Smith 2010-07-27 blackhole create_max_fields test to
have explicit COLLATE in SHOW CREATE TABLE
1638.10.89: Stewart Smith 2010-07-27 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.88: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.87: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.86: Stewart Smith 2010-07-27 fix some more tests for explicit
COLLATE in CREATE TABLE, including transaction_log whitespace changes
1638.10.85: Stewart Smith 2010-07-27 explicit COLLATE in CREATE TABLE test
result fixes for innodb_mysql test
1638.10.84: Stewart Smith 2010-07-27 some CREATE TABLE fixes for
transaction_log tests
1638.10.83: Stewart Smith 2010-07-26 fix some more tests for explicit
COLLATE in CREATE TABLE
1638.10.82: Stewart Smith 2010-07-26 fix some tests for explicit COLLATE in
CREATE TABLE
1638.10.81: Stewart Smith 2010-07-26 fix key.result for explicit COLLATE in
CREATE TABLE
1638.10.80: Stewart Smith 2010-07-26 fix storing and manipulating foreign
keys in the proto around ALTER TABLE, CREATE TABLE and ALTER TABLE ADD/DROP
FOREIGN KEY. We also (mostly) emulate the naming of innodb foreign keys in the
upper layer.
1638.10.79: Stewart Smith 2010-07-26 restore the foreign key names to SHOW
CREATE TABLE in the innodb test result file.
1638.10.78: Stewart Smith 2010-07-26 separate out adding the foreign key to
the table protobuf message from mysql_prepare_create_table and call a function
to do it directly from the parser where we set up the foreign key structures
1638.10.77: Stewart Smith 2010-07-26 table_ident.h was missing a dependency
on session.h for: ./drizzled/table_ident.h:53: error: âempty_c_stringâ was
not declared in this scope
1638.10.76: Stewart Smith 2010-07-21 innodb.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.75: Stewart Smith 2010-07-21 heap.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.74: Stewart Smith 2010-07-21 func_system.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.73: Stewart Smith 2010-07-21 func_misc.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.72: Stewart Smith 2010-07-21 func_math.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.71: Stewart Smith 2010-07-21 func_group.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.70: Stewart Smith 2010-07-21 func_gconcat.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.69: Stewart Smith 2010-07-21 foreign_key.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.68: Stewart Smith 2010-07-21 drizzledump.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.67: Stewart Smith 2010-07-21 default_collation.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.66: Stewart Smith 2010-07-21 default.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.65: Stewart Smith 2010-07-21 ctype_utf8.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.64: Stewart Smith 2010-07-21 create_no_windows.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.63: Stewart Smith 2010-07-21 create.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.62: Stewart Smith 2010-07-21 constraint.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.61: Stewart Smith 2010-07-21 comment_talbe.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.60: Stewart Smith 2010-07-21 comment_index.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.59: Stewart Smith 2010-07-21 comment_column.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.58: Stewart Smith 2010-07-21 case.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.57: Stewart Smith 2010-07-21 binary.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.56: Stewart Smith 2010-07-21 bigint.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.55: Stewart Smith 2010-07-21 auto_increment.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.54: Stewart Smith 2010-07-21 alter_table.result: COLLATE and ENGINE
in same line for SHOW CREATE TABLE
1638.10.53: Stewart Smith 2010-07-21 no newline before COLLATE in SHOW
CREATE TABLE
1638.10.52: Stewart Smith 2010-07-21 alter_table test: COLLATE is now
explicit in SHOW CREATE TABLE as table proto has no way to find out if it was
an explicit option or not.
1638.10.51: Stewart Smith 2010-07-21 show_create_table_basic test: COLLATE
is now explicit in SHOW CREATE TABLE as table proto has no way to find out if
it was an explicit option or not.
1638.10.50: Stewart Smith 2010-07-21 revert patch that removse explicitly
setting collation for talbe_function tables.
1638.10.49: Stewart Smith 2010-07-20 [merge] merge trunk
1638.10.48: Stewart Smith 2010-07-19 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.47: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.46: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.45: Stewart Smith 2010-07-12 don't have internal innodb foreign key
names in FOREIGN KEY clauses in innodb.result
1638.10.44: Stewart Smith 2010-07-12 fix spaces in CREATE TABLE ... FOREIGN
KEY statement
1638.10.43: Stewart Smith 2010-07-12 foreign_key test result update: don't
have innodb internal foreign key names in the result (now that we're using
statement_transform for foreign key)
1638.10.42: Stewart Smith 2010-07-12 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.41: Stewart Smith 2010-07-06 [merge] Merged
varchar-text-keylength-in-proto-as-characters-not-bytes into
show-create-table-using-table-message.
1638.10.40: Stewart Smith 2010-07-05 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.39: Stewart Smith 2010-07-02 correctly have auto_increment value in
drizzledump test result
1638.10.38: Stewart Smith 2010-07-02 correctly have default COLLATE for
table in SHOW CREATE TABLE result for default_collation test result.
1638.10.37: Stewart Smith 2010-07-02 fix result of default test: varbinary
defaults are now represented as hex in SHOW CREATE TABLE and the COLLATE for
the table wasn't being shown.
1638.10.36: Stewart Smith 2010-07-02 correct the create.result file to show
the COLLATE clause at teh end of the SHOW CREATE TABLE output. Previously, this
wasn't being displayed due to some kind of bug.
1638.10.35: Stewart Smith 2010-07-02 table_function doesn't need to
explicitly set collation for its tables as the default (utf8_general_ci) is
exactly what we want.
1638.10.34: Stewart Smith 2010-07-02 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.33: Stewart Smith 2010-07-01 index comments in statement_transform
1638.10.32: Stewart Smith 2010-07-01 statement transform for create table:
formatting of decimal default value doesn't matter
1638.10.31: Stewart Smith 2010-07-01 statement_transform for CREATE TABLE:
only print DEFAULT NULL if default_null is actually set, not just if the proto
has it.
1638.10.30: Stewart Smith 2010-07-01 get USING (BTREE|HASH) index type
syntax correct for statement_transform in CREATE TABLE.
1638.10.29: Stewart Smith 2010-07-01 fix collation detection for BLOB/TEXT
in statement_transform for CREATE TABLE. Also, the DEFAULT NULL for BLOB
columns is implicit, so don't print it.
1638.10.28: Stewart Smith 2010-07-01 fix a lot of quoting and escaping of
things in SHOW CREATE TABLE in statement_transform
1638.10.27: Stewart Smith 2010-07-01 [merge] Merged
bug600088-multibyte-comments-in-show-create into
show-create-table-using-table-message.
1638.10.26: Stewart Smith 2010-06-30 use length of create table string in
appending to packet.
1638.10.25: Stewart Smith 2010-06-30 fix table comment formatting in
statement_transform to have SHOW CREATE work with a table comment
1638.10.24: Stewart Smith 2010-06-30 fix display of VARBINARY default
values in SHOW CREATE TABLE. Always use printable characters by encoding in hex.
1638.10.23: Stewart Smith 2010-06-30 add SHOW CREATE TABLE test for
VARBINARY columns (especially with default values).
1638.10.22: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.21: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.20: Stewart Smith 2010-06-30 present DEFAULT and ON UPDATE
correctly in statement_transform
1638.10.19: Stewart Smith 2010-06-30 [merge] Merged
table-proto-default-update-expression into
show-create-table-using-table-message.
1638.10.18: Stewart Smith 2010-06-29 [merge] merge
1638.10.17: Stewart Smith 2010-06-29 fix SHOW CREATE TABLE
(statement_transform) for auto_increment, including the (now correct)
auto_increment test result.
1638.10.16: Stewart Smith 2010-06-29 fix up AUTO_INCREMENT must be after
NOT NULL in statement_transform
1638.10.15: Stewart Smith 2010-06-29 TIMESTAMP fields are default NOT NULL
for some bonghits reason, so we get to have explicit NULLability.
1638.10.14: Stewart Smith 2010-06-28 if a DOUBLE column has scale and
precision, display them
1638.10.13: Stewart Smith 2010-06-28 NOT NULL comes after COLLATE in CREATE
TABLE
1638.10.12: Stewart Smith 2010-06-28 fix the bonghits quoting rules in
field CREATE TABLE definitions for quotes around the identifier, comment and
default value.
1638.10.11: Stewart Smith 2010-06-28 fix varchar/varbinary and blob/text
for statement_transform of table definition
1638.10.10: Stewart Smith 2010-06-28 fix statement_transform for producing
list of engine options
1638.10.9: Stewart Smith 2010-06-28 [merge] merge
1638.10.8: Stewart Smith 2010-06-28 fix DEFAULT NULL and NOT NULL for
statement_transform
1638.10.7: Stewart Smith 2010-06-28 [merge] Merged
default-collation-in-table-message into show-create-table-using-table-message.
1638.10.6: Stewart Smith 2010-06-28 statement_transform: ENGINE clause of
CREATE TABLE doesn't have spaces around equals sign
1638.10.5: Stewart Smith 2010-06-28 statement_transform: only print index
name iff it's not PRIMARY for a pkey. Also get indenting correct for index
names.
1638.10.4: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
field types are lower case.
1638.10.3: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
fields are indented by 2 spaces
1638.10.2: Stewart Smith 2010-06-28 for store_create_info() (called in SHOW
CREATE TABLE code path) call transformTableDefinitionToSql() in
statement_transform lib instead of doing manual things on Table. This is the
initial step in getting SHOW CREATE TABLE to be run from proto.
1638.10.1: Stewart Smith 2010-06-28 add really simple SHOW CREATE TABLE
test to help with migrating SHOW CREATE to use proto
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
