Subject Re: [firebird-support] large system slows over time
Author Thomas Steinmaurer
> Hi
> I have a system that is slowing down the longer it stays running and I'd
> like to know why.
> The system is running firebird 2.1.5 on centos 5 with an average of 27
> transactions per second and has now been running for 112 days. The data
> throughput is unchanged, data is removed from the db as fast as its added
> so the database remains roughly the same size at 130Gb.
> for example: on 1st Feb the backup took 4hr 35 min, last night took 9hrs 30
> min
> Is this a known 2.1 issue (move to 2.5 is in the planning stages)?
> Is there anything I can do to prevent or improve this situation?
> Is there any evidence I can gather before I reboot the system which I
> expect (from past experience) will return the system to the better
> performance

How does your backup call look like?

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.