| Subject | Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed? |
|---|---|
| Author | liviuslivius@poczta.onet.pl |
| Post date | 2013-12-12T11:12:49Z |
Hi,
Thank you for response.
My pagesize is 16k and pages cache is set to 65536. And this can not be that.
I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value = 120637. Database have 6685 pages what is corelated with real db size = ~104MB
Regards,
Karol Bieniaszewski
Thank you for response.
My pagesize is 16k and pages cache is set to 65536. And this can not be that.
I see in MON$PAGE_READS small value = 585 but in MON$PAGE_FETCHES value = 120637. Database have 6685 pages what is corelated with real db size = ~104MB
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: hvlad@...
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] RE: MON$IO_STATS -> MON$PAGE_FETCHES - wrong values or as designed?
Data: czw., gru 12, 2013 09:38
Od: hvlad@...
Do: <firebird-support@yahoogroups.com>
Temat: [firebird-support] RE: MON$IO_STATS -> MON$PAGE_FETCHES - wrong values or as designed?
Data: czw., gru 12, 2013 09:38
---In firebird-support@yahoogroups.com, <liviuslivius@...> wrote:
> In MON$IO_STATS - MON$PAGE_FETCHES field i see reads 120637 pages but my whole test database have only 6685 pages.> Is something wrong with counters when status of statement is 2 in field MON$STATE?
Your page cache is definitely less than 6685, so some pages could be read from disk many times...
Regards,
Vlad