Subject | RE: [firebird-support] Firebird database executing DML queries very slowly. |
---|---|
Author | Joje |
Post date | 2019-01-29T07:29:38Z |
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