Comments on: Request for Comments: Global Processlist in Percona Monitoring and Management https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/ Mon, 18 Apr 2022 05:39:18 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Vinay Pandey https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973588 Mon, 18 Apr 2022 05:39:18 +0000 https://www.percona.com/blog/?p=74438#comment-10973588 Must-have feature in PMM, also it would be great if we could send the current processes list to the number of email ids.

]]> By: Thomas https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973032 Sun, 21 Feb 2021 16:19:40 +0000 https://www.percona.com/blog/?p=74438#comment-10973032 Absolutely yes. When I check an unknown system, I always run “select * from information_schema.processlist where time > 1 and command != ‘Sleep’;” multiple times per minute to get an overall picture.

]]> By: Daniel https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973022 Mon, 15 Feb 2021 16:51:21 +0000 https://www.percona.com/blog/?p=74438#comment-10973022 In reply to Francisco Miguel Biete Banon.

You already can use peformance_schema as the source of QAN. The problem is that for example in Postgres there’s no P_S and the monitoring extension that Percona made is not available on RDS so one is stuck

]]> By: Francisco Miguel Biete Banon https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973020 Mon, 15 Feb 2021 15:57:51 +0000 https://www.percona.com/blog/?p=74438#comment-10973020 How different would this be to use performance_schema as the source of QAN data?
We have custom dashboards that show the current processlist of the server and allows to kill sessions, but we are missing the option to explain an active statement and see its history in the same screen.

]]> By: Aakash https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973019 Mon, 15 Feb 2021 12:31:07 +0000 https://www.percona.com/blog/?p=74438#comment-10973019 Sounds good. Also,it will be much helpful if we have options to list / ignore sleep or queries from particular host or particular pattern of queries along with kill and explain a connection as well.

]]> By: Jean-François Gagné https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973018 Sat, 13 Feb 2021 00:17:46 +0000 https://www.percona.com/blog/?p=74438#comment-10973018 This looks useful. In addition to that, the possibility to remotely run ps-top on a server. The use-case: a MySQL node is not healthy, in addition to knowing what is running now, I wan to see which table are queried (both in number of ops per second and latency as shown by ps-top) and which files are read from and written to (as shown by ps-top). The other view of ps-top are probably useful, but these 3 views would already be a good start.

]]> By: rautamiekka https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973017 Fri, 12 Feb 2021 20:42:40 +0000 https://www.percona.com/blog/?p=74438#comment-10973017 In reply to Daniel.

+1

]]> By: Daniel https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973016 Fri, 12 Feb 2021 18:23:17 +0000 https://www.percona.com/blog/?p=74438#comment-10973016 Adding a “quick analysis” or “live analysis” section to PMM can be a huge WIN. Here’s an example: Currently while using PMM to monitor Postgres RDS everything related to prometheus (actually Victoriametrics) works fine in terms of data freshness. However, QAN get lagged due the amount of nodes being monitored.

The workaround was to write a python script that get the last 1MB of the pg log, run pgBadger to analyze it and then use that for “hot debug”

What I will like to see on PMM? Something like that integrated, that doesn’t necessary go through the regular QAN code path but that feed the ClickHouse db so one can use the “Query Analyzer” dashboard. A kind of a merge.

For MySQL it can be the same with a pt-query-digest integrated, etc etc.

]]> By: rautamiekka https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973015 Fri, 12 Feb 2021 17:11:19 +0000 https://www.percona.com/blog/?p=74438#comment-10973015 Sounds like very useful !

]]> By: peterzaitsev https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973014 Fri, 12 Feb 2021 16:35:32 +0000 https://www.percona.com/blog/?p=74438#comment-10973014 In reply to tanuj.

Thanks!

]]> By: tanuj https://www.percona.com/blog/request-for-comments-global-processlist-in-percona-monitoring-and-management/#comment-10973013 Fri, 12 Feb 2021 14:28:34 +0000 https://www.percona.com/blog/?p=74438#comment-10973013 it will be extremely helpful to have a processlist view for any of the database choosen and have the option to kill the query /pid

]]>