Subject | Re: [firebird-support] FB 2.1.1 - gstat x mon$ tables: which is correct? |
---|---|
Author | Roberto Carlos |
Post date | 2008-11-10T20:32:20Z |
On Saturday, they were different, but today they are the same. Here they are:
Mon Nov 10 17:59:51 BRST 2008
Database "names.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 75356
Page size 16384
ODS version 11.1
Oldest transaction 28879
Oldest active 28880
Oldest snapshot 28880
Next transaction 75347
Bumped transaction 1
Sequence number 0
Next attachment ID 187
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 10, 2008 3:24:23
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
*END*
MON$DATABASE_NAME = '/srv/homeostase/dados/HCobranca21.fdb'
MON$PAGE_SIZE = 16384
MON$ODS_MAJOR = 11
MON$ODS_MINOR = 1
MON$OLDEST_TRANSACTION = 28879
MON$OLDEST_ACTIVE = 28880
MON$OLDEST_SNAPSHOT = 28880
MON$NEXT_TRANSACTION = 75435
MON$PAGE_BUFFERS = 2048
MON$SQL_DIALECT = 3
MON$SHUTDOWN_MODE = 0
MON$SWEEP_INTERVAL = 0
MON$READ_ONLY = 0
MON$FORCED_WRITES = 1
MON$RESERVE_SPACE = 0
MON$CREATION_DATE = '10.11.2008, 03:24:23.286'
MON$PAGES = 202929
MON$STAT_ID = 1
MON$BACKUP_STATE = 0
Mon Nov 10 18:16:53 BRST 2008
Database "names.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 77584
Page size 16384
ODS version 11.1
Oldest transaction 28879
Oldest active 28880
Oldest snapshot 28880
Next transaction 77575
Bumped transaction 1
Sequence number 0
Next attachment ID 188
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 10, 2008 3:24:23
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
*END*
Thanks.
Roberto Carlos
Em 16:34, Dmitry Yemanov escreveu:
Roberto Carlos wrote:
mon$statements only. I'd be interested in seeing the values of
mon$database as well (also between two gstat executions).
Dmitry
[Non-text portions of this message have been removed]
Mon Nov 10 17:59:51 BRST 2008
Database "names.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 75356
Page size 16384
ODS version 11.1
Oldest transaction 28879
Oldest active 28880
Oldest snapshot 28880
Next transaction 75347
Bumped transaction 1
Sequence number 0
Next attachment ID 187
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 10, 2008 3:24:23
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
*END*
MON$DATABASE_NAME = '/srv/homeostase/dados/HCobranca21.fdb'
MON$PAGE_SIZE = 16384
MON$ODS_MAJOR = 11
MON$ODS_MINOR = 1
MON$OLDEST_TRANSACTION = 28879
MON$OLDEST_ACTIVE = 28880
MON$OLDEST_SNAPSHOT = 28880
MON$NEXT_TRANSACTION = 75435
MON$PAGE_BUFFERS = 2048
MON$SQL_DIALECT = 3
MON$SHUTDOWN_MODE = 0
MON$SWEEP_INTERVAL = 0
MON$READ_ONLY = 0
MON$FORCED_WRITES = 1
MON$RESERVE_SPACE = 0
MON$CREATION_DATE = '10.11.2008, 03:24:23.286'
MON$PAGES = 202929
MON$STAT_ID = 1
MON$BACKUP_STATE = 0
Mon Nov 10 18:16:53 BRST 2008
Database "names.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 77584
Page size 16384
ODS version 11.1
Oldest transaction 28879
Oldest active 28880
Oldest snapshot 28880
Next transaction 77575
Bumped transaction 1
Sequence number 0
Next attachment ID 188
Implementation ID 19
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 10, 2008 3:24:23
Attributes force write, no reserve
Variable header data:
Sweep interval: 0
*END*
Thanks.
Roberto Carlos
Em 16:34, Dmitry Yemanov escreveu:
Roberto Carlos wrote:
> So, should I ignore gstat information and give importance only to mon$ tabl=In your prior message, you showed the output for mon$transactions and
> es to garantee FB has no lost transaction due to bad programming code?
> PS: gstat keep informing oat 326 during the whole day in more than 20 thous=
> and transactions.
mon$statements only. I'd be interested in seeing the values of
mon$database as well (also between two gstat executions).
Dmitry
[Non-text portions of this message have been removed]