Did you run a Sweep before backup?
On 05/05/2015 08:02, Nick Upson [email protected] [firebird-support] wrote:
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 [email protected]
<mailto:[email protected]> [firebird-support]
<[email protected]
<mailto:[email protected]>> wrote:
On 5-5-2015 12:15, Nick Upson [email protected]
<mailto:[email protected]> [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
