Hi,
I'm trying to track down an intermittent performance issue, and I find I
don't have sufficient grasp of sweep behavior.
firebird 2.1.5 classic on centos
I understand that a sweep is started (new thread is created) when OST-OIT >
2 (by default). What I can't find documented is when this c
> I'm trying to track down an intermittent performance issue, and I find I
> don't have sufficient grasp of sweep behavior.
>
> firebird 2.1.5 classic on centos
>
> I understand that a sweep is started (new thread is created) when OST-OIT >
> 2 (by default). What I can't find documented is when
if 2 processes both see a gap > 2 will that result in 2 sweeps running
at the same time?
On 13 January 2013 10:12, Thomas Steinmaurer wrote:
> **
>
>
> > I'm trying to track down an intermittent performance issue, and I find I
> > don't have sufficient grasp of sweep behavior.
> >
> > fireb
Hello, Nick!
Monday, January 14, 2013, 5:52:49 PM, you wrote:
NU> if 2 processes both see a gap > 2 will that result in 2 sweeps running
NU> at the same time?
transaction start is serialized, i.e. no 2 transactions can start at
the same time. So, auto-sweep can not run 2 times at once.
Only
Hello, Nick!
Monday, January 14, 2013, 6:39:33 PM, you wrote:
NU> I'm think of something like this:
NU> process A starts a transaction & holds it open, holding the transaction
NU> counter
NU> (time & transactions pass)
NU> process B starts a transaction, sees gap > 2 & initiates sweep
...
No,
I'm think of something like this:
process A starts a transaction & holds it open, holding the transaction
counter
(time & transactions pass)
process B starts a transaction, sees gap > 2 & initiates sweep
process C starts a transaction, sees gap > 2 & (sweep or why not)?
On 14 January 20
HI Dmitry,
thanks, I thought that there should not be a second sweep run but needed to
make sure
And, transactions does not "holding the transaction counter".
maybe I said it badly, I meant that:
If I start a transaction, until I commit or rollback that stops the OAT
moving forward (holding the