Subject Re: [firebird-support] slower backup after upgrade from classic to superserver
Author Erich Sturm
Helen Borrie schrieb:
> At 10:24 PM 22/01/2006, you wrote:
> >Hello,
> >
> >I have the problem, that the backup time is grown up very high after
> >the upgrade from the classicserver (1.0) to the superserver (1.5).
> >With the classicserver gbak makes the backup for a 5 GB database in 30
> >to 40 minutes. After the upgrade the same backup needs more then 3 hours.
> >An other 19 GB database needs more then 8 houres.
> >The restore ist very slow too and this is my greatest problem. The
> >databases are used in medical environments and more then 3 or 8 hours
> >for a restore is a very long time.
>
> It is too long - something is wrong. Your "upgrade" was not
> Classic-->Superserverbut v.1.0 --> v.1.5. Gbak performance should be
> the same or better
> under v.1.5.
Both is right. The Upgrade is from v. 1.0 to v 1.5 and from classic to
the superserver. If I go back to the 1.5 classicserver the backup runs
fast again.

One machine is an IBM Server with P4 with 4GB RAM, the other machine was
an AMD Opteron 8 GB DRR RAM.

> You provided no detail about which Linux/Unix platform you are
> running Firebird on nor how you are invoking gbak.
The OS on the P4 was first SuSE Linux 9.3, then Debian 3.1 Sarge with
2.6 Kernel, on the Opteron only Debian 3.1 Sarge with 2.6 Kernel.

gbak started with "gbak -b -v"

The Backup's are running every night. One time per month a validation
and a garbage collection was done. The database looks good. No error
messages.


Thanks
Erich


--
*two2boot*
Erich Sturm

Dürerstr. 56
28844 Weyhe

Tel.: 0421/59 77 99 1
Fax: 0421/89 84 85 2
Mobil: 0170/52 46 86 2
Mail: e.sturm@...

* www.two2boot.de*



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