-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Fixed
-
Affects Version/s: 1.17.3, 2.5.0
-
Fix Version/s: 2.8.0
-
Component/s: Grafana Dashboards
-
Labels:None
-
Story Points:1
-
Sprint:Platform Sprint 18
-
Needs Review:Yes
-
Needs QA:Yes
The following formulas are used in graphs for "MySQL User Details -> Top Users by Rows Fetched/Read".
For version 1:
topk(5, rate(mysql_info_schema_user_statistics_rows_fetched_total{instance=~"$host"}[$interval])>0) or topk(5, irate(mysql_info_schema_user_statistics_rows_fetched_total{instance=~"$host"}[5m])>0) or topk(5, rate(mysql_info_schema_user_statistics_rows_read_total{instance=~"$host"}[$interval])>0) or topk(5, irate(mysql_info_schema_user_statistics_rows_read_total{instance=~"$host"}[5m])>0)
For version 2:
avg by (service_name,user) (topk(5, rate(mysql_info_schema_user_statistics_rows_fetched_total{service_name=~"$service_name"}[$interval])>0) or topk(5, irate(mysql_info_schema_user_statistics_rows_fetched_total{service_name=~"$service_name"}[5m])>0) or topk(5, rate(mysql_info_schema_user_statistics_rows_read_total{service_name=~"$service_name"}[$interval])>0) or topk(5, irate(mysql_info_schema_user_statistics_rows_read_total{service_name=~"$service_name"}[5m])>0))
The metric name currently used is
mysql_info_schema_user_statistics_rows_read_total
but should be
mysql_info_schema_user_statistics_table_rows_read_total
See attached screenshot.