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 m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote: > > > On 5-5-2015 12:15, Nick Upson n...@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 > >