Subject Re: Firebird v2 CPU Pegged
Author slalom91
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
>
> At 07:34 PM 12/12/2006, you wrote:
> >You may want to try changing the garbage collection policy to
> >'cooperative' in firebird.conf and see if that makes a difference,
> >that's how 1.5 used to do things.
>
> Err..not quite. Superserver 1.5 didn't do cooperative GC; the new
> settings allow it as an option or in combination with the
background
> GC that v.1.0 and 1.5 Superserver use. (The policy setting doesn't
> apply to Classic: it can only do cooperative).
>
> V.2.0 defaults to the combined policy. It would be worthwhile
trying
> one or the other on its own to see whether there's an
> improvement. But, to be clear, background, not cooperative, gets
you
> back to the 1.5 Superserver policy.
>
> >Don't forget to restart the server process.
>
> Amen. :-)
>
> ./heLen
>
I did try manipulating this setting to each of the allowed values and
it did not work. After reading Dennis's post titled "Issue: deadlock
with Firebird and Delphi. ref/eDN7002040583", I am sure we are
experiencing the same problem.