Subject | Re: Update: CPU Pegged on Firebird v2 |
---|---|
Author | slalom91 |
Post date | 2006-12-13T20:20:16Z |
I have identified the application that was holding a transaction
handle open and have corrected it.
Question:
How would that have affected or caused the behavior I was
experiencing with v2? My sweep interval is set to 0 and I had tried
using each of the possible options for the garbage collector?
New database statistics info:
Database header page information:
Flags 0
Checksum 12345
Generation 377780
Page size 4096
ODS version 10.1
Oldest transaction 9677
Oldest active 377749
Oldest snapshot 377749
Next transaction 377773
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 1
Creation date Dec 11, 2006 12:29:47
Attributes no reserve
Variable header data:
Sweep interval: 0
*END*
handle open and have corrected it.
Question:
How would that have affected or caused the behavior I was
experiencing with v2? My sweep interval is set to 0 and I had tried
using each of the possible options for the garbage collector?
New database statistics info:
Database header page information:
Flags 0
Checksum 12345
Generation 377780
Page size 4096
ODS version 10.1
Oldest transaction 9677
Oldest active 377749
Oldest snapshot 377749
Next transaction 377773
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 1
Creation date Dec 11, 2006 12:29:47
Attributes no reserve
Variable header data:
Sweep interval: 0
*END*