Subject large system slows over time
Author Nick Upson
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





Nick Upson, Telensa Ltd, Senior Operations Network Engineer
direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200