-
Type:
Bug
-
Status: Done
-
Priority:
High
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 2.10.0
-
Component/s: MySQLd_Exporter, PMM ManageD
-
Labels:
-
Story Points:2
-
Sprint:Platform Sprint 22, Platform Sprint 23
-
Needs Review:Yes
-
Needs QA:Yes
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:
Dashboard | Element |
---|---|
MySQL_Table_Details | Largest Tables by Row Count |
MySQL_InnoDB_Details | Avg Row Size |
Index Size Per Row | |
Estimated Rows |