1827260 Members
2119 Online
109717 Solutions
New Discussion

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.