| Subject | AW: [firebird-support] How to interprete gstat-results |
|---|---|
| Author | Checkmail |
| Post date | 2016-04-14T12:23:24Z |
Hello Thomas..
Database "D:\INTERBASE\IFLS.GDB"
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
*END*
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Donnerstag, 14. April 2016 14:03
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] How to interprete gstat-results
> Hello @ll,
>Please post an entire gstat -h output.
>
>
> 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?
--
With regards,
Thomas Steinmaurer
http://www.upscene.com
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.