RE: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
> >>> 3.0.1 hasn't been released yet, but snapshot builds are available here: > >>> http://www.firebirdsql.org/en/snapshot-builds/ > >>> > >> > >> the link is dead > > > > Works here. I get the entry page regarding snapshot builds for all > > branches and Windows/Linux. Anyway ... ;-) > > > >> http://web.firebirdsql.org/download/snapshot_builds/win/3.0 The link is back up and running Sean
Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
Dimitry Thanks, it works 100%, Cheers, Fabian - Original Message - From: Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, June 02, 2016 11:17 PM Subject: Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small? 02.06.2016 15:12, fabia...@itbizolutions.com.au [firebird-support] wrote: > the limit remains as in FB 2.5, meaning you cannot enter a value above 131071 pages , now > I don't know if the bug is on IBExpert, or if Firebird 3.0 rejects the value. Try gfix and you'll see. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
Anto Could you let me know how you setup the DB cache value? I mean what tool or sentence are you using to set it and then check it, because I am having trouble setting the value above 131071 pages with IBexpert, probably an IBExpert bug, but I just want to be sure it is not something else, Thanks Fabian - Original Message - From: trsk...@yahoo.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Thursday, June 02, 2016 6:03 PM Subject: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small? Dear all, Sorry, I have miscalculated the setting in DefaultDbCachePages, it was set more than available RAM on my Computer, no wonder it crashed. Now, everything is OK, tested on SS FB 3.0 in Win64. Thanks for your helps, Best regards, Anto.
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
Dear all, Sorry, I have miscalculated the setting in DefaultDbCachePages, it was set more than available RAM on my Computer, no wonder it crashed. Now, everything is OK, tested on SS FB 3.0 in Win64. Thanks for your helps, Best regards, Anto.
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
> ---In firebird-support@yahoogroups.com,wrote : >> Setting DefaultDbCachePages more than allowed caused a crashed. > Try a v3.0.1 snapshot build, IIRC it was fixed recently. If you mean CORE-5240 - it was a bug in v 2.5 only, i.e. v3 is not affected Regards, Vlad
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
> ---In firebird-support@yahoogroups.com,wrote : > > Hi guys, > > Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in > Win64 is only 2 GB? > Calculated from max DefaultDbCachePages (131072) x max Page Size (16384) = 2 > GB. No. This is limit for 32-bit builds (and it is the same as in v2.5, btw) > Setting DefaultDbCachePages more than allowed caused a crashed. Reproducible example, please. I work with cache of 12GB with no issues for a few years since v2.5 > If this true, how to optimaze free RAM for performance? File system cache already used "free RAM", don't worry ;) Regards, Vlad
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >>> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: >>> Where I can download v3.0.1 ? >>> >>> 3.0.1 hasn't been released yet, but snapshot builds are available here: >>> http://www.firebirdsql.org/en/snapshot-builds/ >>> >> >> the link is dead > > Works here. I get the entry page regarding snapshot builds for all branches > and Windows/Linux. Anyway ... ;-) > >> http://web.firebirdsql.org/download/snapshot_builds/win/3.0 > > > Thomas > (www.) me too :-). but the final address (web.firebirdsql.org) is currently dead from Finland and Germany -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : >> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: >> >>> Where I can download v3.0.1 ? >> >> 3.0.1 hasn't been released yet, but snapshot builds are available here: >> http://www.firebirdsql.org/en/snapshot-builds/ >> > > the link is dead Works here. I get the entry page regarding snapshot builds for all branches and Windows/Linux. Anyway ... ;-) > http://web.firebirdsql.org/download/snapshot_builds/win/3.0 Thomas
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit : > trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: > >> Where I can download v3.0.1 ? > > 3.0.1 hasn't been released yet, but snapshot builds are available here: > http://www.firebirdsql.org/en/snapshot-builds/ > the link is dead http://web.firebirdsql.org/download/snapshot_builds/win/3.0 -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44: > Where I can download v3.0.1 ? 3.0.1 hasn't been released yet, but snapshot builds are available here: http://www.firebirdsql.org/en/snapshot-builds/ -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?
02.06.2016 03:44, trsk...@yahoo.com wrote: > > Am I correct that maximum allowed RAM for database cache on SS FB 3.0 in > Win64 is only 2 GB? Calculated from max DefaultDbCachePages (131072) x > max Page Size (16384) = 2 GB. Correct for 32-bit builds. 64-bit builds don't have such a limit. > Setting DefaultDbCachePages more than allowed caused a crashed. Try a v3.0.1 snapshot build, IIRC it was fixed recently. Dmitry