Re: ISAM ?
Posted in 1999
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Guru wrote:
>
> What is a difference between ISAM reads, disk reads, page reads, buf
> reads ?
> I can watch it by onstat but I don't know exactly what it is.
> Can YOU help me?
Sure. dskreads are the number of read requests made to disk, some may
be multiple page reads which is why this is lower than pagreads which
records the number of physical pages requested in the dskreads.
Bufreads is the number of times some data buffer was accessed for
reading. (1 - (pagread / bufreads) ) * 100 is %cached. The reads on
the isam line (second stats line) is number of calls to the RSAM
library read function which may include multi-page reads from disk or
from the buffer pool.
The write stats are similar.
Art S. Kagel