Re: [firebird-support] Firebird using all available memory

Hi Fabiano! Perhaps Debian is trying to put in cache your database file and this file cache is competing for the available memory with the page cache of Firebird.  In Firebird 2.5(unfortunately I don't know Firebird 3) the parameters to control the comsuption of memory for the file cache are:

Re: [firebird-support] Firebird using all available memory

Do you have several Firebird installations(instances) in the same machine?Perhaps firebird is reading a different firebird.conf.  Why don't you post your complete firebird.conf? On Wednesday, May 23, 2018, 9:29:30 AM CDT, Fabiano Bonin fabiano.bo...@personalsoft.com.br [firebird-support]

[firebird-support] Doubts about Firebird in Linux....

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 I am planning to change the operating system that hosts our ERP's Firebird Databases from Windows Server 2012R2 to Linux and I have some questions about it: - Which Linux distribution do you recommend? I have experience

Re: [firebird-support] Re: Doubt about TempCacheLimit parameter...

Thank you very much! On Wednesday, May 16, 2018, 7:01:14 AM CDT, Dmitry Yemanov dim...@users..sourceforge.net [firebird-support] wrote:   16.05.2018 07:05, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server

[firebird-support] Doubt about TempCacheLimit parameter...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 What is the unit of TempCacheLimit? Thanks in advance

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Thank you for your help. It was very helpful! On Sunday, May 13, 2018, 12:50:26 AM CDT, Helen Borrie hele...@iinet.net.au [firebird-support] wrote:   Javier wrote: > > Ok, but how do I restore the statistics? Using "update" statements? You do not

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Ok, thank you very much! On Saturday, May 12, 2018, 11:42:52 AM CDT, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote:   Hi, i do not suppose that this is possible and especially that you should do this. Better then look at

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Ok, but how do I restore the statistics?  Using "update" statements? Thanks in advance for your help.  On Saturday, May 12, 2018, 1:19:10 AM CDT, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote:   Hi, to "backup" statistics you

[firebird-support] Doubts regarding statistics of indexes and tables...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 In firebird, how do you calculate statistics to feed the query optimizer?  Note: I know that the command: 'set statistics index ;' calculate statistics for indexes, but what about tables for example? And my second question: is

Re: [firebird-support] Re: Limit of the page cache buffer in Firebird 2.5?

Thank you very much! On Wednesday, May 9, 2018, 2:57:26 AM CDT, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote:   08.05.2018 20:50, Javier Cintron wrote: > Firebird ver 2.5.7.27050 64 bits > Superserver > Windows Server

[firebird-support] Limit of the page cache buffer in Firebird 2.5?

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 This link (Set Database Page Buffers) : | | | | | | | | | | | Set Database Page Buffers | | | Says that the maximum size of the page cache buffer is  131,072 pages.  This limit also applies to Firebird 2.5 x64

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

So, these are the maintenance actions that I am going to perform every night(I have a gap between 1am and 7 am):  - In the main server - Backup using gbak.  - Restart o of the database to get rid of long transactions - Sweep. - In the backup server - Restore of

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

What I mean is this: I want to know if a need to increment the page cache buffer of Firebird. And If was thinking of having some metric to measure it.  This metric would be very convinient If I need for example to justify buying more memory for the server. Thanks in advance. 

[firebird-support] What regular maintenance actions does Firebird need in order to function properly?

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 Besides, backing up my databases and measuring the effectiveness of the page cache, what other regular maintenance actions does Firebird need in order to function properly? thanks in advance

Re: [firebird-support] Proper way to handle an open Firebird database...

Thank you On Thursday, May 3, 2018, 10:07:21 AM CDT, Stefan Heymann li...@stefanheymann.de [firebird-support] wrote:   > When I need to copy my Firebird database: Do I need to shutdown the > Firebird instance first? Yes. Becaus when you don't do

Re: [firebird-support] Proper way to handle an open Firebird database...

to restart the server, Do I need to shutdown Firebird first? Thanks in advance On Thursday, May 3, 2018, 9:22:38 AM CDT, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote:   On 3-5-2018 16:11, Javier Cintron fcintr...@yahoo.com [fi

[firebird-support] Proper way to handle an open Firebird database...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 I have two questions: - When I need to copy my Firebird database: Do I need to shutdown the Firebird instance first? and If yes, what is the proper way to shutdown and startup it? - When I need to restart Windows Server,

Re: [firebird-support] Measure the effectiveness of incrementing page buffer...

Thank you very much!On Thursday, May 3, 2018, 3:30:32 AM CDT, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> wrote:   03.05.2018 7:56, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote: > Firebird ver 2.5.7.2705

[firebird-support] Measure the effectiveness of incrementing page buffer...

Firebird ver 2.5.7.27050 64 bitsWindows Server 2012R2 ¿Is there a way to calculate the effectiveness of incrementing the page cache buffer ? thanks in advance