Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-905

LP #899034: pt-query-digest create-review-table fails to create table

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Kingsquare last update 16-12-2011 16:13:20

      After an installation via the .deb (on an Ubuntu 8.04.4 Ubuntu box) I've placed an configuration file in
      /etc/percona-toolkit/percona-toolkit.conf as follows:
      A=utf8
      h=localhost
      p=percona
      u=percona

      Bug: Adding a D configuration parameter (and value) fails every call to 'pt-query-digest' with an 'Unknown option: D'
      documentation bug: the DSN port / password are both lowercased in the documentation

      Moving all parameters into the comandline like:

      pt-query-digest --create-review-table A=utf8,h=localhost,p=percona,u=percona,D=percona-toolkit,t=review

      fails. (or seems to wait for input)

      Adding a slow log to the call:
      pt-query-digest --create-review-table A=utf8,h=localhost,p=percona,u=percona,D=percona-toolkit,t=review ./slowlog.log

      doesnt create a table (even if the user does have the correct rights in the database)

      The same goes for the history-variant of the --review option.

      Also i feel that the documentation is lacking in the usage of the --review and --review-history options of the query-digest. I have a feeling that this could very well be very usefull (allowing monitoring of query optimization progress due to schema changes etc) but for now i have no clue as to apply these techniques to good use...

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: