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?
mysqld_exporter collects only cumulative data from information_schema.processlist table.
Thanks, that makes sense. Is there a way to replicate the Threads functionality with a custom query?
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