7
7
INSERT INTO t1 VALUES (1, "I love testing.");
8
8
INSERT INTO t1 VALUES (2, "I hate testing.");
9
10
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG;
10
11
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
12
13
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_ENTRIES;
13
14
ENTRY_OFFSET ENTRY_TYPE ENTRY_LENGTH
18
20
SELECT * FROM DATA_DICTIONARY.TRANSACTION_LOG_TRANSACTIONS;
19
21
ENTRY_OFFSET TRANSACTION_ID SERVER_ID START_TIMESTAMP END_TIMESTAMP NUM_STATEMENTS CHECKSUM
24
27
SET GLOBAL transaction_log_truncate_debug= true;