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.
Cristiano
[URL]https://www.facebook.com/chunsondz/[/URL]

1 Like
2

In my environment this query chokes the MySQL RDS instance CPU because PMM runs it through 10 parallel DB sessions (each statement runs more than 5 minutes!).

Another long running query I see they run is:
SELECT EVENT_NAME, COUNT_STAR, SUM_TIMER_WAIT
FROM performance_schema.events_waits_summary_global_by_event_name

1 Like