The Problem: data received from INFORMATION_SCHEMA is cached for 24h so not really actual.
We should add "set session information_schema_stats_expiry=0" MySQL Command to get better data.
Note: This is session variable so we can change this on our side without impacting Database Server (Rule: don't change DB global settings is followed in this case )
QA: we need to ensure the behavior and performance are not affected after this implementation
Affected metrics are used for next elements:
|MySQL_Table_Details||Largest Tables by Row Count|
|MySQL_InnoDB_Details||Avg Row Size|
|Index Size Per Row|