>> From: firebird-support@yahoogroups.com [mailto:firebird- >> supp...@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?
> About 20 databases First, please don't top post. At 20 database, with each database having 50,000 pages allocated (needing 800 MB each) you would need at least 16GB just for FB DB caches. Change your default/config cache setting to 25,000 pages, if you need more for specific database(s) set the cache on a per database basis. Sean
