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

Support Sub Queries in Query Analytics for MySQL

    Details

    • Type: Improvement
    • Status: New
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 1.5.3
    • Fix Version/s: None
    • Component/s: QAN Agent, QAN API, QAN App
    • Labels:

      Description

      1. Install PMM 1.5.3
      2. Enable MySQL QAN monitoring
      3. Try to execute query with subquery , for example
        SELECT  ID, NAME    FROM CUSTOMERS    INNER JOIN  (SELECT OID from ORDERS as ORDERS) go ON CUSTOMERS.ID = CUSTOMERS.ID
        

        Result: QAN doesn't show this query and there is an error in qan-api.log:

        WARN: query crashes sqlparser: SELECT  ID, NAME    FROM CUSTOMERS    INNER JOIN  (SELECT OID from ORDERS as ORDERS) go ON CUSTOMERS.ID = CUSTOMERS.ID
        

      Expected result: QAN shows the query

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 Start watching this issue

                  Dates

                  • Created:
                    Updated: