Re: [Firebird-docs] gstat OST - OIT and Sweep
Hi Norman, no problem. I just had some problems to understand it right. It was formulated a bit strange. At the end of the part I didn’t know if the statement was right or wrong (or whatever). ;-) Regards Martin ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Oh dear, I wrote that! Originally, if I remember correctly, I might have mentioned that the sweep would be started when OAT - OIT was greater than the sweep interval. This was s I had seen in books, online, etc. Vlad, complained to me that I had written wrongly, and that the sweep would be started when OST - OIT was greater than the sweep interval. OAT = Oldest Active Transaction. OIT = Oldest Interesting Transaction. OST = Oldest Snapshot Transaction. Cheers, Norm. -- Sent from my Android device with K-9 Mail. Please excuse my brevity.___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [FirebirdSQL/firebird-documentation] 9cdda6: German translation of gstat. Version 1.6-de
Branch: refs/heads/master Home: https://github.com/FirebirdSQL/firebird-documentation Commit: 9cdda66c3b89c4e6dddef8b8edb366e68c84456b https://github.com/FirebirdSQL/firebird-documentation/commit/9cdda66c3b89c4e6dddef8b8edb366e68c84456b Author: Martin Köditz Date: 2020-07-31 (Fri, 31 Jul 2020) Changed paths: A src/docs/asciidoc/de/firebirddocs/gstat/firebird-gstat-de.adoc Log Message: --- German translation of gstat. Version 1.6-de ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Martin, <> Note The automatic sweep is kicked off if the difference between OST (Oldest Snapshot Transaction) and OIT is greater than the sweep interval defined. The user's process that tried to start the transaction that exceeds the sweep interval by one will sweep the entire database before actually starting the transaction they requested. From: https://www.ibphoenix.com/resources/documents/search/doc_67 Regards Paul ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] gstat OST - OIT and Sweep
Hello Martin, I spoke with Vlad about section devoted to garbage, and we agreed it is difficult. I plan to rewrite it with pictures explaining records versions, garbage and sweep, but it really needs courage :) I suggest to let ost-oit phrases as is. Regards, Alexey Kovyazin IBSurgeon пт, 31 июл. 2020 г., 12:56 Köditz, Martin : > Hi, > > > > I’m currently working on gstat-de. I struggled with following part: > > > > Many web sites, books, manuals (previously including this one) explain > that the automatic sweep is activated when OAT - OIT is greater than the > sweep interval. > > This is _not_ the case as explained by Vlad Khorsun, one of the Firebird > developers, who explained that it is when OST -- OIT is greater than the > threshold that the sweep is activated. > > > > What does the last sentence exactly mean? Can someone „tidy“ it? > > > > Regards > > Martin > ___ > Firebird-docs mailing list > Firebird-docs@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-docs > ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] gstat OST - OIT and Sweep
Hi, I’m currently working on gstat-de. I struggled with following part: Many web sites, books, manuals (previously including this one) explain that the automatic sweep is activated when OAT - OIT is greater than the sweep interval. This is _not_ the case as explained by Vlad Khorsun, one of the Firebird developers, who explained that it is when OST -- OIT is greater than the threshold that the sweep is activated. What does the last sentence exactly mean? Can someone „tidy“ it? Regards Martin ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [FirebirdSQL/firebird-documentation] 0d89d9: German translation of fb-shell-scripts. Version 1....
Branch: refs/heads/master Home: https://github.com/FirebirdSQL/firebird-documentation Commit: 0d89d9d9cc215d63eecc3762d1039db9645c595f https://github.com/FirebirdSQL/firebird-documentation/commit/0d89d9d9cc215d63eecc3762d1039db9645c595f Author: Martin Köditz Date: 2020-07-31 (Fri, 31 Jul 2020) Changed paths: A src/docs/asciidoc/de/firebirddocs/fb-shell-scripts/firebird-shell-scripts-de.adoc Log Message: --- German translation of fb-shell-scripts. Version 1.3-de ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs