Subject Re: scalability how to?
Author Photios Loupis (4T)
--- In, "Richard Salt"
<Richard.Salt@q...> wrote:
> Does anyone have any suggestions on how to take the guesswork out
of scaling/load balancing the number of databases/connections per
Firebird server?
> We currently have 60 fdb's with a potential of 150 connections
being serviced by one Firebird 1.5.1 (nptl) server running on a Linux
(Mandrake 10.0) box with 2GB ram. Our delphi apps use ibobjects: the
transaction objects are all set to tiCommited and we avoid long
transactions. It has been necessary to increase LockMemSize &
EventMemSize. It typically works well, but we do occasionally have
unexplained crashes.
> The number of databases & connections is growing each month and I
am mindful of if/when to balance the load onto another physical
> I have written scripts that log the fbserver's processor and memory
useage, but this seems fairly meaningless without knowing the useage
patterns of the users. Is there any Firebird monitoring software that
might help?
> Best Regards
> Richard Salt
> UK

Hi Richard

We too are experiencing a similar problem (see earlier posting in the
group). We have a large number of concurrent connections and
periodically 70% of the connections get EXTREMELY active. This
causes our processor utilisation to go through the roof.

I am interested in the settings you have used for LockMemSize &
EventMemSize, please could you elaborate on your findings with these

Thanx in advance