Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
1.17.3, 2.5.0
-
None
-
1
-
Platform Sprint 18
-
Yes
-
Yes
Description
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.