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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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:
FileSystemCacheSizeFileSystemCacheThreshold

On Thursday, May 24, 2018, 8:30:09 AM CDT, Fabiano Bonin 
fabiano.bo...@personalsoft.com.br [firebird-support] 
 wrote:  
 
     

Hi, Omacht!
Indeed, it needs a sweep.
There a scheduled script that runs every night to sweep the database, and it 
broke with FB3 upgrade.
I fixed the script and it will run this night.
But, do you think the memory exaustion can be related to this issue?
Regards,
Fabiano




2018-05-24 2:47 GMT-03:00 Omacht András aoma...@mve.hu [firebird-support] 
:

     
Hi Fabiano!

You should run garbage collection (sweep).


 Oldest transaction 905
 Oldest active 62303005
 Oldest snapshot 62303005
 Next transaction 62382577
András

OMACHT ANDRÁS
fejlesztési igazgató

[cid:image001.png@01CFE703. C881C660]
Libra Szoftver Zrt.
1113 Budapest, Karolina út 65.
Tel.: +36 1 255 3939
Fax: +36 1 209 1477
http://www.libraszoftver.hu

From: firebird-support@yahoogroups. com [mailto:firebird-support@ 
yahoogroups..com]
Sent: Wednesday, May 23, 2018 4:29 PM
To: firebird-support@yahoogroups. com
Subject: Re: [firebird-support] Firebird using all available memory


Hi, Thomas. It is zero. I presume in this case it uses the system default, 
right?

Regards,

Fabiano

Database header page information:
 Flags 0
 Generation 62390727
 System Change Number 0
 Page size 4096
 ODS version 12.0
 Oldest transaction 905
 Oldest active 62303005
 Oldest snapshot 62303005
 Next transaction 62382577
 Sequence number 0
 Next attachment ID 1290314
 Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
 Shadow count 0
 Page buffers 0
 Next header page 0
 Database dialect 3
 Creation date Apr 4, 2018 7:03:44
 Attributes force write


[A képet a feladó eltávolította.]

2018-05-22 18:30 GMT-03:00 'Thomas Kragh-Pedersen (TKG)' 
t...@kmd.dk [firebird-support] 
>:

Hey Fabiano
Perhaps DefaultDbCachePages is overwritten by database header information. 
Gstat -h will tell you that. Look for “Page buffers”


From: firebird-support@yahoogroups. com >
Sent: 18. maj 2018 16:12
To: firebird-support@yahoogroups. com
Subject: [firebird-support] Firebird using all available memory


Hi,

I have a Debian 9 Linux server with 8GB of memory, a database with 30GB, page 
size 4KB, and Firebird 3.0.3 running in superserver mode and about 150-200 
concurrent connections.

In my firebird.conf I have changed the following properties:

DefaultDbCachePages = 524288 # 2GB
TempCacheLimit = 1024M # 1GB
LockMemSize = 2M

As superserver uses a shared cache, I presumed the total used memory should 
stay between 3GB and 4GB, but it keeps growing during the day until it reaches 
the 8GB limit and Firebird shuts down with this message:

debian Fri May 18 10:45:35 2018
 Shutting down the server with 150 active connection(s) to 2 database(s), 0 
active service(s)

I am checking the active transactions during the day, and altought there are 
some old (2h to 3h) active transactions, I don't that an old active transaction 
should cause this, but I am reporting anyway, maybe it is relevant.

Do someone have some advice to what should I do to prevent this from happening?

Maybe my understanding about how Firebird uses memory is incorrect, so any 
advice about how I should calculate the required amount of memory needed is 
welcome.

PS: I have migrated from FB 2.5 recently (previously I did use superclassic 
mode), and these problems started after the migration.

Regards,

Fabiano

Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis 
du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere 
afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette 
e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og 
ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre 
fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og 
læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar 
for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen.

Please note that this message may contain confidential information. If you have 
received this message by mistake, please inform the sender of the mistake by 
sending a reply, then delete the message from your system without making, 
distributing or retaining any copies of it. Although we believe that 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 
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] 
 wrote:  
 
     

Hi, Thomas. It is zero. I presume in this case it uses the system default, 
right?

Regards,
Fabiano

Database header page information:
    Flags   0
    Generation  62390727
    System Change Number    0
    Page size   4096
    ODS version 12.0
    Oldest transaction  905
    Oldest active   62303005
    Oldest snapshot 62303005
    Next transaction    62382577
    Sequence number 0
    Next attachment ID  1290314
    Implementation  HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
    Shadow count    0
    Page buffers    0
    Next header page    0
    Database dialect    3
    Creation date   Apr 4, 2018 7:03:44
    Attributes  force write





2018-05-22 18:30 GMT-03:00 'Thomas Kragh-Pedersen (TKG)' t...@kmd.dk 
[firebird-support] :

     


Hey Fabiano

PerhapsDefaultDbCachePages is overwritten by database header information. Gstat 
-h will tell you that. Look for “Page buffers”

 

 

From: firebird-support@yahoogroups. com 
Sent: 18. maj 2018 16:12
To: firebird-support@yahoogroups. com
Subject: [firebird-support] Firebird using all available memory

 

  

Hi,

 

I have a Debian 9 Linux server with 8GB of memory, a database with 30GB, page 
size 4KB, and Firebird 3.0.3 running in superserver mode and about 150-200 
concurrent connections.

 

In my firebird.conf I have changed the following properties:

 

DefaultDbCachePages = 524288 # 2GB

TempCacheLimit = 1024M # 1GB

LockMemSize = 2M

 

As superserver uses a shared cache, I presumed the total used memory should 
stay between 3GB and 4GB, but it keeps growing during the day until it reaches 
the 8GB limit and Firebird shuts down with this message:

 

debian  Fri May 18 10:45:35 2018
    Shutting down the server with 150 active connection(s) to 2 
database(s), 0 active service(s)

 

I am checking the active transactions during the day, and altought there are 
some old (2h to 3h) active transactions, I don't that an old active transaction 
should cause this, but I am reporting anyway, maybe it is relevant.

 

Do someone have some advice to what should I do to prevent this from happening?

 

Maybe my understanding about how Firebird uses memory is incorrect, so any 
advice about how I should calculate the required amount of memory needed is 
welcome.

 

