Setup alerting for slow queries in PMM

Percona Monitoring and Management (PMM)
1

On pmm, I have setup alerting to send alerts to teams channel for things like high thread connections. Similarly, I would like to receive the top 5 slow queries in my teams channel.

Can someone guide me on how I can achieve this ?

Thanks

2 Likes
2

Hi @murali1 , welcome to the Percona forums!
At this time, there is no supported method to set up Integrated Alerting IA against Query data, since they are stored in two different databases (VictoriaMetrics VM vs ClickHouse) and IA only works against VM. I agree that using IA against ClickHouse would be fantastic.

You can try out this dashboard to visualize topk()

1 Like