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

QAN explain doesn't rewrite UDPATE queries

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Duplicate
    • None
    • None
    • None
    • None

    Description

      EXPLAIN does not work for non-SELECT statements if the pmm user has only limited privileges

      EXPLAIN DELETE/INSERT/REPLACE/UPDATE requires the user to have the corresponding privilege, there is an open MySQL bug: https://bugs.mysql.com/bug.php?id=73258

      the preferred fix would be to rewrite those statements to a SELECT, similar to the PMM 1 qan-agent (https://github.com/percona/qan-agent/blob/master/query/plugin/mysql/explain/transform.go)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              scf M
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Smart Checklist