Subject | How to interprete gstat-results |
---|---|
Author | Checkmail |
Post date | 2016-04-14T11:59:47Z |
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?
Thank you
Regards
Olaf