RE: [firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> >>> 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?

[fabia...@itbizolutions.com.au [firebird-support]]

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?

[fabia...@itbizolutions.com.au [firebird-support]]

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?

[trsk...@yahoo.com [firebird-support]]

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?

[hv...@users.sourceforge.net [firebird-support]]

 > ---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?

[hv...@users.sourceforge.net [firebird-support]]

> ---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?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'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]]

> '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?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'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?

['Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]]

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?

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

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