Subject | RE: [firebird-support] Backing up (gbak) slows other operations |
---|---|
Author | Nick |
Post date | 2005-09-13T18:56:01Z |
what is your command line for gbak
--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of terriertech
Sent: 13 September 2005 19:31
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Backing up (gbak) slows other operations
Hi all, I have sites that are working with a datafile 24 hours/day.
Backups are run using gbak via a windows scheduled task at 4 am.
Users are complaining that the backup slows down their work to a
crawl. The GDB file is about 1.5 GB, the GBK file is about 1.4 GB,
and the backup takes ~10 min. The server has 1 GB of RAM.
Any hints for improving the client speed during backup? I am going to
try lowering the priority of the gbak script process, but I suspect
that everything is farmed off to the server process so this won't make
a difference.
Thanks!
Justin R
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq
+technical+support&w5=Hewlett+packard+technical+support&w6=Technical+support
+services&c=6&s=195&.sig=s2Gugju7oqbFSnQe5CXN-g> support Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical
+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&
w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technica
l+support+services&c=6&s=195&.sig=P0EO8-oNi-ENyo4f44hTrg> technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Te
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=T
echnical+support+services&c=6&s=195&.sig=yxbBDDzaSk3A5ChUmIsGQg> computer
technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+s
upport&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4
=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technical+
support+services&c=6&s=195&.sig=waTmaDVJ1O5EVV9ojJdNIA> technical support
Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Te
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=T
echnical+support+services&c=6&s=195&.sig=BHeXNb70xUEL93wl8IkWbQ> packard
technical support Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support+services&w1=Technical
+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&
w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technica
l+support+services&c=6&s=195&.sig=V7eKfOJm-lo7uSPyz1mcEA> support services
_____
YAHOO! GROUPS LINKS
* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.
* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of terriertech
Sent: 13 September 2005 19:31
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Backing up (gbak) slows other operations
Hi all, I have sites that are working with a datafile 24 hours/day.
Backups are run using gbak via a windows scheduled task at 4 am.
Users are complaining that the backup slows down their work to a
crawl. The GDB file is about 1.5 GB, the GBK file is about 1.4 GB,
and the backup takes ~10 min. The server has 1 GB of RAM.
Any hints for improving the client speed during backup? I am going to
try lowering the priority of the gbak script process, but I suspect
that everything is farmed off to the server process so this won't make
a difference.
Thanks!
Justin R
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq
+technical+support&w5=Hewlett+packard+technical+support&w6=Technical+support
+services&c=6&s=195&.sig=s2Gugju7oqbFSnQe5CXN-g> support Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical
+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&
w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technica
l+support+services&c=6&s=195&.sig=P0EO8-oNi-ENyo4f44hTrg> technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Te
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=T
echnical+support+services&c=6&s=195&.sig=yxbBDDzaSk3A5ChUmIsGQg> computer
technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+s
upport&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4
=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technical+
support+services&c=6&s=195&.sig=waTmaDVJ1O5EVV9ojJdNIA> technical support
Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Te
chnical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+s
upport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=T
echnical+support+services&c=6&s=195&.sig=BHeXNb70xUEL93wl8IkWbQ> packard
technical support Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support+services&w1=Technical
+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&
w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Technica
l+support+services&c=6&s=195&.sig=V7eKfOJm-lo7uSPyz1mcEA> support services
_____
YAHOO! GROUPS LINKS
* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.
* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]