Subject | SELECT MON$PAGE_READS, MON$PAGE_WRITES, MON$PAGE_FETCHES, MON$PAGE_MARKS FROM MO |
---|---|
Author | jeanluk.picard |
Post date | 2010-11-30T18:12:19Z |
hello,
i follow this article
http://www.firebirdsql.org/manual/fbcache-mon-io-stats.html
when i do :
SELECT MON$PAGE_READS FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 0; //The database as a whole.
i receive :
107
but when i do
SELECT MON$PAGE_READS FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 1; //Attachments.
i receive :
107
190
98
97
97
97
97
97
97
97
654
98
so here the problem, why their is a difference between both ?
because normally the page read of the database at whole must be in all case greater (or equal) to the sum of the page read on each connections ?
i have the same problem for the memory stat ..
thanks by advance !
i follow this article
http://www.firebirdsql.org/manual/fbcache-mon-io-stats.html
when i do :
SELECT MON$PAGE_READS FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 0; //The database as a whole.
i receive :
107
but when i do
SELECT MON$PAGE_READS FROM MON$IO_STATS
WHERE MON$STAT_GROUP = 1; //Attachments.
i receive :
107
190
98
97
97
97
97
97
97
97
654
98
so here the problem, why their is a difference between both ?
because normally the page read of the database at whole must be in all case greater (or equal) to the sum of the page read on each connections ?
i have the same problem for the memory stat ..
thanks by advance !