Subject | Re: DB-file growth VERY rapidly!?? |
---|---|
Author | _a_x_e_ |
Post date | 2002-02-12T13:04:21Z |
Hello Paul,
it is a Perl-Script running on Debian-Linux, connecting to an Firebird
RC2 Server (running on another host, Debian-Linux too) using DBI für
connection.
No special transaction isolation, I use standard settings (should be
READ-WRITE, SNAPSHOT, WAIT)
My problem is not that data is not written into the database, that
works fine, ALL data is correctly written into the database during the
transactions, the problem is the enormous and rapid growing of the
database file, also the RAW data is MUCH smaller, the database-file
still continues growing even if there are ONLY updates! This space
seems to be never freed and used again, sweep does not help, database
restart does not help, only backup restore helps, but then file-size
continues to grow in same speed. 8 MB per day for only 160kb raw data
is too much!?
it is a Perl-Script running on Debian-Linux, connecting to an Firebird
RC2 Server (running on another host, Debian-Linux too) using DBI für
connection.
No special transaction isolation, I use standard settings (should be
READ-WRITE, SNAPSHOT, WAIT)
My problem is not that data is not written into the database, that
works fine, ALL data is correctly written into the database during the
transactions, the problem is the enormous and rapid growing of the
database file, also the RAW data is MUCH smaller, the database-file
still continues growing even if there are ONLY updates! This space
seems to be never freed and used again, sweep does not help, database
restart does not help, only backup restore helps, but then file-size
continues to grow in same speed. 8 MB per day for only 160kb raw data
is too much!?
--- In ib-support@y..., Paul Reeves <paul@f...> wrote:
> _a_x_e_ wrote:
> >
> > Hello Sven,
> >
> > here are three page-header-statistics, during this three update runs
> > the DB-file-size increased by 60kb per run. I don't know exactly if Ia
> > see it right, transaction 105 is hanging!??
> >
> > Oldest transaction 104
> > Oldest active 105
> > Oldest snapshot 105
> > Next transaction 12680
>
>
> What middleware are you using?
> What transaction isolation settings are you using?
>
> Paul
> --
>
> Paul Reeves
> http://www.ibphoenix.com
> taking InterBase further