| Subject | Re: [firebird-support] FB 1.5 server sluggish after been up for awhile |
|---|---|
| Author | |
| Post date | 2015-05-25T00:32:52Z |
Thank you for your reply. Here is what I got after running gstat -h before and after backup restore.
Before backup/restore
Database "d:\data\POS\cfbdbcopy.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 31599023
Page size 8192
ODS version 10.1
Oldest transaction 27879204
Oldest active 27879205
Oldest snapshot 10427673
Next transaction 31599017
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Apr 25, 2015 23:39:50
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
After backup/restore
Database "d:\data\POS\cfbdbcopy.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 24775
Page size 8192
ODS version 10.1
Oldest transaction 8857
Oldest active 8858
Oldest snapshot 8857
Next transaction 24769
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date May 24, 2015 6:44:11
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Look at the freshly restore DB Oldest active transaction and Next transaction counters, I don't understand why such gap. We just restored the database and run some ibExpert queries.
Thank you,
-Halim