[firebird-support] gbak speed
Hi, I'm need to speedup my database backup, its currently taking 6 hours to backup a 74Gb database. Using firebird 2.1.5 on centos, database is on fast drives with raid 10. How does this compare with the experience of others? the command line used is: (and I do need the garbage collect) gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout /var/archive/db/mydb.fbk -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
[firebird-support] Re: No free space found in temporary directories operating system ..WriteFile failed
The right is : firebird.conf TempDirectories = D:\
Re: [firebird-support] Password Recovery
Hej, you're talking about encrypted data stored in the db? Then you'll have no luck, as data is encrypted by the app that's writing the data. Ii mailto:ii_tungt...@ymail.com Donnerstag, 11. April 2013 10:48 i have problem with my softwarethat software using a encryption passwordand i forget that passwordthis software using firebird...whether passwords are encrypted in the firebird be opened normally??please help mewhat should i do to unlock the password??? sorry if my english is not good ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] gbak speed
the database backup are already seperate devices On 11 April 2013 10:25, Marcus Bajohr marcus.baj...@gmail.com wrote: ** Hej, from my little knowledge i have: are the db and the backup on different devices? Or are they both on the raid? I've reduced the backup time from 1,5 mours to 40 minutes for a ~55 GB db by simply writing the backup to another physical dev cheers, Marcus Nick Upson mailto:n...@telensa.com Donnerstag, 11. April 2013 11:19 Hi, I'm need to speedup my database backup, its currently taking 6 hours to backup a 74Gb database. Using firebird 2.1.5 on centos, database is on fast drives with raid 10. How does this compare with the experience of others? the command line used is: (and I do need the garbage collect) gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout /var/archive/db/mydb.fbk [Non-text portions of this message have been removed] -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re[2]: [firebird-support] gbak speed
Hello, Nick! Thursday, April 11, 2013, 1:31:17 PM, you wrote: NU the database backup are already seperate devices were you thinking to add -g option to gbak command line? NU On 11 April 2013 10:25, Marcus Bajohr marcus.baj...@gmail.com wrote: ** Hej, from my little knowledge i have: are the db and the backup on different devices? Or are they both on the raid? I've reduced the backup time from 1,5 mours to 40 minutes for a ~55 GB db by simply writing the backup to another physical dev cheers, Marcus Nick Upson mailto:n...@telensa.com Donnerstag, 11. April 2013 11:19 Hi, I'm need to speedup my database backup, its currently taking 6 hours to backup a 74Gb database. Using firebird 2.1.5 on centos, database is on fast drives with raid 10. How does this compare with the experience of others? the command line used is: (and I do need the garbage collect) gbak -user sysdba -pass XXX -backup localhost:/opt/db/mydb.fdb stdout /var/archive/db/mydb.fbk [Non-text portions of this message have been removed] -- Dmitry Kuzmenko, www.ib-aid.com
[firebird-support] Re: FireBird 2.5 How can i create 1 byte (0-255) column?
in addition: how to show as int from block or procedure? SET TERM !; EXECUTE BLOCK RETURNS (IID INT,I1 INT) AS BEGIN SELECT IID,I1 FROM T1 WHERE IID=700 INTO :IID,:I1; SUSPEND; END ! SET TERM ;!
Re: [firebird-support] Re: FireBird 2.5 How can i create 1 byte (0-255) column?
On Thu, 11 Apr 2013 09:35:44 -, wan30032 wan30...@yahoo.com wrote: in addition: how to show as int from block or procedure? SET TERM !; EXECUTE BLOCK RETURNS (IID INT,I1 INT) AS BEGIN SELECT IID,I1 FROM T1 WHERE IID=700 INTO :IID,:I1; SUSPEND; END ! SET TERM ;! Try ASCII_VAL http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-intfunc-ascii_val.html Mark
[firebird-support] Re: FireBird 2.5 How can i create 1 byte (0-255) column?
tks, ASCII_CHAR ASCII_VAL
Re: [firebird-support] gbak speed
How does this compare with the experience of others? Hmmm. A quick calculation shows: My biggest database is 1/74 of the size of yours. I need ~5 Minutes to backup a freshly restored database, backup takes longer if the restore is longer ago (up to 6.5 minutes). 5 * 74 = 370 minutes == 6 hours and 10 minutes. certainly not any academical method to do a comparison, but surprisingly close to your result :-) Mine is on hardware of 2005, RAID, Dual Xeon 1GHz, Server2003 R2 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re[2]: [firebird-support] gbak speed
Hello, André! Thursday, April 11, 2013, 2:42:01 PM, you wrote: How does this compare with the experience of others? AK Hmmm. A quick calculation shows: AK My biggest database is 1/74 of the size of yours. AK I need ~5 Minutes to backup a freshly restored database, backup takes AK longer if the restore is longer ago (up to 6.5 minutes). too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives backup of 2.7GB database from one drive to another took from 3.5 to 5 minutes, depending on protocol used. The fastest way to do backup is to use Services API, i.e. -se option of gbak. And, to use -g option of course. So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes. And, with the a bit modern hardware (but still desktop with several drives) restore of another database, 1.5GB backup size and 3.9gb resulting database also takes not more than 5 minutes, via -se. But, via localhost - around 1 hour. -- Dmitry Kuzmenko, www.ib-aid.com ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: Re[2]: [firebird-support] gbak speed
Hi Dmitry, are you saying that I should remove localhost from the database connection string to get faster performance? and that will work ok with other processes running that do connect via localhost continuing to run at the same time (this is a 24/7 system)? On 11 April 2013 11:53, Dmitry Kuzmenko k...@ibase.ru wrote: Hello, André! Thursday, April 11, 2013, 2:42:01 PM, you wrote: How does this compare with the experience of others? AK Hmmm. A quick calculation shows: AK My biggest database is 1/74 of the size of yours. AK I need ~5 Minutes to backup a freshly restored database, backup takes AK longer if the restore is longer ago (up to 6.5 minutes). too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives backup of 2.7GB database from one drive to another took from 3.5 to 5 minutes, depending on protocol used. The fastest way to do backup is to use Services API, i.e. -se option of gbak. And, to use -g option of course. So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes. And, with the a bit modern hardware (but still desktop with several drives) restore of another database, 1.5GB backup size and 3.9gb resulting database also takes not more than 5 minutes, via -se. But, via localhost - around 1 hour. -- Dmitry Kuzmenko, www.ib-aid.com ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] gbak speed
Hello, André! Thursday, April 11, 2013, 2:42:01 PM, you wrote: How does this compare with the experience of others? AK Hmmm. A quick calculation shows: AK My biggest database is 1/74 of the size of yours. AK I need ~5 Minutes to backup a freshly restored database, backup takes AK longer if the restore is longer ago (up to 6.5 minutes). too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives backup of 2.7GB database from one drive to another took from 3.5 to 5 minutes, depending on protocol used. The fastest way to do backup is to use Services API, i.e. -se option of gbak. And, to use -g option of course. I don't use Services API nor -g in that case. I simply leave everything as is; am in the process of upgrading all and everything to current hardware, OS and FB 2.5.2. That old database is FB 1.5.6 CS with some 200 open connections all the time and 80% of RAM + 30% CPU constantly in use - which might explain. ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re[4]: [firebird-support] gbak speed
Hello, Nick! Thursday, April 11, 2013, 2:59:52 PM, you wrote: NU Hi Dmitry, NU are you saying that I should remove localhost from the database connection NU string to get faster performance? and that will work ok with other NU processes running that do connect via localhost continuing to run at the NU same time (this is a 24/7 system)? I say that when you specify usual -b option, gbak transfers database contents from server to local file. With localhost data goes through tcp, wich can be slow. Option -se designed in IB 6.0 to make backup (and restore) by server, minimizing the network redundancy. And yes, during backup/restore tests I've got that -se option makes backup up to 2 times faster, and making restore up to 3-4 times faster. If you have database of 3-5 gb size on that server, you may try to see what difference will be. My opinion about 6 hours backup of 74gb database - it is too slow. But, it maybe slow because of your RAID, or something else. p.s. on Linux, specifying local database (without tcp) have same effect that -se option. On Windows - it's better to use -se. NU On 11 April 2013 11:53, Dmitry Kuzmenko k...@ibase.ru wrote: Hello, André! Thursday, April 11, 2013, 2:42:01 PM, you wrote: How does this compare with the experience of others? AK Hmmm. A quick calculation shows: AK My biggest database is 1/74 of the size of yours. AK I need ~5 Minutes to backup a freshly restored database, backup takes AK longer if the restore is longer ago (up to 6.5 minutes). too slow. at my old desktop with Athlon 64 x2 5200 and 3 SATA II drives backup of 2.7GB database from one drive to another took from 3.5 to 5 minutes, depending on protocol used. The fastest way to do backup is to use Services API, i.e. -se option of gbak. And, to use -g option of course. So, with worst 5 minutes result, 74/2.7 = 2 hours and 17 minutes. And, with the a bit modern hardware (but still desktop with several drives) restore of another database, 1.5GB backup size and 3.9gb resulting database also takes not more than 5 minutes, via -se. But, via localhost - around 1 hour. -- Dmitry Kuzmenko, www.ib-aid.com ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Dmitry Kuzmenko, www.ib-aid.com
Re[2]: [firebird-support] gbak speed
Hello, André! Thursday, April 11, 2013, 3:02:36 PM, you wrote: AK I don't use Services API nor -g in that case. by some reason or never thought about it? I wonder, why not to use -g option. AK I simply leave everything as is; am in the process of upgrading all AK and everything to current hardware, OS and FB 2.5.2. That old AK database is FB 1.5.6 CS with some 200 open connections all the time AK and 80% of RAM + 30% CPU constantly in use - which might explain. Sure, butI did clean test to understand where performance differ. -- Dmitry Kuzmenko, www.ib-aid.com ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] gbak speed
AK I don't use Services API nor -g in that case. by some reason or never thought about it? I wonder, why not to use -g option. did not know about it when I installed the system. Now the system is in a don't touch it while it runs mode. I have been spending some 8 years learning C#, writing new apps in C# and at the same time replacing the existing apps (dBase and Delphi). And I only have some 25% of my time for all IT-stuff, including maintenance and 1st level support. You can't imagine how glad and happy I am that all these years Firebird was an extremely reliable and stable partner for me and my job. This year I will update all the database stuff and also try to consider all the good advice I collected all the years by lurking this mailing list :-) ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
[firebird-support] Bug-Fix from 2.1 to 2.5 in updating current row values?
Hi Gang! I am asking this on behalf of a friend who is intensively using Firebird. He recently switched from 2.1.x to 2.5.x because I recommended him to do so. As it turns out, he was constantly doing the following: UPDATE Invoices SET AmtVal = :nAmtVal TotTax = AmtVal * Tax TotVal = AmtVal + TotTax WHERE InvNo = :cInvNo; which was working fine for him in 2.1.x In 2.5.x he is getting wrong results/row values, unless he changes his approach to the following: UPDATE Invoices SET AmtVal = :nAmtVal TotTax = :nAmtVal * Tax TotVal = :nAmtVal + TotTax WHERE InvNo = :cInvNo; Personally I'd never had even tried the first approach, so I can only guess that up to 2.1 it was possible to read a value just updated in the same transaction which is no longer possible in 2.5.x. AmI right in telling him that what was working for him in 2.1 was something like bad design on his side, supported by something that can be called a bug in Firebird which was now fixed or a flaw which now has been improved? What really is important: Does he have any other choice but to re-check his 1.200 stored procedures and replace the field-value identifiers by the input parameter identifiers? thanks André ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
[firebird-support] Re: Bug-Fix from 2.1 to 2.5 in updating current row values?
11.04.2013 15:51, André Knappstein wrote: AmI right in telling him that what was working for him in 2.1 was something like bad design on his side, supported by something that can be called a bug in Firebird which was now fixed or a flaw which now has been improved? What really is important: Does he have any other choice but to re-check his 1.200 stored procedures and replace the field-value identifiers by the input parameter identifiers? Read firebird.conf re. the OldSetClauseSemantics setting. Dmitry ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
[firebird-support] multiple connection strings
Hi, Can anyone confirm that I can have the following system running without potential for problems (firebird 2.1.5 on centos). currently: all programs that access the database use the same path component as either localhost:/db/mydb.fdb - if running on the server and myhost:/db/mydb.fdb - if accessing it from elsewhere possible new setup: all programs that access the database use the same path component as either /db/mydb.fdb - if running on the server and myhost:/db/mydb.fdb - if accessing it from elsewhere D mitry has suggested that I should get significant performance improvement by avoiding the tcp stack but I recall (perhaps wrongly) there being issues with this approach. -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Bug-Fix from 2.1 to 2.5 in updating current row values?
great! Thanks Dmitry! My friend Jaime will be more than happy that this conf setting will buy him some time to change the PSQL instead of doing a downgrade to 2.1 11.04.2013 15:51, André Knappstein wrote: AmI right in telling him that what was working for him in 2.1 was something like bad design on his side, supported by something that can be called a bug in Firebird which was now fixed or a flaw which now has been improved? What really is important: Does he have any other choice but to re-check his 1.200 stored procedures and replace the field-value identifiers by the input parameter identifiers? Read firebird.conf re. the OldSetClauseSemantics setting. Dmitry ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links mit freundlichen Grüßen, André Knappstein EDV und Controlling ~~ beta Eigenheim- und Grundstücksverwertungsgesellschaft mbH Hafenweg 4 59192 Bergkamen-Rünthe Telefon: +49 2389 9240 140 Telefax: +49 2389 9240 150 e-mail: knappst...@beta-eigenheim.de Amtsgericht Hamm Nr. B 420 Geschäftsführer: Achim Krähling, Dirk Salewski und Matthias Steinhaus USt-IDNr.: DE 125215402 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] multiple connection strings
Hello, Nick! Thursday, April 11, 2013, 4:06:22 PM, you wrote: NU all programs that access the database use the same path component as either NU localhost:/db/mydb.fdb - if running on the server and NU myhost:/db/mydb.fdb - if accessing it from elsewhere no difference. NU possible new setup: NU all programs that access the database use the same path component as either NU /db/mydb.fdb - if running on the server and myhost:/db/mydb.fdb - if NU accessing it from elsewhere mmm, why ? why to use local protocol? Yes, you can mix connection strings, but here is another point - what if you will need to move your applications from server? Will reconfigure connection string for all of them? NU Dmitry has suggested that I should get significant performance improvement NU by avoiding the tcp stack but I recall (perhaps wrongly) there being issues NU with this approach. you missed the point that I said about different gbak behavior. 1. gbak -b -g localhost:c:\db\db.fdb localfile.fbk here backup transfers data from server to localfile via tcp 2. gbak -b -g -se localhost:service_mgr c:\db\db.fdb localfile.fbk here gbak sends COMMAND to the server (via tcp) to make backup by itself. And localfile.fbk - is local to the server, not to gbak. For better understanding I can add that if you kill gbak with the first command line, the backup will stop, because gbak did it. With the second command line backup will still continue, because after gbak sent command via -se, it only waits for output from the server, not for the data of the database. And the server does backup, not gbak. And, switching protocol for your local server apps will not give you any visible performance improvement. Gbak is another thing, it reads (without -se) the whole database. So, for gbak speed protocol matters. -- Dmitry Kuzmenko, www.ib-aid.com
Re: [firebird-support] gbak speed
Afternoon all, I've updated the gbak manual to reflect the use of -g[arbage_collect] and -se[rvice] to speed up backups and restores, by adding a couple of sections explaing their use. I also corrected a number of occurrences in the examples where '-replace overwrite' was used instead of either '-replace' or '-recreate overwrite' - which no-one had noticed! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] gbak speed
Ahem ... On 11/04/13 13:26, Norman Dunbar wrote: I've updated the gbak manual to reflect the use of -g[arbage_collect] and -se[rvice] to speed up backups and restores, by adding a couple of sections explaing their use. Obviously, I didn't include -g[arbage_collect] in the restore section! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] gbak speed
Hi. My experience is using SSD sata III 6BG IO speed with best results (in a mac bookpro with 16 gb ram). and, are you considering to use incremental backup? On Thu, Apr 11, 2013 at 8:14 AM, Norman Dunbar nor...@dunbar-it.co.ukwrote: Ahem ... On 11/04/13 13:26, Norman Dunbar wrote: I've updated the gbak manual to reflect the use of -g[arbage_collect] and -se[rvice] to speed up backups and restores, by adding a couple of sections explaing their use. Obviously, I didn't include -g[arbage_collect] in the restore section! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Ricardo... [Non-text portions of this message have been removed]
Re: [firebird-support] gbak speed
incremental backup is not recommended in firebird 2.1.5 under significant load, I wish I could On 11 April 2013 14:27, Ricardo Uzcategui ricardou...@cantv.net wrote: ** Hi. My experience is using SSD sata III 6BG IO speed with best results (in a mac bookpro with 16 gb ram). and, are you considering to use incremental backup? On Thu, Apr 11, 2013 at 8:14 AM, Norman Dunbar nor...@dunbar-it.co.uk wrote: Ahem ... On 11/04/13 13:26, Norman Dunbar wrote: I've updated the gbak manual to reflect the use of -g[arbage_collect] and -se[rvice] to speed up backups and restores, by adding a couple of sections explaing their use. Obviously, I didn't include -g[arbage_collect] in the restore section! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Ricardo... [Non-text portions of this message have been removed] -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] gbak speed
We back up a 24 GB Firebird 2.1.5 database nightly on an High CPU Extra Large EC2 instance with the fdb located on EBS. Takes 39 minutes and we have an encryption layer on top of the file system. We do not use the loopback interface, instead we reference the fdb by direct file location and use the flags of -b -v -t -y (we like to log the results). I hope that helps! -steve -- Steve Wiser President Specialized Business Software 6325 Cochran Road, Unit 1 Solon, OH 44139 www.specializedbusinesssoftware.com www.docunym.com (440) 542-9145 - fax (440) 542-9143 Toll Free: (866) 328-4936 On Thu, Apr 11, 2013 at 9:29 AM, Nick Upson n...@telensa.com wrote: incremental backup is not recommended in firebird 2.1.5 under significant load, I wish I could On 11 April 2013 14:27, Ricardo Uzcategui ricardou...@cantv.net wrote: ** Hi. My experience is using SSD sata III 6BG IO speed with best results (in a mac bookpro with 16 gb ram). and, are you considering to use incremental backup? On Thu, Apr 11, 2013 at 8:14 AM, Norman Dunbar nor...@dunbar-it.co.uk wrote: Ahem ... On 11/04/13 13:26, Norman Dunbar wrote: I've updated the gbak manual to reflect the use of -g[arbage_collect] and -se[rvice] to speed up backups and restores, by adding a couple of sections explaing their use. Obviously, I didn't include -g[arbage_collect] in the restore section! Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links -- Ricardo... [Non-text portions of this message have been removed] -- Nick Upson, Telensa Ltd [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links This message and any files transmitted with it may contain information that is privileged, confidential, and exempt from disclosure under applicable law. They are intended solely for the use of the intended recipient. If you are not the intended recipient, distributing, copying, disclosing, or reliance on the contents of this communication is strictly prohibited. If this has reached you in error, kindly destroy this message and notify the sender immediately. Thank you for your assistance. We attempt to sweep harmful content (e.g. viruses) from e-mail and attachments, however we cannot guarantee their safety and can accept no liability for any resulting damage. The recipient is responsible to verify the safety of this message and any attachments before accepting them. [Non-text portions of this message have been removed]
Re: Re[2]: [firebird-support] gbak speed
On Thu, Apr 11, 2013 at 5:34 AM, Dmitry Kuzmenko k...@ibase.ru wrote: Hello, Nick! Thursday, April 11, 2013, 1:31:17 PM, you wrote: NU the database backup are already seperate devices were you thinking to add -g option to gbak command line? That has the downside of leaving old versions of records in the database, so if you use the -g switch, you should probably run a sweep occasionally. What you gain in the backup speed, you'll probably pay in the sweep time. Good luck, Ann [Non-text portions of this message have been removed]
Re: [firebird-support] multiple connection strings
On Thu, Apr 11, 2013 at 8:06 AM, Nick Upson n...@telensa.com wrote: possible new setup: all programs that access the database use the same path component as either /db/mydb.fdb - if running on the server and myhost:/db/mydb.fdb - if accessing it from elsewhere Dmitry has suggested that I should get significant performance improvement by avoiding the tcp stack but I recall (perhaps wrongly) there being issues with this approach. Your memory is fine, but not quite specific enough. InterBase 5.x had a problem with connection strings on Windows that caused it to make disjoint connections to a database, rapidly turning it to rubble. Fixed on Windows with Firebird 1 and never a problem on other systems. Good luck, Ann [Non-text portions of this message have been removed]
[firebird-support] Re: Bug-Fix from 2.1 to 2.5 in updating current row values?
11.04.2013 16:14, André Knappstein wrote: great! Thanks Dmitry! My friend Jaime will be more than happy that this conf setting will buy him some time to change the PSQL instead of doing a downgrade to 2.1 He will have to change his PSQL anyway once FB3 is released and he decides to upgrade. This config option is not available there. So it might make sense to do that sooner rather than later. Dmitry ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/