~jaypipes/drizzle/replication-to-transaction

Merge Jay.

added added

removed removed

SET GLOBAL transaction_log_truncate_debug= true;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (

id INT NOT NULL PRIMARY KEY

INSERT INTO t1 VALUES (1, "I love testing.");

INSERT INTO t1 VALUES (2, "I hate testing.");

SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;

FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP

transaction.log X 4 4 1 4 X X

FILE_NAME FILE_LENGTH NUM_LOG_ENTRIES NUM_TRANSACTIONS MIN_TRANSACTION_ID MAX_TRANSACTION_ID MIN_END_TIMESTAMP MAX_END_TIMESTAMP INDEX_SIZE_IN_BYTES

transaction.log X 4 4 X X X X X

SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;

ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH

X TRANSACTION X

SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;

ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM

X 1 1 X X 1 0

X 2 1 X X 1 0

X 3 1 X X 1 0

X 4 1 X X 1 0

X X 1 X X 1 0

SET GLOBAL transaction_log_truncate_debug= true;