PMM2 - realtime 'full processlist' dashboard

In PMM2, I am trying to find a dashboard that is equivalent or similar to the Monyog ‘threads’ dashboard, which essentially shows the show fullprocesslist; output in near realtime.

Is there a similar dashboard in PMM2? If not, is it possible to create a custom dashboard that can display the full processlist with a quick refresh?

Hi,

mysqld_exporter collects only cumulative data from information_schema.processlist table.

e.g.

Thanks, that makes sense. Is there a way to replicate the Threads functionality with a custom query?

cq-processes.yml.txt

Here is an example of such query.

The file has to be renamed to cq-processes.yml and placed into the folder /usr/local/percona/pmm2/collectors/custom-queries/mysql/high-resolution

Also it’s required to restart pmm-agent