On 12/21/2011 12:08 PM, Thomas Steinmaurer wrote:

>
> > it's a disaster .... i disable the gfix -sweep every night and launch it
> > only when the difference between oldest transaction and next transaction
> > is> 20 000 but this become true only after 5 hours :( so at the end
> > everyday the difference between oldest transaction and next transaction
> > grow by more than 20 000 :(
> >
> > i can not run gfix everyday, it's took hours to finish :(
> >
> > what i can do ?
>
> Find the reason why you produce such a transaction gap within 5 hours.
> Is it just the OIT which is behind or OAT as well? What's the output of
> gstat -h?
>

ok, i think i found ... few hours ago the difference
between OIT and next transaction was 50 000 but
now i try again gstat -h and the difference if only 5 ...

Database header page information:
Flags 0
Checksum 12345
Generation 1003772708
Page size 8192
ODS version 11.2
Oldest transaction 1003732753
Oldest active 1003732754
Oldest snapshot 1003732754
Next transaction 1003732757
Bumped transaction 1
Sequence number 0
Next attachment ID 39942
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Oct 30, 2011 2:23:04
Attributes force write, no reserve

Variable header data:
Sweep interval: 0
*END*

i don't do any long transaction on the server but this is hard
to know if one select or update was not long to return as lot of
application are
connected to the database, but all application use the same procedure
to select or update the data :

procedure doSQL
begin
StartTransaction
Try
select or update data
committransaction
except
rollbacktransaction
end;
end;

for now the only explanation i see is that we do very lot of transaction
(average 225 / Secondes is it lot ?)
on the server and this why 20000 sean to be too little ... with around
19 millions transactions by days
i thing i must use much more than 20000 (1 million?)

How much transaction by second can firebird can handle ?


thanks for all

>

[Non-text portions of this message have been removed]