Just curious (sorry about the OT comment here), but what kind of cluster
are you running? Just fail-over?

-steve

On Thu, 2005-07-14 at 16:00 +1000, Maurice Ling wrote:

> Hi everyone,
>
> I need help here.
>
> I've been battling with my system administrator on Firebird CPU load,
> apparently, it is exceedingly high. I am using CS on Red Hat Linux on
> a
> cluster. The script that uses Firebird is in Python, using
> KinterbasDB.
> I've ran my script for a few minutes and using "top", this is my
> comparison of load...
>
> 29381 mling 15 0 48648 44m 2980 S 1.7 1.1 0:32.24 python
> 29383 firebird 20 0 289m 74m 10m R 83.6 1.8 3:46.62
> fb_inet_server
>
> The script only runs using 1.7% CPU but fb_inet_server uses 83.6% CPU.
> I
> can understand if FB's CPU usage is in spikes during DB access but it
> is
> not, 0:32.24 python versus 3:46.62 fb_inet_server.
>
> Any idea what may be happening?
>
> Page size is 4KB and buffer is set to 65365 (I cannot go any higher).
>
> If I run multiple scripts, I can use 3x99.9% CPU for the whole day
> and
> I'm having hell from my system administrator.
>
> Please help.
>
> Cheers
> Maurice
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>


[Non-text portions of this message have been removed]