Subject | gbak going slow |
---|---|
Author | stevemilner_2000 |
Post date | 2005-10-25T11:49:23Z |
I'm doing a daily backup of a 10GB firebird database (classic server
v1.5) using a cron job on the server hosting the database. Using FC4
on a twin 3.6 GHz Xeon machine.
If I use:
/opt/firebird/bin/gbak -b /path/to/database.gdb restore.gbk
the backup takes about 30 minues.
However if I use:
/opt/firebird/bin/gbak -b localhost:/path/to/database.gdb restore.gbk
the backup takes 7 hours.
/etc/hosts:
127.0.0.1 localhost
ifconfig shows:lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:4158543 errors:0 dropped:0
overruns:0 frame:0
TX packets:4158543 errors:0 dropped:0
overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:700653166 (668.1 MiB) TX
bytes:700653166 (668.1 MiB)
I'm assuming that the only 'safe' wasy to do this is via the
localhost: loop, but I'm baffled as to the time difference and I would
find any advice to speed the backup up helful.
Thanks,
Steve
v1.5) using a cron job on the server hosting the database. Using FC4
on a twin 3.6 GHz Xeon machine.
If I use:
/opt/firebird/bin/gbak -b /path/to/database.gdb restore.gbk
the backup takes about 30 minues.
However if I use:
/opt/firebird/bin/gbak -b localhost:/path/to/database.gdb restore.gbk
the backup takes 7 hours.
/etc/hosts:
127.0.0.1 localhost
ifconfig shows:lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:4158543 errors:0 dropped:0
overruns:0 frame:0
TX packets:4158543 errors:0 dropped:0
overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:700653166 (668.1 MiB) TX
bytes:700653166 (668.1 MiB)
I'm assuming that the only 'safe' wasy to do this is via the
localhost: loop, but I'm baffled as to the time difference and I would
find any advice to speed the backup up helful.
Thanks,
Steve