1827286 Members
3325 Online
109717 Solutions
New Discussion

Re: IO stats in glance

 
SOLVED
Go to solution
Jason Preble
Occasional Contributor

IO stats in glance

What is the difference between Physical IO and Logical IO reported in glance?
3 REPLIES 3
Jeff Schussele
Honored Contributor

Re: IO stats in glance

Hi Jason,

Physical involves a read/writes all the way from/to the disk.
Logical reads/writes come out of the buffer cache.

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
Sridhar Bhaskarla
Honored Contributor

Re: IO stats in glance

Hi,

Physical IO -

To/From buffer cache from/to Disk if buffer cache is used

To/From application from/to Disk if buffer cache is not used

Logical IO

To/From Application from/to buffer cache.

-Sri
You may be disappointed if you fail, but you are doomed if you don't try
A. Clay Stephenson
Acclaimed Contributor
Solution

Re: IO stats in glance

Physical IO's are actual, honest-to-God go to the disk IO operations whereas Logical IO's access the buffer cache.

Consider the read of blocks 1-5 of myfile. The first time myfile is accessed a physical read must be done; the data is copied to the UNIX buffer cache; and the process is supplied with the data. Subsequent reads of those same blocks need only read (logical) from the buffer cache. Writes are handled in a similar manner (logical to cache) and then written to disk (physical) when system load permits or when the buffer cache must be flushed.
If it ain't broke, I can fix that.