Inquire about slow query gathering in telegraf for mysql

InfluxDB 2
,
1

Hello,

Would like to ask if what metric can we use to monitor slow queries using Niffler DB (telegraf) monitoring for mysql.

2

Hi @John_Paul_Tomelden,
You can find the full list of metrics monitored by the MySQL input plugin here: telegraf/plugins/inputs/mysql at master · influxdata/telegraf · GitHub

I would potentially look to enable:

 ## gather metrics from PERFORMANCE_SCHEMA.TABLE_IO_WAITS_SUMMARY_BY_TABLE
  # gather_table_io_waits = false

This might provide the metrics you are looking for