Hi Jay, > I'll explain more when these things come online later this month.
We are waiting for your posts. Thank You, Jobin. 2009/11/9 Jay Pipes <[email protected]> > Diego Medina wrote: > >> On Mon, Nov 9, 2009 at 12:07 AM, Jay Pipes <[email protected]> wrote: >> >>> Jobin Augustine wrote: >>> >>> There is only a single log file in Drizzle's transaction log, unlike the >>> segmented MySQL binlog. So, there is only a single record in the >>> TRANSACTION_LOG view. >>> >> >> Hi Jay, >> >> I must've missed this but, if Drizzle uses only one single log file, >> how do I "purge" the old entries (to prevent the disk from filling >> up/etc ? >> > > Hi! I will soon be debuting a "snapshot archiver" which can read the > transaction log and process it into a snapshot of a server's state at a > point in time. These snapshots can be used to provide backup and > point-in-time restore capability as well as log/snapshot shipping and > replica startup. > > > Cheers! > > jay > > > and want to know the content of that file (Entires). >>>> how will the query look like? >>>> >>> I have written a UDF which outputs the raw information contained in the >>> Transaction message called PRINT_TRANSACTION_MESSAGE(). I'll post >>> examples >>> of usage later on tomorrow after I'm done with the new test cases >>> validating >>> the new I_S views. >>> >>> Cheers! >>> >>> jay >>> >>> resending because i missed the team. >>>> Thank You Jay, >>>> -Jobin >>>> >>>> >>>> >>>> >>>> >>>> 2009/11/7 Jay Pipes <[email protected]> >>>>> >>>>> Hi all, >>>>> >>>>>> I'm in the process of adding INFORMATION_SCHEMA tables/views to >>>>>> facilitate >>>>>> getting information about the log and its contents via a standard >>>>>> SELECT >>>>>> statement. >>>>>> >>>>>> Here is what I have come up with in regards to the structure of the >>>>>> views. >>>>>> Please let me know if you'd like other information or have >>>>>> suggestions >>>>>> for >>>>>> column naming or anything else. Thanks! >>>>>> >>>>>> 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 >>>>>> ); >>>>>> >>>>>> In addition to the above views, I am creating a UDF called >>>>>> PRINT_TRANSACTION_MESSAGE() which will output the raw contents of the >>>>>> transaction messages in the transaction log. >>>>>> >>>>>> What the above means is that no separate mysqlbinlog-type program will >>>>>> be >>>>>> necessary to fully query the transaction log state on a server. This >>>>>> should >>>>>> make reporting and monitoring of the transaction log easier and more >>>>>> self-contained, allowing tool-makers to issue standard SELECT >>>>>> statements >>>>>> for >>>>>> querying the transaction log. >>>>>> >>>>>> FYI, don't confuse the above views with the replication system. While >>>>>> the >>>>>> replication system may use the transaction log, it will have separate >>>>>> views >>>>>> which provide replication-specific information (similar to SHOW MASTER >>>>>> STATUS etc.) >>>>>> >>>>>> Cheers, and thanks in advance for any input! >>>>>> >>>>>> Jay >>>>>> >>>>>> _______________________________________________ >>>>>> Mailing list: >>>>>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>>>>> <https://launchpad.net/%7Edrizzle-discuss> >>>>>> Post to : [email protected] >>>>>> Unsubscribe : >>>>>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>>>>> <https://launchpad.net/%7Edrizzle-discuss> >>>>>> More help : https://help.launchpad.net/ListHelp >>>>>> >>>>>> >>>> ------------------------------------------------------------------------ >>>> >>>> _______________________________________________ >>>> Mailing list: >>>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>>> Post to : [email protected] >>>> Unsubscribe : >>>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>>> More help : https://help.launchpad.net/ListHelp >>>> >>> >>> _______________________________________________ >>> Mailing list: >>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>> Post to : [email protected] >>> Unsubscribe : >>> https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> >>> More help : https://help.launchpad.net/ListHelp >>> >>> >> >> >> >
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
