yes, large transaction gap was the first thing I checked

Nick Upson, Telensa Ltd, Senior Operations Network Engineer

direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200

On 5 May 2015 at 12:01, Mark Rotteveel mark@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote:

 

On 5-5-2015 12:15, Nick Upson nu@telensa.com [firebird-support] wrote:
> 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 4 hr 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

Have you checked for the existence of long running transactions (a high
transaction gap)?

Mark
--
Mark Rotteveel