Subject RE: [firebird-support] Firebird database executing DML queries very slowly.
Author Joje

Ran the command and got the header information from the client. Below is database header page information of the affected database : 

               

Flags                                      0 

                Checksum                           12345 

                Generation                         9101445 

                Page size                             4096 

                ODS version                       11.2 

                Oldest transaction           8991282 

                Oldest active                      9100701 

                Oldest snapshot               9100701 

                Next transaction              9100702 

                Bumped transaction       1 

                Sequence number                          0 

                Next attachment ID        24698 

                Implementation ID          26 

                Shadow count                   0 

                Page buffers                      0 

                Next header page           0 

                Database dialect               3 

                Attributes                           force write 

    Variable header data: 

                Sweep interval:                20000 

                *END* 

 

The difference between the oldest transaction and newest transaction is large.  

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Friday, January 25, 2019 20:32
To: firebird-support@yahoogroups.com
Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly.

 

 

Hi.

 

When you gain slowdows

Run

gstat -h

 

and put here results.

Problem probably is because of some long running transaction.

 

Regards,

Karol Bieniaszewski