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

This type of query is not supported for EXPLAIN.

    Details

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

      Description

      when I configured the client to pmm-server on mysql system. In the dashboard ,the explain section shows: This type of query is not supported for EXPLAIN, and  create section shows:SHOW CREATE TABLE t_fi_eas_record: Error 1046: No database selected. My fingerprit is 'SELECT * FROM t_fi_eas_record WHERE assist_account_content LIKE ? AND status !=? limit ?,?'. the server and client both are upgraded to  the latest version:1.9.1,but the issues are sitll produced. could you help to check what the root causes about the issues. Thank you  so much.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  lalit.choudhary Lalit Choudhary
                  Reporter:
                  mithrandir chang
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: