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

qh.Profile: No query classes for selected instance and time range.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Cannot Reproduce
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: QAN App
    • Story Points:
      0.5

      Description

      QAN API error: "qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.".
      Check the /var/log/qan-api.log file in docker container for more information.
      

      The very popular issue, when our QAN use slowlog (default devaviour) with default slowlog settings in mysql (long_query_time = 1 second).
      we don't have queries to analyze because of no queries in slow log.

      I think we should

      • or add this error to FAQ
      • or improve message with a link to the recommended settings
      • or teach pmm-admin to detect this situation.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                mykola.marzhan Mykola Marzhan
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: