Hi Stefan,
The following very simple python script extracts all different (in time
order) updates and queries:
http://www.modis.ispras.ru/FTPContent/sedna/tools/logparser.py
If you need every update and ever query just change lines:
if(not(s in queries)) ---> if(True)
Ivan Shcheklein,
Sedna Team
On Wed, Jun 16, 2010 at 5:29 PM, Stefan Koch <k...@ipericon.com> wrote:
> Hello,
>
> is it possible to implement a new log, that only logs querys and no
> other informations?
>
> Reasoning:
> If you had a DB crash and sedna can't recover the logical log, you'll
> have to use a backup. In most cases, there will be a timely gap between
> the last backup and and the DB crash. So if you want to recover the lost
> data you have to go through the event log, copy all queries, remove the
> "---" chars in the queries so that you can execute them via sednaAdmin
> or SDBAdmin to recover your lost data.
>
> It would save a lot of time and give your more flexibillity with your
> backup strategy if you have a querylog in the backhand.
> It should be a separate file - because you need the information from the
> eventlog also.
>
> Kind regards,
>
> Stefan
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit. See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> Sedna-discussion mailing list
> Sedna-discussion@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sedna-discussion
>
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Sedna-discussion mailing list
Sedna-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
