Not the answer you need?
Register and ask your own question!

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?

Answers

  • adivinhoadivinho Percona Percona Staff Role

    Hi,

    mysqld_exporter collects only cumulative data from information_schema.processlist table.

    e.g.


  • tcrowleytcrowley Current User Role Novice

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

  • adivinhoadivinho Percona Percona Staff Role

    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


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.