Re: [firebird-support] nbackup

[hugo.lar...@yahoo.com [firebird-support]]

Hi,

Interesting that FB 3.0 reduces the nbackup time. Thanks for the info.

 We have so many installations so I think we will wait for FB 4.0 which have 
incremental nbackup restore and native replication.

BR,
 Fadi 

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

[Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]]

02.06.2017 8:54, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg 
[firebird-support] wrote:
> What is the size of the database that we can test to show the speed 
> significance between 
> Firebird 1.5 and Firebird 2.5?

   One terabyte should be enough. But what's the point to migrate to 2.5 when 
3.0 is 
already released?


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

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Hugo,

Yes, in this case you can check MON$ tables.
Please note that in case of many connections query to MON$ can consume 
significant resources.



How do you recover if  it's stuck?


nbackup -n

>I noticed that the larger the database is the longer it takes to do 
nbackup even if the delta is very small.


In 2.5 nbackup of any level scans the whole database file.
Consider to migrate to 3.0 to take advantage of nbackup improvements

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



Hi Alexey,

In my case the database is seldom larger 500 MB and the backup takes 
30 maximum seconds.


Would it not be sufficient to check the  MON$BACKUP_STATE field 
(thanks Thomas) and if its stuck on state 1 or 2 for several minutes 
then I execute "ALTER DATABASE END BACKUP".

How do you recover if it's stuck?

I noticed that the larger the database is the longer it takes to do 
nbackup even if the delta is very small.


BR,

hugo

Re: [firebird-support] nbackup

[hugo.lar...@yahoo.com [firebird-support]]

Hi Alexey,

In my case the database is seldom larger 500 MB and the backup takes 30 maximum 
seconds.

Would it not be sufficient to check the  MON$BACKUP_STATE field (thanks Thomas) 
and if its stuck on state 1 or 2 for several minutes then I execute "ALTER 
DATABASE END BACKUP".
How do you recover if it's stuck?

I noticed that the larger the database is the longer it takes to do nbackup 
even if the delta is very small.

BR, hugo

[firebird-support] Ask : firebird 1.5 to firebird 2.5

['Vonica Tng (Madsoft)' vonica....@madsoft.com.sg [firebird-support]]

Dear Sir / Madam,

 

What is the size of the database that we can test to show the speed 
significance between Firebird 1.5 and Firebird 2.5?

 

Vonica Tng

Sales & Marketing Support Executive

MadSoft Solutions Pte Ltd 

(formerly known as QnE Consultants Pte Ltd)

 

178 Paya Lebar Road

#05-01/02/03 Paya Lebar 178

Singapore 409030

Tel   :  (65)  6296 9919 ext 140

Fax  :  (65)  6296 9949

Email  :  vonica@madsoft.com.sg  

Website:  www.madsoft.com.sg  

 

Connect with us:    madsoft.sg 
   
madsoftsg  



[Non-text portions of this message have been removed]