Subject | RE: [firebird-support] FB 2.1.1 - gstat x mon$ tables: which is correct? |
---|---|
Author | bogdan |
Post date | 2008-11-11T07:09:54Z |
>1. Now, I am loster than before... :-)Btw, why do you have »no reserve« attribute set for database ??
>2. There is no gargage collection from 04:00 through 22:00. At midnight, a cron job does backup and restore every day.
>3. No. :-) Maybe, I wish firebird .conf would have an option that after one transaction were open for a long time, i.g. 15 minutes, it would be >automatically commited or rolled back... When mon$ transactions are commited?
>4. I have just made gstat, commit, select mon$, commit and gstat again, and the numbers are:
>Mon Nov 10 10:39:34 BRST 2008
>Oldest transaction 325
>Oldest active 326
>Oldest snapshot 326
>Next transaction 21455
>Attributes force write, no reserve
>Sweep interval: 0
Regards,
Bogdan
[Non-text portions of this message have been removed]