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
http://www.upscene.com

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