About 20 databases





Atenciosamente,

Rudi Feijó


Multidados Informática Ltda.
* (11) 2579-8794 / 2579-8795
* <mailto:ariane.cutlac@...> rudi.feijo@...
* <http://www.multidadosti.com.br/> www.multidadosti.com.br
<http://www.timesheet.com.br/> www.timesheet.com.br



From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: sexta-feira, 18 de agosto de 2017 11:56
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Firebird 3 crashes ( terminated abnormally (4294967295) )

> >What is the size of the database pages?
> >Have you checked the DB level Page Cache setting (the DB can have a
> different value from the config)?
> >How much RAM is available for the VM?
>
> Sean, theres 13gb of RAM, and no db with specific settings
> Page size is 16k

Ok, so a single database you are not "over subscribing" RAM.

> >*EACH DATABASE* will be consuming up to (50000 * page size) on cache.
> >Why do you set DefaultDbCachePages so high???? The Firebird server
> >needs RAM for more things than just the cache.
>
> Helen, pages are high only because I copied the suggested values from the
> config at https://ib-aid.com/br/optimized-firebird-configuration/
> Since it is the first time we're using superserver we went for these
> recommended settings.
> Isn't the page cache shared in this mode on firebird 3 (50000 pages for all dbs) ?

No, *DB* Page Cache is per database.

How many databases are you hosting on the system?









<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient>

Livre de vírus. <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient> www.avg.com.





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