My Oracle Support Banner

Session/s monitoring, Block_ops_in / Block_ops_out and Innodb_buffer_pool_read_requests meaning (Doc ID 2073701.1)

Last updated on JULY 19, 2016

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Goal

Q1: How to check or monitor resource usage of sessions such as Logical read , Physical read , Memory Usage.

 

Q2: What is the meaning of Block_ops_in / Block_ops_out which values are from query profiling?

 

Q3: What is the meaning of Innodb_buffer_pool_read_requests gathered by show session status ?

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.