this query is slow query in my database.
COUNT_READ, SUM_TIMER_READ, SUM_NUMBER_OF_BYTES_READ,
COUNT_WRITE, SUM_TIMER_WRITE, SUM_NUMBER_OF_BYTES_WRITE,
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?
– 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
You can disable this - see “Passing Options to Exporters” here
[url]Percona Monitoring and Management
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.