Replication - INFORMATION_SCHEMA views for transaction log

Registered by Jay Pipes on 2009-11-09

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 on 2009-11-09
Completed by
Jay Pipes on 2009-12-04

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.