| 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-12T14:59:03Z |
Hi,
Thanks you very much i see that i misunderstand fetches fetchesield previously. Now it is clear - for 59732 records it is possible to have 120637 fetches :)
Regards,
Karol Bieniaszewski
Thanks you very much i see that i misunderstand fetches fetchesield previously. Now it is clear - for 59732 records it is possible to have 120637 fetches :)
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: hvlad@...
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Data: czw., gru 12, 2013 14:52
Od: hvlad@...
Do: <firebird-support@yahoogroups.com>
Temat: Odp: [firebird-support] RE: MON$IO_STATS -> M ON$PAGE_FETCHES - wrong values or as designed?
Data: czw., gru 12, 2013 14:52
---In firebird-support@yahoogroups.com, <liviuslivius@...> wrote:
> 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
Oops, i mixed reads vs fetches :) Fetch is access to the page in page cache. To process (select)
one *row*, Fierbird need to make 2 fetches at least, for example. So, i see nothing strange here.
Regards,
Vlad