My Firebird 2.0 Superserver on Linux 64 dual opteron is also jumping to 100%
on 1 processor, and moving between processors every 10 seconds, however
everything works fine apart from the CPU being killed.

Fabian

----- Original Message -----
From: "Gary Benade" <gary@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, December 13, 2006 4:59 PM
Subject: Re: [firebird-support] Re: Update: CPU Pegged on Firebird v2


> >Yes, I've considered it, but I know this is not the case. Subsequent
>>threads running the same query post their data just fine. Even though
>>it is slow, because a previous thread has caused the deadlock problem
>
> Sorry to keep hammering on about this, but that sounds like garbage
> collection. The thread that triggers the GC process is kept busy and will
> not return results until the process is done, any subsequent threads will
> run just fine, although obviously slower due to the server workload of the
> GC thread.
> Could you let us know what your sweep interval is set to and post your
> header page stats.
>
> Regards
> Gary
>
>
> [Non-text portions of this message have been removed]
>
>