Subject | Re: Large database performance on Firebird 1.5.2 CS with 130+ clien |
---|---|
Author | lins_kun |
Post date | 2005-03-24T17:58:39Z |
--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@o...>
wrote:
I've created a script that do a monitoring of FireBird Number of
Process and Firebird ram used.
It don't use all RAM, it use very few RAM.
If i remember Page Buffers 0 Mean that it don't do a Buffers of query
(in other word it is disabled by default)
wrote:
> lins_kun wrote:130
> > ...
> >
> > No, the DB is used alway under ClassicServer
> >
> >
> > Database header page information:
> > Flags 0
> > Checksum 12345
> > Generation 11824495
> > Page size 8192
> > ODS version 10.1
> > Oldest transaction 11820752
> > Oldest active 11824393
> > Oldest snapshot 11824393
> > Next transaction 11824395
> > Bumped transaction 1
> > Sequence number 0
> > Next attachment ID 0
> > Implementation ID 19
> > Shadow count 0
> > Page buffers 0
> > Next header page 0
> > Database dialect 3
> > Creation date Dec 24, 2004 13:04:10
> > Attributes
> >
>
>
> I don't remember the default number of page buffers, but multiplying
> users with 8KB page size and number of buffer pages -130x8xBufferSize (in
> KB) - may indicate if there is enough RAM (sorts may need additionalRAM).
> Otherwise, the statistics looks ok. (But I never used ClassicServeror Linux)
I've created a script that do a monitoring of FireBird Number of
Process and Firebird ram used.
It don't use all RAM, it use very few RAM.
If i remember Page Buffers 0 Mean that it don't do a Buffers of query
(in other word it is disabled by default)