Replication - INFORMATION_SCHEMA views for transaction log

Registered by Jay Pipes

Implement a number of views in the INFORMATION_SCHEMA for querying the transaction log:

CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG (
  FILE_NAME VARCHAR NOT NULL
, FILE_LENGTH BIGINT NOT NULL
, NUM_LOG_ENTRIES BIGINT NOT NULL
, NUM_TRANSACTIONS BIGINT NOT NULL
, MIN_TRANSACTION_ID BIGINT NOT NULL
, MAX_TRANSACTION_ID BIGINT NOT NULL
, MIN_TIMESTAMP BIGINT NOT NULL
, MAX_TIMESTAMP BIGINT NOT NULL
);

CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG_ENTRIES (
  ENTRY_OFFSET BIGINT NOT NULL
, ENTRY_TYPE VARCHAR NOT NULL
, ENTRY_LENGTH BIGINT NOT NULL
);

CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG_TRANSACTIONS (
  ENTRY_OFFSET BIGINT NOT NULL
, TRANSACTION_ID BIGINT NOT NULL
, SERVER_ID INT NOT NULL
, START_TIMESTAMP BIGINT NOT NULL
, END_TIMESTAMP BIGINT NOT NULL
, NUM_STATEMENTS INT NOT NULL
, CHECKSUM INT NOT NULL
);

Blueprint information

Status:
Complete
Approver:
Jay Pipes
Priority:
Medium
Drafter:
Jay Pipes
Direction:
Approved
Assignee:
Jay Pipes
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
milestone icon bell
Started by
Jay Pipes
Completed by
Jay Pipes

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.