PS: I have migrated from FB 2.5 recently (previously I did use superclassic 
mode), and these problems started after the migration.

 

Regards,

 

Fabiano



Vi gør opmærksom på, at denne e-mail kan indeholde fortrolig information. Hvis 
du ved en fejltagelse modtager e-mailen, beder vi dig venligst informere 
afsender om fejlen ved at bruge svarfunktionen. Samtidig beder vi dig slette 
e-mailen i dit system uden at videresende eller kopiere den. Selvom e-mailen og 
ethvert vedhæftet bilag efter vores overbevisning er fri for virus og andre 
fejl, som kan påvirke computeren eller it-systemet, hvori den modtages og 
læses, åbnes den på modtagerens eget ansvar. Vi påtager os ikke noget ansvar 
for tab og skade, som er opstået i forbindelse med at modtage og bruge e-mailen.

Please note that this message may contain confidential information. If you have 
received this message by mistake, please inform the sender of the mistake by 
sending a reply, then delete the message from your system without making, 
distributing or retaining any copies of it. Although we believe that the 
message and any attachments are free from viruses and other errors that might 
affect the computer or it-system where it is received and read, the recipient 
opens the message at his or her own risk. We assume no responsibility for any 
loss or damage arising from the receipt or use of this message..


   

  #yiv8758777567 #yiv8758777567 -- #yiv8758777567ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8758777567 
#yiv8758777567ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8758777567 
#yiv8758777567ygrp-mkp #yiv8758777567hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8758777567 #yiv8758777567ygrp-mkp #yiv8758777567ads 
{margin-bottom:10px;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad 
{padding:0 0;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad p 
{margin:0;}#yiv8758777567 #yiv8758777567ygrp-mkp .yiv8758777567ad a 
{color:#ff;text-decoration:none;}#yiv8758777567 #yiv8758777567ygrp-sponsor 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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 using Centos. 
   - Which Linux file system do you recommend? (ext3 ext4, etc) 
   - Do you recommend using a journaling file system?
   - One of the requirements is that the Firebird has to be 2.5.7.27050 but as 
of today the current version is 2.5.8.27089: is there a repository of past 
firebird versions?

Thanks in advance for your help

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 2012R2
> 
> What is the unit of TempCacheLimit?

Bytes. Settings > 4GB are not supported.

Dmitry


  #yiv9060775616 #yiv9060775616 -- #yiv9060775616ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9060775616 
#yiv9060775616ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9060775616 
#yiv9060775616ygrp-mkp #yiv9060775616hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9060775616 #yiv9060775616ygrp-mkp #yiv9060775616ads 
{margin-bottom:10px;}#yiv9060775616 #yiv9060775616ygrp-mkp .yiv9060775616ad 
{padding:0 0;}#yiv9060775616 #yiv9060775616ygrp-mkp .yiv9060775616ad p 
{margin:0;}#yiv9060775616 #yiv9060775616ygrp-mkp .yiv9060775616ad a 
{color:#ff;text-decoration:none;}#yiv9060775616 #yiv9060775616ygrp-sponsor 
#yiv9060775616ygrp-lc {font-family:Arial;}#yiv9060775616 
#yiv9060775616ygrp-sponsor #yiv9060775616ygrp-lc #yiv9060775616hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9060775616 
#yiv9060775616ygrp-sponsor #yiv9060775616ygrp-lc .yiv9060775616ad 
{margin-bottom:10px;padding:0 0;}#yiv9060775616 #yiv9060775616actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9060775616 
#yiv9060775616activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9060775616
 #yiv9060775616activity span {font-weight:700;}#yiv9060775616 
#yiv9060775616activity span:first-child 
{text-transform:uppercase;}#yiv9060775616 #yiv9060775616activity span a 
{color:#5085b6;text-decoration:none;}#yiv9060775616 #yiv9060775616activity span 
span {color:#ff7900;}#yiv9060775616 #yiv9060775616activity span 
.yiv9060775616underline {text-decoration:underline;}#yiv9060775616 
.yiv9060775616attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9060775616 .yiv9060775616attach div a 
{text-decoration:none;}#yiv9060775616 .yiv9060775616attach img 
{border:none;padding-right:5px;}#yiv9060775616 .yiv9060775616attach label 
{display:block;margin-bottom:5px;}#yiv9060775616 .yiv9060775616attach label a 
{text-decoration:none;}#yiv9060775616 blockquote {margin:0 0 0 
4px;}#yiv9060775616 .yiv9060775616bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9060775616 
.yiv9060775616bold a {text-decoration:none;}#yiv9060775616 dd.yiv9060775616last 
p a {font-family:Verdana;font-weight:700;}#yiv9060775616 dd.yiv9060775616last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9060775616 
dd.yiv9060775616last p span.yiv9060775616yshortcuts 
{margin-right:0;}#yiv9060775616 div.yiv9060775616attach-table div div a 
{text-decoration:none;}#yiv9060775616 div.yiv9060775616attach-table 
{width:400px;}#yiv9060775616 div.yiv9060775616file-title a, #yiv9060775616 
div.yiv9060775616file-title a:active, #yiv9060775616 
div.yiv9060775616file-title a:hover, #yiv9060775616 div.yiv9060775616file-title 
a:visited {text-decoration:none;}#yiv9060775616 div.yiv9060775616photo-title a, 
#yiv9060775616 div.yiv9060775616photo-title a:active, #yiv9060775616 
div.yiv9060775616photo-title a:hover, #yiv9060775616 
div.yiv9060775616photo-title a:visited {text-decoration:none;}#yiv9060775616 
div#yiv9060775616ygrp-mlmsg #yiv9060775616ygrp-msg p a 
span.yiv9060775616yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9060775616 
.yiv9060775616green {color:#628c2a;}#yiv9060775616 .yiv9060775616MsoNormal 
{margin:0 0 0 0;}#yiv9060775616 o {font-size:0;}#yiv9060775616 
#yiv9060775616photos div {float:left;width:72px;}#yiv9060775616 
#yiv9060775616photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv9060775616 
#yiv9060775616photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9060775616
 #yiv9060775616reco-category {font-size:77%;}#yiv9060775616 
#yiv9060775616reco-desc {font-size:77%;}#yiv9060775616 .yiv9060775616replbq 
{margin:4px;}#yiv9060775616 #yiv9060775616ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv9060775616 #yiv9060775616ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9060775616 
#yiv9060775616ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9060775616 
#yiv9060775616ygrp-mlmsg select, #yiv9060775616 input, #yiv9060775616 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9060775616 
#yiv9060775616ygrp-mlmsg pre, #yiv9060775616 code {font:115% 
monospace;}#yiv9060775616 #yiv9060775616ygrp-mlmsg * 
{line-height:1.22em;}#yiv9060775616 #yiv9060775616ygrp-mlmsg #yiv9060775616logo 
{padding-bottom:10px;}#yiv9060775616 #yiv9060775616ygrp-msg p a 
{font-family:Verdana;}#yiv9060775616 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 "restore the statistics". The statistic that gets updated
by a SET STATISTICS call is the selectivity of the index. Low value =
high selectivity = Good; high value = low selectivity = bad. The
value immediately after the call reflects the state of the index at
that point. So, at that point, the optimizer has the best chance to
prepare the most efficient plan by deciding which indexes will be the
most helpful.

After that, the actual condition of an index selected for the plan may
degrade gradually as rows are inserted and deleted. When you start to
notice a decline in the performance of queries over a table with a
high level of inserts and deletes, it is probably time to run SET
STATISTICS again. Selectivity is not static - it changes
infinitessimally with each insertion and deletion, or dramatically
with a major bulk insert or delete. Eventually, the statistic may
tend to become too outdated to obtain the same level of performance as
when the numbers were fresh.

The optimizer always calculates a plan based on the most recently
calculated statistics. What you can do is run the queries in isql with
SET PLANONLY while the statistics are fresh. That will tell you the
optimizer's choices based on the current selectivity and record count.

You can save that plan in a text file. If you decide from your test
results that you like it, you can copy it into your application
queries using the optional PLAN clause. If you supply a plan in your
select query, the optimizer will not try to create one. That might or
might not work positively over time, of course.

On the whole, the optimizer is going to produce the most effective
plan, since it is aware of the current size if the table and may be
able to make dynamic adjustments that your static plan cannot take
into account.

Hth.
Helen


  #yiv1957919616 #yiv1957919616 -- #yiv1957919616ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1957919616 
#yiv1957919616ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1957919616 
#yiv1957919616ygrp-mkp #yiv1957919616hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1957919616 #yiv1957919616ygrp-mkp #yiv1957919616ads 
{margin-bottom:10px;}#yiv1957919616 #yiv1957919616ygrp-mkp .yiv1957919616ad 
{padding:0 0;}#yiv1957919616 #yiv1957919616ygrp-mkp .yiv1957919616ad p 
{margin:0;}#yiv1957919616 #yiv1957919616ygrp-mkp .yiv1957919616ad a 
{color:#ff;text-decoration:none;}#yiv1957919616 #yiv1957919616ygrp-sponsor 
#yiv1957919616ygrp-lc {font-family:Arial;}#yiv1957919616 
#yiv1957919616ygrp-sponsor #yiv1957919616ygrp-lc #yiv1957919616hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1957919616 
#yiv1957919616ygrp-sponsor #yiv1957919616ygrp-lc .yiv1957919616ad 
{margin-bottom:10px;padding:0 0;}#yiv1957919616 #yiv1957919616actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1957919616 
#yiv1957919616activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1957919616
 #yiv1957919616activity span {font-weight:700;}#yiv1957919616 
#yiv1957919616activity span:first-child 
{text-transform:uppercase;}#yiv1957919616 #yiv1957919616activity span a 
{color:#5085b6;text-decoration:none;}#yiv1957919616 #yiv1957919616activity span 
span {color:#ff7900;}#yiv1957919616 #yiv1957919616activity span 
.yiv1957919616underline {text-decoration:underline;}#yiv1957919616 
.yiv1957919616attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1957919616 .yiv1957919616attach div a 
{text-decoration:none;}#yiv1957919616 .yiv1957919616attach img 
{border:none;padding-right:5px;}#yiv1957919616 .yiv1957919616attach label 
{display:block;margin-bottom:5px;}#yiv1957919616 .yiv1957919616attach label a 
{text-decoration:none;}#yiv1957919616 blockquote {margin:0 0 0 
4px;}#yiv1957919616 .yiv1957919616bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1957919616 
.yiv1957919616bold a {text-decoration:none;}#yiv1957919616 dd.yiv1957919616last 
p a {font-family:Verdana;font-weight:700;}#yiv1957919616 dd.yiv1957919616last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1957919616 
dd.yiv1957919616last p span.yiv1957919616yshortcuts 
{margin-right:0;}#yiv1957919616 div.yiv1957919616attach-table div div a 
{text-decoration:none;}#yiv1957919616 div.yiv1957919616attach-table 
{width:400px;}#yiv1957919616 div.yiv1957919616file-title a, #yiv1957919616 
div.yiv1957919616file-title a:active, #yiv1957919616 
div.yiv1957919616file-title a:hover, #yiv1957919616 div.yiv1957919616file-title 
a:visited {text-decoration:none;}#yiv1957919616 div.yiv1957919616photo-title a, 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 queries and addapt it to real situation.


Regards,Karol Bieniaszewski  #yiv2598329866 #yiv2598329866 -- 
#yiv2598329866ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv2598329866 #yiv2598329866ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv2598329866 #yiv2598329866ygrp-mkp #yiv2598329866hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv2598329866 #yiv2598329866ygrp-mkp #yiv2598329866ads 
{margin-bottom:10px;}#yiv2598329866 #yiv2598329866ygrp-mkp .yiv2598329866ad 
{padding:0 0;}#yiv2598329866 #yiv2598329866ygrp-mkp .yiv2598329866ad p 
{margin:0;}#yiv2598329866 #yiv2598329866ygrp-mkp .yiv2598329866ad a 
{color:#ff;text-decoration:none;}#yiv2598329866 #yiv2598329866ygrp-sponsor 
#yiv2598329866ygrp-lc {font-family:Arial;}#yiv2598329866 
#yiv2598329866ygrp-sponsor #yiv2598329866ygrp-lc #yiv2598329866hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2598329866 
#yiv2598329866ygrp-sponsor #yiv2598329866ygrp-lc .yiv2598329866ad 
{margin-bottom:10px;padding:0 0;}#yiv2598329866 #yiv2598329866actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2598329866 
#yiv2598329866activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2598329866
 #yiv2598329866activity span {font-weight:700;}#yiv2598329866 
#yiv2598329866activity span:first-child 
{text-transform:uppercase;}#yiv2598329866 #yiv2598329866activity span a 
{color:#5085b6;text-decoration:none;}#yiv2598329866 #yiv2598329866activity span 
span {color:#ff7900;}#yiv2598329866 #yiv2598329866activity span 
.yiv2598329866underline {text-decoration:underline;}#yiv2598329866 
.yiv2598329866attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv2598329866 .yiv2598329866attach div a 
{text-decoration:none;}#yiv2598329866 .yiv2598329866attach img 
{border:none;padding-right:5px;}#yiv2598329866 .yiv2598329866attach label 
{display:block;margin-bottom:5px;}#yiv2598329866 .yiv2598329866attach label a 
{text-decoration:none;}#yiv2598329866 blockquote {margin:0 0 0 
4px;}#yiv2598329866 .yiv2598329866bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2598329866 
.yiv2598329866bold a {text-decoration:none;}#yiv2598329866 dd.yiv2598329866last 
p a {font-family:Verdana;font-weight:700;}#yiv2598329866 dd.yiv2598329866last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2598329866 
dd.yiv2598329866last p span.yiv2598329866yshortcuts 
{margin-right:0;}#yiv2598329866 div.yiv2598329866attach-table div div a 
{text-decoration:none;}#yiv2598329866 div.yiv2598329866attach-table 
{width:400px;}#yiv2598329866 div.yiv2598329866file-title a, #yiv2598329866 
div.yiv2598329866file-title a:active, #yiv2598329866 
div.yiv2598329866file-title a:hover, #yiv2598329866 div.yiv2598329866file-title 
a:visited {text-decoration:none;}#yiv2598329866 div.yiv2598329866photo-title a, 
#yiv2598329866 div.yiv2598329866photo-title a:active, #yiv2598329866 
div.yiv2598329866photo-title a:hover, #yiv2598329866 
div.yiv2598329866photo-title a:visited {text-decoration:none;}#yiv2598329866 
div#yiv2598329866ygrp-mlmsg #yiv2598329866ygrp-msg p a 
span.yiv2598329866yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2598329866 
.yiv2598329866green {color:#628c2a;}#yiv2598329866 .yiv2598329866MsoNormal 
{margin:0 0 0 0;}#yiv2598329866 o {font-size:0;}#yiv2598329866 
#yiv2598329866photos div {float:left;width:72px;}#yiv2598329866 
#yiv2598329866photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv2598329866 
#yiv2598329866photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2598329866
 #yiv2598329866reco-category {font-size:77%;}#yiv2598329866 
#yiv2598329866reco-desc {font-size:77%;}#yiv2598329866 .yiv2598329866replbq 
{margin:4px;}#yiv2598329866 #yiv2598329866ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv2598329866 #yiv2598329866ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2598329866 
#yiv2598329866ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2598329866 
#yiv2598329866ygrp-mlmsg select, #yiv2598329866 input, #yiv2598329866 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv2598329866 
#yiv2598329866ygrp-mlmsg pre, #yiv2598329866 code {font:115% 
monospace;}#yiv2598329866 #yiv2598329866ygrp-mlmsg * 
{line-height:1.22em;}#yiv2598329866 #yiv2598329866ygrp-mlmsg #yiv2598329866logo 
{padding-bottom:10px;}#yiv2598329866 #yiv2598329866ygrp-msg p a 
{font-family:Verdana;}#yiv2598329866 #yiv2598329866ygrp-msg 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 can run query on rdb$indices and rdb$index_segment 
tables. And save result to the file.
About table statistics - here is really fine concept that you do not need to 
recalculate anything. Table pages count and record size is taken in calc. In 
fb3 also record compression level.
Regards,Karol Bieniaszewski  #yiv0641671250 #yiv0641671250 -- 
#yiv0641671250ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv0641671250 #yiv0641671250ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv0641671250 #yiv0641671250ygrp-mkp #yiv0641671250hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0641671250 #yiv0641671250ygrp-mkp #yiv0641671250ads 
{margin-bottom:10px;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad 
{padding:0 0;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad p 
{margin:0;}#yiv0641671250 #yiv0641671250ygrp-mkp .yiv0641671250ad a 
{color:#ff;text-decoration:none;}#yiv0641671250 #yiv0641671250ygrp-sponsor 
#yiv0641671250ygrp-lc {font-family:Arial;}#yiv0641671250 
#yiv0641671250ygrp-sponsor #yiv0641671250ygrp-lc #yiv0641671250hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0641671250 
#yiv0641671250ygrp-sponsor #yiv0641671250ygrp-lc .yiv0641671250ad 
{margin-bottom:10px;padding:0 0;}#yiv0641671250 #yiv0641671250actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0641671250 
#yiv0641671250activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0641671250
 #yiv0641671250activity span {font-weight:700;}#yiv0641671250 
#yiv0641671250activity span:first-child 
{text-transform:uppercase;}#yiv0641671250 #yiv0641671250activity span a 
{color:#5085b6;text-decoration:none;}#yiv0641671250 #yiv0641671250activity span 
span {color:#ff7900;}#yiv0641671250 #yiv0641671250activity span 
.yiv0641671250underline {text-decoration:underline;}#yiv0641671250 
.yiv0641671250attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0641671250 .yiv0641671250attach div a 
{text-decoration:none;}#yiv0641671250 .yiv0641671250attach img 
{border:none;padding-right:5px;}#yiv0641671250 .yiv0641671250attach label 
{display:block;margin-bottom:5px;}#yiv0641671250 .yiv0641671250attach label a 
{text-decoration:none;}#yiv0641671250 blockquote {margin:0 0 0 
4px;}#yiv0641671250 .yiv0641671250bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0641671250 
.yiv0641671250bold a {text-decoration:none;}#yiv0641671250 dd.yiv0641671250last 
p a {font-family:Verdana;font-weight:700;}#yiv0641671250 dd.yiv0641671250last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0641671250 
dd.yiv0641671250last p span.yiv0641671250yshortcuts 
{margin-right:0;}#yiv0641671250 div.yiv0641671250attach-table div div a 
{text-decoration:none;}#yiv0641671250 div.yiv0641671250attach-table 
{width:400px;}#yiv0641671250 div.yiv0641671250file-title a, #yiv0641671250 
div.yiv0641671250file-title a:active, #yiv0641671250 
div.yiv0641671250file-title a:hover, #yiv0641671250 div.yiv0641671250file-title 
a:visited {text-decoration:none;}#yiv0641671250 div.yiv0641671250photo-title a, 
#yiv0641671250 div.yiv0641671250photo-title a:active, #yiv0641671250 
div.yiv0641671250photo-title a:hover, #yiv0641671250 
div.yiv0641671250photo-title a:visited {text-decoration:none;}#yiv0641671250 
div#yiv0641671250ygrp-mlmsg #yiv0641671250ygrp-msg p a 
span.yiv0641671250yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0641671250 
.yiv0641671250green {color:#628c2a;}#yiv0641671250 .yiv0641671250MsoNormal 
{margin:0 0 0 0;}#yiv0641671250 o {font-size:0;}#yiv0641671250 
#yiv0641671250photos div {float:left;width:72px;}#yiv0641671250 
#yiv0641671250photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv0641671250 
#yiv0641671250photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0641671250
 #yiv0641671250reco-category {font-size:77%;}#yiv0641671250 
#yiv0641671250reco-desc {font-size:77%;}#yiv0641671250 .yiv0641671250replbq 
{margin:4px;}#yiv0641671250 #yiv0641671250ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0641671250 #yiv0641671250ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0641671250 
#yiv0641671250ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0641671250 
#yiv0641671250ygrp-mlmsg select, #yiv0641671250 input, #yiv0641671250 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0641671250 
#yiv0641671250ygrp-mlmsg pre, #yiv0641671250 code {font:115% 
monospace;}#yiv0641671250 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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 there any way to backup the statistics before recalculate them?
Note: This backup can be very useful if the new statistics create a performance 
problem
Thanks in advance for your help

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 2012R2
> 
> This link 
> says that the maximum size of the page cache buffer is  131,072 pages.
> 
> This limit also applies to Firebird 2.5 x64 superserver in Windows?

131,072 pages is the limit for 32-bit builds. There's no explicit limit 
for 64-bit builds.

Dmitry


  #yiv5725125695 #yiv5725125695 -- #yiv5725125695ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5725125695 
#yiv5725125695ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5725125695 
#yiv5725125695ygrp-mkp #yiv5725125695hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv5725125695 #yiv5725125695ygrp-mkp #yiv5725125695ads 
{margin-bottom:10px;}#yiv5725125695 #yiv5725125695ygrp-mkp .yiv5725125695ad 
{padding:0 0;}#yiv5725125695 #yiv5725125695ygrp-mkp .yiv5725125695ad p 
{margin:0;}#yiv5725125695 #yiv5725125695ygrp-mkp .yiv5725125695ad a 
{color:#ff;text-decoration:none;}#yiv5725125695 #yiv5725125695ygrp-sponsor 
#yiv5725125695ygrp-lc {font-family:Arial;}#yiv5725125695 
#yiv5725125695ygrp-sponsor #yiv5725125695ygrp-lc #yiv5725125695hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5725125695 
#yiv5725125695ygrp-sponsor #yiv5725125695ygrp-lc .yiv5725125695ad 
{margin-bottom:10px;padding:0 0;}#yiv5725125695 #yiv5725125695actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5725125695 
#yiv5725125695activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5725125695
 #yiv5725125695activity span {font-weight:700;}#yiv5725125695 
#yiv5725125695activity span:first-child 
{text-transform:uppercase;}#yiv5725125695 #yiv5725125695activity span a 
{color:#5085b6;text-decoration:none;}#yiv5725125695 #yiv5725125695activity span 
span {color:#ff7900;}#yiv5725125695 #yiv5725125695activity span 
.yiv5725125695underline {text-decoration:underline;}#yiv5725125695 
.yiv5725125695attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv5725125695 .yiv5725125695attach div a 
{text-decoration:none;}#yiv5725125695 .yiv5725125695attach img 
{border:none;padding-right:5px;}#yiv5725125695 .yiv5725125695attach label 
{display:block;margin-bottom:5px;}#yiv5725125695 .yiv5725125695attach label a 
{text-decoration:none;}#yiv5725125695 blockquote {margin:0 0 0 
4px;}#yiv5725125695 .yiv5725125695bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5725125695 
.yiv5725125695bold a {text-decoration:none;}#yiv5725125695 dd.yiv5725125695last 
p a {font-family:Verdana;font-weight:700;}#yiv5725125695 dd.yiv5725125695last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5725125695 
dd.yiv5725125695last p span.yiv5725125695yshortcuts 
{margin-right:0;}#yiv5725125695 div.yiv5725125695attach-table div div a 
{text-decoration:none;}#yiv5725125695 div.yiv5725125695attach-table 
{width:400px;}#yiv5725125695 div.yiv5725125695file-title a, #yiv5725125695 
div.yiv5725125695file-title a:active, #yiv5725125695 
div.yiv5725125695file-title a:hover, #yiv5725125695 div.yiv5725125695file-title 
a:visited {text-decoration:none;}#yiv5725125695 div.yiv5725125695photo-title a, 
#yiv5725125695 div.yiv5725125695photo-title a:active, #yiv5725125695 
div.yiv5725125695photo-title a:hover, #yiv5725125695 
div.yiv5725125695photo-title a:visited {text-decoration:none;}#yiv5725125695 
div#yiv5725125695ygrp-mlmsg #yiv5725125695ygrp-msg p a 
span.yiv5725125695yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5725125695 
.yiv5725125695green {color:#628c2a;}#yiv5725125695 .yiv5725125695MsoNormal 
{margin:0 0 0 0;}#yiv5725125695 o {font-size:0;}#yiv5725125695 
#yiv5725125695photos div {float:left;width:72px;}#yiv5725125695 
#yiv5725125695photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv5725125695 
#yiv5725125695photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5725125695
 #yiv5725125695reco-category {font-size:77%;}#yiv5725125695 
#yiv5725125695reco-desc {font-size:77%;}#yiv5725125695 .yiv5725125695replbq 
{margin:4px;}#yiv5725125695 #yiv5725125695ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv5725125695 #yiv5725125695ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5725125695 
#yiv5725125695ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5725125695 
#yiv5725125695ygrp-mlmsg select, #yiv5725125695 input, #yiv5725125695 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5725125695 
#yiv5725125695ygrp-mlmsg pre, #yiv5725125695 code {font:115% 
monospace;}#yiv5725125695 #yiv5725125695ygrp-mlmsg * 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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 superserver in Windows?

Thanks in advance for your kind help. 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 the database using gbak.  
   - Check the return code of gbak and if it is different from zero there is a 
problem with the database. 


And every week: 
   
   - Recalculate index statistics. 


What do you think? These actions are enough? Would you change something?


thanks in advance for your kind help. 
On Friday, May 4, 2018, 11:08:47 AM CDT, Javier Cintron 
fcintr...@yahoo..com [firebird-support]  
wrote:  
 
     

 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. 
  #yiv4710941892 #yiv4710941892 -- #yiv4710941892ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4710941892 
#yiv4710941892ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4710941892 
#yiv4710941892ygrp-mkp #yiv4710941892hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv4710941892 #yiv4710941892ygrp-mkp #yiv4710941892ads 
{margin-bottom:10px;}#yiv4710941892 #yiv4710941892ygrp-mkp .yiv4710941892ad 
{padding:0 0;}#yiv4710941892 #yiv4710941892ygrp-mkp .yiv4710941892ad p 
{margin:0;}#yiv4710941892 #yiv4710941892ygrp-mkp .yiv4710941892ad a 
{color:#ff;text-decoration:none;}#yiv4710941892 #yiv4710941892ygrp-sponsor 
#yiv4710941892ygrp-lc {font-family:Arial;}#yiv4710941892 
#yiv4710941892ygrp-sponsor #yiv4710941892ygrp-lc #yiv4710941892hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4710941892 
#yiv4710941892ygrp-sponsor #yiv4710941892ygrp-lc .yiv4710941892ad 
{margin-bottom:10px;padding:0 0;}#yiv4710941892 #yiv4710941892actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4710941892 
#yiv4710941892activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4710941892
 #yiv4710941892activity span {font-weight:700;}#yiv4710941892 
#yiv4710941892activity span:first-child 
{text-transform:uppercase;}#yiv4710941892 #yiv4710941892activity span a 
{color:#5085b6;text-decoration:none;}#yiv4710941892 #yiv4710941892activity span 
span {color:#ff7900;}#yiv4710941892 #yiv4710941892activity span 
.yiv4710941892underline {text-decoration:underline;}#yiv4710941892 
.yiv4710941892attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv4710941892 .yiv4710941892attach div a 
{text-decoration:none;}#yiv4710941892 .yiv4710941892attach img 
{border:none;padding-right:5px;}#yiv4710941892 .yiv4710941892attach label 
{display:block;margin-bottom:5px;}#yiv4710941892 .yiv4710941892attach label a 
{text-decoration:none;}#yiv4710941892 blockquote {margin:0 0 0 
4px;}#yiv4710941892 .yiv4710941892bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4710941892 
.yiv4710941892bold a {text-decoration:none;}#yiv4710941892 dd.yiv4710941892last 
p a {font-family:Verdana;font-weight:700;}#yiv4710941892 dd.yiv4710941892last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4710941892 
dd.yiv4710941892last p span.yiv4710941892yshortcuts 
{margin-right:0;}#yiv4710941892 div.yiv4710941892attach-table div div a 
{text-decoration:none;}#yiv4710941892 div.yiv4710941892attach-table 
{width:400px;}#yiv4710941892 div.yiv4710941892file-title a, #yiv4710941892 
div.yiv4710941892file-title a:active, #yiv4710941892 
div.yiv4710941892file-title a:hover, #yiv4710941892 div.yiv4710941892file-title 
a:visited {text-decoration:none;}#yiv4710941892 div.yiv4710941892photo-title a, 
#yiv4710941892 div.yiv4710941892photo-title a:active, #yiv4710941892 
div.yiv4710941892photo-title a:hover, #yiv4710941892 
div.yiv4710941892photo-title a:visited {text-decoration:none;}#yiv4710941892 
div#yiv4710941892ygrp-mlmsg #yiv4710941892ygrp-msg p a 
span.yiv4710941892yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4710941892 
.yiv4710941892green {color:#628c2a;}#yiv4710941892 .yiv4710941892MsoNormal 
{margin:0 0 0 0;}#yiv4710941892 o {font-size:0;}#yiv4710941892 
#yiv4710941892photos div {float:left;width:72px;}#yiv4710941892 
#yiv4710941892photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv4710941892 
#yiv4710941892photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4710941892
 #yiv4710941892reco-category {font-size:77%;}#yiv4710941892 
#yiv4710941892reco-desc {font-size:77%;}#yiv4710941892 .yiv4710941892replbq 
{margin:4px;}#yiv4710941892 #yiv4710941892ygrp-actbar div a:first-child 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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?

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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 that, the server may access the file
during your copy process and you would get a corrupt file copy.

> and If yes, what is the proper way to shutdown and startup it?

You can use the GFIX tool with the option

-shut full

to shutdown the database so Firebird will not access the file and

-online normal

to put it back online.

Examples:

gfix -user SYSDBA -password masterkey dbserver:mydb -shut full -force 0

gfix -user SYSDBA -password masterkey dbserver:mydb -online normal

> When I need to restart Windows Server, Do I need to shutdown the
> Firebird instance first?

No.

Best Regards

Stefan


  #yiv3821471310 #yiv3821471310 -- #yiv3821471310ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3821471310 
#yiv3821471310ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3821471310 
#yiv3821471310ygrp-mkp #yiv3821471310hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3821471310 #yiv3821471310ygrp-mkp #yiv3821471310ads 
{margin-bottom:10px;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad 
{padding:0 0;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad p 
{margin:0;}#yiv3821471310 #yiv3821471310ygrp-mkp .yiv3821471310ad a 
{color:#ff;text-decoration:none;}#yiv3821471310 #yiv3821471310ygrp-sponsor 
#yiv3821471310ygrp-lc {font-family:Arial;}#yiv3821471310 
#yiv3821471310ygrp-sponsor #yiv3821471310ygrp-lc #yiv3821471310hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3821471310 
#yiv3821471310ygrp-sponsor #yiv3821471310ygrp-lc .yiv3821471310ad 
{margin-bottom:10px;padding:0 0;}#yiv3821471310 #yiv3821471310actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3821471310 
#yiv3821471310activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3821471310
 #yiv3821471310activity span {font-weight:700;}#yiv3821471310 
#yiv3821471310activity span:first-child 
{text-transform:uppercase;}#yiv3821471310 #yiv3821471310activity span a 
{color:#5085b6;text-decoration:none;}#yiv3821471310 #yiv3821471310activity span 
span {color:#ff7900;}#yiv3821471310 #yiv3821471310activity span 
.yiv3821471310underline {text-decoration:underline;}#yiv3821471310 
.yiv3821471310attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3821471310 .yiv3821471310attach div a 
{text-decoration:none;}#yiv3821471310 .yiv3821471310attach img 
{border:none;padding-right:5px;}#yiv3821471310 .yiv3821471310attach label 
{display:block;margin-bottom:5px;}#yiv3821471310 .yiv3821471310attach label a 
{text-decoration:none;}#yiv3821471310 blockquote {margin:0 0 0 
4px;}#yiv3821471310 .yiv3821471310bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3821471310 
.yiv3821471310bold a {text-decoration:none;}#yiv3821471310 dd.yiv3821471310last 
p a {font-family:Verdana;font-weight:700;}#yiv3821471310 dd.yiv3821471310last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3821471310 
dd.yiv3821471310last p span.yiv3821471310yshortcuts 
{margin-right:0;}#yiv3821471310 div.yiv3821471310attach-table div div a 
{text-decoration:none;}#yiv3821471310 div.yiv3821471310attach-table 
{width:400px;}#yiv3821471310 div.yiv3821471310file-title a, #yiv3821471310 
div.yiv3821471310file-title a:active, #yiv3821471310 
div.yiv3821471310file-title a:hover, #yiv3821471310 div.yiv3821471310file-title 
a:visited {text-decoration:none;}#yiv3821471310 div.yiv3821471310photo-title a, 
#yiv3821471310 div.yiv3821471310photo-title a:active, #yiv3821471310 
div.yiv3821471310photo-title a:hover, #yiv3821471310 
div.yiv3821471310photo-title a:visited {text-decoration:none;}#yiv3821471310 
div#yiv3821471310ygrp-mlmsg #yiv3821471310ygrp-msg p a 
span.yiv3821471310yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3821471310 
.yiv3821471310green {color:#628c2a;}#yiv3821471310 .yiv3821471310MsoNormal 
{margin:0 0 0 0;}#yiv3821471310 o {font-size:0;}#yiv3821471310 
#yiv3821471310photos div {float:left;width:72px;}#yiv3821471310 
#yiv3821471310photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv3821471310 
#yiv3821471310photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3821471310
 #yiv3821471310reco-category {font-size:77%;}#yiv3821471310 
#yiv3821471310reco-desc {font-size:77%;}#yiv3821471310 .yiv3821471310replbq 
{margin:4px;}#yiv3821471310 #yiv3821471310ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3821471310 #yiv3821471310ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3821471310 

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 Yes That is right, I want to backup the database. 
I have a gap in the nigth to do it. 
I understand that by using gbak or nbackup Firebird doesnt need to be shutdown. 
Besides that, is there any other advantage of gbak or nbackup against an 
ordinary copy of the database?
By the way If a need 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 [firebird-support] 
wrote:
> Firebird ver 2.5.7.27050 64 bits
> Superserver
> Windows Server 2012R2
> 
> I have two questions:
> 
> 1. When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first? and If yes, w< span style="color: rgb(0, 0,
> 0); font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
> font-size: 16px;">hat is the proper way to shutdown and startup it?
> 2. When I need to restart Windows Server, Do I need to shutdown the
> Firebird instance first? 

Exactly why do you want to copy your Firebird database?

In most cases the proper action will be to backup the database through 
gbak or maybe nbackup instead of copying the database file. However, if 
for some reason you really need/want to backup by manually copying the 
file, then you should change the database to backup mode, copy the file 
and disable backup mode.

This can be done with

ALTER DATABASE BEGIN BACKUP;
+ (commit)

Copy file

ALTER DATABASE END BACKUP;
+ (commit)

Mark
-- 
Mark Rotteveel

  #yiv8828140725 #yiv8828140725 -- #yiv8828140725ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8828140725 
#yiv8828140725ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8828140725 
#yiv8828140725ygrp-mkp #yiv8828140725hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8828140725 #yiv8828140725ygrp-mkp #yiv8828140725ads 
{margin-bottom:10px;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad 
{padding:0 0;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad p 
{margin:0;}#yiv8828140725 #yiv8828140725ygrp-mkp .yiv8828140725ad a 
{color:#ff;text-decoration:none;}#yiv8828140725 #yiv8828140725ygrp-sponsor 
#yiv8828140725ygrp-lc {font-family:Arial;}#yiv8828140725 
#yiv8828140725ygrp-sponsor #yiv8828140725ygrp-lc #yiv8828140725hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8828140725 
#yiv8828140725ygrp-sponsor #yiv8828140725ygrp-lc .yiv8828140725ad 
{margin-bottom:10px;padding:0 0;}#yiv8828140725 #yiv8828140725actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8828140725 
#yiv8828140725activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8828140725
 #yiv8828140725activity span {font-weight:700;}#yiv8828140725 
#yiv8828140725activity span:first-child 
{text-transform:uppercase;}#yiv8828140725 #yiv8828140725activity span a 
{color:#5085b6;text-decoration:none;}#yiv8828140725 #yiv8828140725activity span 
span {color:#ff7900;}#yiv8828140725 #yiv8828140725activity span 
.yiv8828140725underline {text-decoration:underline;}#yiv8828140725 
.yiv8828140725attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8828140725 .yiv8828140725attach div a 
{text-decoration:none;}#yiv8828140725 .yiv8828140725attach img 
{border:none;padding-right:5px;}#yiv8828140725 .yiv8828140725attach label 
{display:block;margin-bottom:5px;}#yiv8828140725 .yiv8828140725attach label a 
{text-decoration:none;}#yiv8828140725 blockquote {margin:0 0 0 
4px;}#yiv8828140725 .yiv8828140725bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8828140725 
.yiv8828140725bold a {text-decoration:none;}#yiv8828140725 dd.yiv8828140725last 
p a {font-family:Verdana;font-weight:700;}#yiv8828140725 dd.yiv8828140725last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8828140725 
dd.yiv8828140725last p span.yiv8828140725yshortcuts 
{margin-right:0;}#yiv8828140725 div.yiv8828140725attach-table div div a 
{text-decoration:none;}#yiv8828140725 div.yiv8828140725attach-table 
{width:400px;}#yiv8828140725 div.yiv8828140725file-title a, #yiv8828140725 
div.yiv8828140725file-title a:active, #yiv8828140725 
div.yiv8828140725file-title a:hover, #yiv8828140725 div.yiv8828140725file-title 
a:visited {text-decoration:none;}#yiv8828140725 div.yiv8828140725photo-title a, 
#yiv8828140725 div.yiv8828140725photo-title a:active, #yiv8828140725 
div.yiv8828140725photo-title a:hover, #yiv8828140725 
div.yiv8828140725photo-title a:visited {text-decoration:none;}#yiv8828140725 
div#yiv8828140725ygrp-mlmsg #yiv8828140725ygrp-msg p a 
span.yiv8828140725yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8828140725 
.yiv8828140725green {color:#628c2a;}#yiv8828140725 .yiv8828140725MsoNo

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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, Do I need to shutdown the Firebird 
instance first? 
Thanks in advance

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

 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.27050 64 bits
> Windows Server 2012R2
> 
> ¿Is there a way to calculate the effectiveness of incrementing the page cache 
> buffer ?

select cast(mon$page_reads as double precision)/mon$page_fetches from 
mon$io_stats 
where mon$stat_group=0
 If the value is getting lower - you are on the right way.

-- 
 WBR, SD.

  #yiv1296759600 #yiv1296759600 -- #yiv1296759600ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1296759600 
#yiv1296759600ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1296759600 
#yiv1296759600ygrp-mkp #yiv1296759600hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1296759600 #yiv1296759600ygrp-mkp #yiv1296759600ads 
{margin-bottom:10px;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad 
{padding:0 0;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad p 
{margin:0;}#yiv1296759600 #yiv1296759600ygrp-mkp .yiv1296759600ad a 
{color:#ff;text-decoration:none;}#yiv1296759600 #yiv1296759600ygrp-sponsor 
#yiv1296759600ygrp-lc {font-family:Arial;}#yiv1296759600 
#yiv1296759600ygrp-sponsor #yiv1296759600ygrp-lc #yiv1296759600hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1296759600 
#yiv1296759600ygrp-sponsor #yiv1296759600ygrp-lc .yiv1296759600ad 
{margin-bottom:10px;padding:0 0;}#yiv1296759600 #yiv1296759600actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1296759600 
#yiv1296759600activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1296759600
 #yiv1296759600activity span {font-weight:700;}#yiv1296759600 
#yiv1296759600activity span:first-child 
{text-transform:uppercase;}#yiv1296759600 #yiv1296759600activity span a 
{color:#5085b6;text-decoration:none;}#yiv1296759600 #yiv1296759600activity span 
span {color:#ff7900;}#yiv1296759600 #yiv1296759600activity span 
.yiv1296759600underline {text-decoration:underline;}#yiv1296759600 
.yiv1296759600attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1296759600 .yiv1296759600attach div a 
{text-decoration:none;}#yiv1296759600 .yiv1296759600attach img 
{border:none;padding-right:5px;}#yiv1296759600 .yiv1296759600attach label 
{display:block;margin-bottom:5px;}#yiv1296759600 .yiv1296759600attach label a 
{text-decoration:none;}#yiv1296759600 blockquote {margin:0 0 0 
4px;}#yiv1296759600 .yiv1296759600bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1296759600 
.yiv1296759600bold a {text-decoration:none;}#yiv1296759600 dd.yiv1296759600last 
p a {font-family:Verdana;font-weight:700;}#yiv1296759600 dd.yiv1296759600last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1296759600 
dd.yiv1296759600last p span.yiv1296759600yshortcuts 
{margin-right:0;}#yiv1296759600 div.yiv1296759600attach-table div div a 
{text-decoration:none;}#yiv1296759600 div.yiv1296759600attach-table 
{width:400px;}#yiv1296759600 div.yiv1296759600file-title a, #yiv1296759600 
div.yiv1296759600file-title a:active, #yiv1296759600 
div.yiv1296759600file-title a:hover, #yiv1296759600 div.yiv1296759600file-title 
a:visited {text-decoration:none;}#yiv1296759600 div.yiv1296759600photo-title a, 
#yiv1296759600 div.yiv1296759600photo-title a:active, #yiv1296759600 
div.yiv1296759600photo-title a:hover, #yiv1296759600 
div.yiv1296759600photo-title a:visited {text-decoration:none;}#yiv1296759600 
div#yiv1296759600ygrp-mlmsg #yiv1296759600ygrp-msg p a 
span.yiv1296759600yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1296759600 
.yiv1296759600green {color:#628c2a;}#yiv1296759600 .yiv1296759600MsoNormal 
{margin:0 0 0 0;}#yiv1296759600 o {font-size:0;}#yiv1296759600 
#yiv1296759600photos div {float:left;width:72px;}#yiv1296759600 
#yiv1296759600photos div div {border:1px solid 
#66;min-height:62px;overflow:hidden;width:62px;}#yiv1296759600 
#yiv1296759600photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1296759600
 #yiv1296759600reco-category {font-size:77%;}#yiv1296759600 
#yiv1296759600reco-desc {font-size:77%;}#yiv1296759600 .yiv1296759600replbq 
{margin:4px;}#yiv1296759600 #yiv1296759600ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1296759600 #yiv1296759600ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg select, #yiv1296759600 input, #yiv1296759600 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1296759600 
#yiv1296759600ygrp-mlmsg pre, #yiv1296759600 code {font:115% 
mono

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

[Javier Cintron fcintr...@yahoo.com [firebird-support]]

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