Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-2827

PMM querying performance_schema.events_statements_history multiple times a second

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: 1.13.0
    • Fix Version/s: None
    • Component/s: PMM Client, QAN Agent
    • Labels:

      Description

      When Query Example is enabled, mysql_exporter is querying performance_schema.events_statements_history multiple times a second:

      2018-08-10T21:16:44.001440Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:44.899233Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:45.896841Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:46.001541Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:46.899212Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:47.896823Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:48.001428Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:48.899192Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:49.896830Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:50.001407Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      2018-08-10T21:16:50.899241Z	  144 Query	SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history
      

      Is this intended or getQueryExamples worker is been called more times than it should?

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  marcelo.altmann Marcelo Altmann
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: