Regarding Monitoring Details

by Jul 15, 2015

Hi,

 

I have just installed the trail version of MONyog & I am able to successfully connect it to my DB server but I have few queries.

 

1. In Monitoring Section, Index Usage is showing warnings like SELECTs requiring full table scan, Percentage of full table scans etc. Check the attached file for the same.

 

How can I get the details of table/queries which are using full table scan ? 

 

2. Similarly In the Table Cache & Locks Section, System is showing "Number of table cache misses: 38.28K (12.708/sec)".

 

It means system is not able to cache tables/seconds ? How can I get the details of these tables.

 

 

Thanks

Ashish Kumar