Re: [firebird-support] Firebird 2.5 transaction counters

2019-04-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-4-2019 23:59, eadbha...@yahoo.com.mx [firebird-support] wrote: > I am sharing the gstat results for one of our databases below. Can > anyone please help on how far or close we are of reaching the > transaction counter limits of Firebird 2.5 please. > > Database header page information: >

Re: [firebird-support] Firebird 2.5 transaction counters

2019-04-26 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
HiYou are in the half way (1031734200) as tr counter in FB2.5 is 32int.P.S. you have some long running transaction which block garbage collector and degrade performance. Look into mon$transactions for oldest one.Regards,Karol Bieniaszewski null

[firebird-support] Firebird 2.5 transaction counters

2019-04-25 Thread eadbha...@yahoo.com.mx [firebird-support]
Hi there, I am sharing the gstat results for one of our databases below. Can anyone please help on how far or close we are of reaching the transaction counter limits of Firebird 2.5 please. Database header page information: Flags0 Checksum12345