Subject | [ib-support] Automatic garbage collection? |
---|---|
Author | Omar Estepa |
Post date | 2001-10-26T09:37:26Z |
Hi,
We was having problems with our Linux database server (about 6 GB,
IBSS_LI-V6.0), it seems to be overloaded by garbage collection (after mass
deletion, I think). No problem, I go to our backup/restore daily script and
add the "-g" option to gbak commands and it works fine. The database check
tells me everything is OK and backups works fine (with "-g").
But few days later we have de same problem, the server slows down again
(100% CPU time usage) when the users was working (no backup/restore process
was running at this time). Auto-sweep is turned off.
Can the IB server automatically run the garbage collection? If it can, can I
dissable this feature? Does anybody have another idea?
Omar
[Non-text portions of this message have been removed]
We was having problems with our Linux database server (about 6 GB,
IBSS_LI-V6.0), it seems to be overloaded by garbage collection (after mass
deletion, I think). No problem, I go to our backup/restore daily script and
add the "-g" option to gbak commands and it works fine. The database check
tells me everything is OK and backups works fine (with "-g").
But few days later we have de same problem, the server slows down again
(100% CPU time usage) when the users was working (no backup/restore process
was running at this time). Auto-sweep is turned off.
Can the IB server automatically run the garbage collection? If it can, can I
dissable this feature? Does anybody have another idea?
Omar
[Non-text portions of this message have been removed]