search

shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

Add table read/write io_waits dashboards in the table statistics section #199

Closed oblitorum closed 9 months ago

oblitorum commented 9 months ago

We need to add 2 table io_waits dashboards in the table statistics section, only show top 10 tables on each dashboards, example grafana queries are:

topk(10, sum(rate(mysql_perf_schema_table_io_waits_seconds_total{service="mysqld-exporter-nm-production",operation="fetch"}[2m])) BY (name))

topk(10, sum(rate(mysql_perf_schema_table_io_waits_seconds_total{service="mysqld-exporter-nm-production",operation=~"update|delete|insert"}[2m])) BY (name))

@jonathanvx