Active Connections and Processes with PMM

Percona Monitoring and Management (PMM) Database Monitoring and Management
1

I have a MySQL DB 5.7.30. I would like to be able to get into all active connections to the DB and see what is being run, against what scheme and by what user. Percona’s AuditLog is suppose to do this but am reluctant to install the plugin on a production database at this time. I like the fact this monitor uses a direct connection to the DB to get its metrics.

Can the PMM solution do this?
Thanks!
Jason

1 Like
2

Hello @devdewboy,
PMM scrapes the queries from your slow query log and aggregates the execution statistics. There are filters for schema and user available when using Query Analytics feature of PMM. You can look at https://pmmdemo.percona.com to take a look before setting up PMM.

1 Like