Could I know this query?

Percona Monitoring and Management (PMM) PMM 1.x
1

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

2

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

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

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

[url]Percona Monitoring and Management

You need

–collect.perf_schema.file_events=false

3

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.