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? > 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 :) > 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? -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
