Subject | Re: One table become very slow |
---|---|
Author | marrtins_dqdp |
Post date | 2008-09-12T22:33:07Z |
What does it mean here total versions and max versions? Whats wrong
about that? How could it be fixed/avoided? Thank you for your help!
Header:
Database header page information:
Flags 0
Checksum 12345
Generation 44503
Page size 4096
ODS version 11.1
Oldest transaction 44493
Oldest active 44494
Oldest snapshot 44494
Next transaction 44495
Bumped transaction 1
Sequence number 0
Next attachment ID 12040
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Aug 25, 2008 21:57:39
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
about that? How could it be fixed/avoided? Thank you for your help!
Header:
Database header page information:
Flags 0
Checksum 12345
Generation 44503
Page size 4096
ODS version 11.1
Oldest transaction 44493
Oldest active 44494
Oldest snapshot 44494
Next transaction 44495
Bumped transaction 1
Sequence number 0
Next attachment ID 12040
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Aug 25, 2008 21:57:39
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:
>
>
> > CLIENTS (132)
> > Primary pointer page: 207, Index root page: 208
> > Average record length: 288.79, total records: 9403
> > Average version length: 9.00, total versions: 27565987, max
> > versions: 6180
> > Data pages: 209068, data page slots: 209849, average fill: 86%
>
> There's your problem!
>
> ...total versions: 27565987 !!!, max versions: 6180!!!
>
> What does the initial database header stats look like (Oldest
> Transaction, Oldest Active Transaction...)?
>
>
> Sean
>