|Subject||Re: [firebird-support] My uncommited transaction is growing fast|
my developer already check the codes and they said all closed properly. So
On 10/6/06, Martijn Tonies <m.tonies@...> wrote:
> > I've notice that my so called uncommited transaction is growing very
> > The way I calculated this is by substacting the "Oldest Transaction"
> > the "Oldest Active" form the gstat -h output. How to go about this?Any
> > pointer is much appreciated.
> Fix the transaction handling in your application.
> Somewhere, uncommitted transactions are lying around.
> Rule of thumb:
> - keep transactions as short as possible.
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
> MS SQL Server
> Upscene Productions
> My thoughts:
> Database development questions? Check the forum!
> > When the difference gets to hundreds of millions the db will be very
> > processing requests. At this point I need to do a backup restore.
> > I need to do this at least twice a month. I've just do a backup restore
> > yesterday and look at the difference between "Oldest Transaction" and
> > "Oldest Active"
> > Database header page information:
> > Flags 0
> > Checksum 12345
> > Generation 3645883
> > Page size 8192
> > ODS version 10.1
> > Oldest transaction 2600080
> > Oldest active 2623121
> > Oldest snapshot 2600081
> > Next transaction 3645871
> > Bumped transaction 1
> > Sequence number 0
> > Next attachment ID 0
> > Implementation ID 19
> > Shadow count 0
> > Page buffers 4000
> > Next header page 0
> > Database dialect 3
> > Creation date Oct 4, 2006 18:26:40
> > Attributes force write
> > Variable header data:
> > Sweep interval: 0
> > *END*
> > If it matters the application that uses this db is a web base java
> > application.
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
> Also search the knowledgebases at http://www.ibphoenix.com
> Yahoo! Groups Links
And whoever does an atom's weight of evil will see it.
[Non-text portions of this message have been removed]