|Subject||Re: [firebird-support] FB 2.1 64 Bits on Win 2003 64, issue with transactions|
> We have moved to FB 2.1 64 bits on windows 3 weeks ago, and we areUse MON$xxx tables and search for attachment of tx 1507. Look at application which
> experiencing a strange issue, the oldest transations remains low,
> while the next transaction keeps growing, and the database sweep does
> not fix the issue. The database is onlyne 24x7, and it use to work
> fine under FB 2.0
> Also the Bumped transaction = 1 never dissappears, even after backup
> and restare.
> The following is the copy from Statistics:
> Flags 0
> Checksum 12345
> Generation 14501
> Page size 16384
> ODS version 11.1
> Oldest transaction 1506
> Oldest active 1507
> Oldest snapshot 1507
holds it and fix it to not hold transaction too long.
> Next transaction 14489You've allocated 54200 *16 KB = 867200 KB ~ 847 MB for page cache. Are you sure you
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 1852
> Implementation ID 26
> Shadow count 0
> Page buffers 54200
need so big page cache ? How much RAM do you have ?
> Next header page 0Why do you lower sweep interval from default 20000 ?
> Database dialect 3
> Creation date Jul 14, 2008 20:27:49
> Attributes force write
> Variable header data:
> Sweep interval: 10000