Subject AW: [firebird-support] How to interprete gstat-results
Author Checkmail

Hello Thomas..




Database header page information:

        Flags                   0

        Generation              2939162

        System Change Number    0

        Page size               4096

        ODS version             12.0

        Oldest transaction      2893677

        Oldest active           2929833

        Oldest snapshot         2878316

        Next transaction        2938824

        Sequence number         0

        Next attachment ID      87910

        Implementation          HW=Intel/i386 little-endian OS=Windows CC=MSVC

        Shadow count            0

        Page buffers            0

        Next header page        0

        Database dialect        3

        Creation date           Mar 7, 2016 18:33:37

        Attributes              force write


    Variable header data:

        Sweep interval:         5000





Von: []
Gesendet: Donnerstag, 14. April 2016 14:03
Betreff: Re: [firebird-support] How to interprete gstat-results



> Hello @ll,

> we are using firebird 3.0 RC2 and have some questions about open
> transactions. (Clients connect over odbc) The gstat output gives 70000
> transactions between the oldest and the current transaction, if we look into
> the monitoring table, we see only 10 transactions. The "oldest one" we
> cannot find in this table. What is the oldest transaction and which roll
> does the garbage collector play? If we have many open transactions, the
> performance is bad. What role plays the attachments? What is the best way to
> check the performance bottleneck in such cases?

Please post an entire gstat -h output.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.