Could I know this query?

hi,

this query is slow query in my database.

SELECT
EVENT_NAME,
COUNT_READ, SUM_TIMER_READ, SUM_NUMBER_OF_BYTES_READ,
COUNT_WRITE, SUM_TIMER_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
COUNT_MISC, SUM_TIMER_MISC
FROM performance_schema.file_summary_by_event_name;

as I know, this query is executed by pmm

and it takes 3~4 sec.

could I know which graph is related with this query?

and, could I turn off this query in pmm?

thanks.

– pmm version : 1.6.0

How many records do you have in this table ? These are used in “MySQL Performance Schema” dashboard such as this one

https://pmmdemo.percona.com/graph/dashboard/db/mysql-performance-schema?refresh=1m&orgId=1

You can disable this - see “Passing Options to Exporters” here

https://www.percona.com/doc/percona-monitoring-and-management/pmm-admin.html

You need

–collect.perf_schema.file_events=false

yes. this database has 400,000 tables.

so I think this performance schema table has so many meta data.

I could solve this problem by turnning off the option.

thank you.