Stewart Smith wrote:
On Fri, Nov 06, 2009 at 01:48:34PM -0500, Jay Pipes wrote:
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
);
anything else we have that could be useful? ctime, atime, mtime?
Not sure; I can certainly add any or all of those. DBAs out there, what
do you think? Would the access or modification time of the transaction
log file be useful?
CREATE TABLE INFORMATION_SCHEMA.TRANSACTION_LOG_ENTRIES (
ENTRY_OFFSET BIGINT NOT NULL
, ENTRY_TYPE VARCHAR NOT NULL
, ENTRY_LENGTH BIGINT NOT NULL
);
ENTRY BLOB
then can write more tests as plain sql :)
Eh, kinda. There is an ENTRY_TYPE of "BLOB" coming shortly. I didn't
think that there didn't to be a separate view for the BLOBs themselves
since pretty much all the information one needs *about* the BLOB is in
the view above...
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
);
possible to get at all the entries for a txn?
Yes, but via a UDF called PRINT_TRANSACTION_MESSAGE(). More on this
today...
Cheers!
jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
