XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None
    • Story Points:
      -2

      Description

      There seems to be bunch if issues in MySQL Exporter where data regards to mysql, performance_schema, information_schema is ignored.     We should remove this filter for the version we ship in PMM

      We do not want to turn the blind eye on something which can actually be cause of the problem.  If data needs to have option to be filtered out on display this is different story

       

      select
      object_schema,
      object_name,
      count_read_normal,
      count_read_with_shared_locks,
      count_read_high_priority,
      count_read_no_insert,
      count_read_external,
      count_write_allow_write,
      count_write_concurrent_insert,
      count_write_low_priority,
      count_write_normal,
      count_write_external,
      sum_timer_read_normal,
      sum_timer_read_with_shared_locks,
      sum_timer_read_high_priority,
      sum_timer_read_no_insert,
      sum_timer_read_external,
      sum_timer_write_allow_write,
      sum_timer_write_concurrent_insert,
      sum_timer_write_low_priority,
      sum_timer_write_normal,
      sum_timer_write_external
      from
      performance_schema.table_lock_waits_summary_by_table
      where
      object_schema not in (
      'mysql',
      'performance_schema',
      'information_schema'
      )

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              pz Peter Zaitsev
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: