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

QAN: truncated queries don't show up in QAN with certain filters

Details

    Description

      User impact:

      Truncated queries don't show up in QAN when user filters by Node Name, Database, User Name, ...

      Steps to reproduce:

      Add a service to monitoring with pmm-admin with --max-query-length flag

      pmm-admin add mysql --username=msandbox --password=msandbox --max-query-length=10 slow-max-10 --cluster=MYSQLCLUST 127.0.0.1:8031

      Go to QAN and filter queries by Service Name "slow-max-10" >> only queries truncated after 10 char listed
      Now filter queries by User Name "msandbox" >> none of the listed queries is truncated

      Actual result:

      Some filters give unexpected results

      Expected result:

      We should see truncated queries too with all filters

      Workaround:

       

      Details:

      Peek 2022-11-03 17-24.webm

      Attachments

        Activity

          People

            jiri.ctvrtka Jiří Čtvrtka
            beata.handzelova1 Beata Handzelova (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist