Buy Percona ServicesBuy Now!

Could I know this query?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Could I know this query?

    hi,

    this query is slow query in my database.


    <Query>

    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

    https://pmmdemo.percona.com/graph/da...esh=1m&orgId=1

    You can disable this - see "Passing Options to Exporters" here

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

    You need

    --collect.perf_schema.file_events=false

    Comment


    • #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.
      Last edited by bckim; 01-24-2018, 09:50 PM.

      Comment

      Working...
      X