Details

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

      Description

      I am using the QAN-agent for my home database in the performance schema mode.  Normally, the agent should do this query:

      SELECT DIGEST, CURRENT_SCHEMA, SQL_TEXT FROM performance_schema.events_statements_history

      at every second since the ticker for the worker is defined as:

      w.ticker = time.NewTicker(time.Millisecond * 1000)

      At about every hours, it seems that a new worker is instantiated and the rate increase by 1/s (see the graph).  I confirmed additional threads using "strace -fp pid-of-qan-agent" After a few weeks, my home database was doing 300+/s such query.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  yves@percona.com Yves Trudeau
                • Votes:
                  2 Vote for this issue
                  Watchers:
                  7 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 1 day, 4 hours, 30 minutes
                    1d 4h 30m