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

2018-05-05 Thread 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?

2018-05-04 Thread 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. 

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

2018-05-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
04.05.2018 4:55, Javier Cintron fcintr...@yahoo.com [firebird-support] wrote:
> what other regular maintenance actions does Firebird need in order to 
> function properly?

   It may be a good idea to recalculate index statistics from time to time.


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

<*> 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] What regular maintenance actions does Firebird need in order to function properly?

2018-05-04 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support] 

Hello,

We recommend perform at least everyday sweep - with disconnect of long 
running active writeable transactions before it.


Can you please clarify what do you mean by
> measuring the effectiveness of the page cache
?

Regards,
Alexey Kovyazin
IBSurgeon www.ib-aid.com




On 04.05.2018 5:55, Javier Cintron fcintr...@yahoo.com 
[firebird-support] wrote:

Firebird ver 2.5.7.27050 64 bits
Superserver
Windows 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