In MYSQL status, Handler_read_rnd_next value is very high.
I am aware that, this value will be incremented when a query is executed which is not having proper indexes.
But, even when we execute show status like 'Handler_read_rnd_next', this value is getting incremented by 2.
Based on this status flag, we are monitoring some stats.
So every time, this stats are showing critical.
Can we exclude these 'show' execution counts from 'Handler_read_rnd_next' count.
One more example for this,
There is a table with 10 rows, table is indexed on column 'data', and if we execute the following query:
select data from test where data = 'vwx' -> returns one row
and if we check value of 'Handler_read_rnd_next', it got incremented by 7.
Following is result of explain command for the above query:
explain select data from test where data = 'vwx'; id, select_type, table, type, possible_keys, key, key_len, ref, rows, Extra 1, 'SIMPLE', 'test', 'ref', 'data', 'data', '35', 'const', 1, 'Using where; Using index'
Is there any way to restrict this value, or can i know why this value is getting incremented very fast.