Required/recommended settings for Percona Server when monitoring with PMM using slow query log?

Percona Monitoring and Management (PMM)
1

The PMM documentation indicates that Percona recommends using the Slow Query Log, instead of the Performance Schema for PMM if you are running Percona Server 8.0+.

My question is, if I configure my server to use the Slow Query Log with the following configuration variables as recommended by Percona:

slow_query_log=ON
log_output=FILE
long_query_time=0
log_slow_admin_statements=ON
log_slow_slave_statements=ON

…Should I then disable any or all of these settings which are recommended by Percona if using the Performance Schema?:

performance_schema=ON
performance-schema-instrument=‘statement/%=ON’
performance-schema-consumer-statements-digest=ON
innodb_monitor_enable=all

2

Disabling those performance_schema instruments will not gain you anything significant in terms of CPU/memory. I would leave them as-is. :slight_smile: