Subject | Why not sweeping? |
---|---|
Author | fdt4y |
Post date | 2012-07-10T09:31:23Z |
I have 20+ databases in production, most of them between 3 and 8GB with no BLOBs. My problem seems to be that sweeping is not executing when I either perform a full backup or doing full table scans. Below is the gstat header info and as you can clearly see that it should have kicked in long ago. We are running classic mode V2.5. Can I see and output/error messages for sweeping?
What are we overlooking? Our only current solution is to do a full backup and restore at silly morning hours, otherwise the system grows terribly slow due to garbage not being collected.
Database header page information:
Flags 0
Checksum 12345
Generation 50327462
Page size 8192
ODS version 11.2
Oldest transaction 460
Oldest active 461
Oldest snapshot 461
Next transaction 50325450
Bumped transaction 1
Sequence number 0
Next attachment ID 2006
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 3, 2012 23:07:46
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Analyzing database pages ...
RPLRESULTS (259)
Primary pointer page: 475, Index root page: 476
Average record length: 32.29, total records: 15044
Average version length: 9.10, total versions: 20554673, max versions: 6768
Data pages: 70750, data page slots: 70750, average fill: 93%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 70749
What are we overlooking? Our only current solution is to do a full backup and restore at silly morning hours, otherwise the system grows terribly slow due to garbage not being collected.
Database header page information:
Flags 0
Checksum 12345
Generation 50327462
Page size 8192
ODS version 11.2
Oldest transaction 460
Oldest active 461
Oldest snapshot 461
Next transaction 50325450
Bumped transaction 1
Sequence number 0
Next attachment ID 2006
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 3, 2012 23:07:46
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Analyzing database pages ...
RPLRESULTS (259)
Primary pointer page: 475, Index root page: 476
Average record length: 32.29, total records: 15044
Average version length: 9.10, total versions: 20554673, max versions: 6768
Data pages: 70750, data page slots: 70750, average fill: 93%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 70749