Buy Percona ServicesBuy Now!

pt-query-digest 3.1.0 Analyze slow log error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-query-digest 3.1.0 Analyze slow log error

    An error occurred when I analyzed the slow log using the following command:
    [root@minghost ~]# pt-query-digest slow.log --user=root --password=123123 --socket=/mydata/mysql.sock --history D=test --since="2019-10-17 22:00:00" --until="2019-10-18 04:00:00"

  • #2
    Hello,

    Could you provide the slow log?
    or could you run query digest putting PTDEBUG=1 pt-query-digest <params> and attach the output?
    I cannot see not reproduce the error you mention.

    Regards

    Comment


    • #3
      Hello ,
      I am running correctly when using the following command
      [root@minghost ~]# pt-query-digest slow.log --user=root --password=123123 --socket=/mydata/mysql.sock --history D=test
      Should I not specify --since and --until when using --history?

      Comment


      • #4
        Hello,

        To read from the slog log without using the history table you can just run pt-query-digest <slow-log-file>
        If you want to use the history table, it is not mandatory to use --since nor --until and the --history parameter should have the DSN to connect to the db where the history will be saved like:
        pt-query-digest <slow-log-file> --history h=127.0.0.1,P=3306,u=user,p=password,D=database,t= table

        Regards

        Comment


        • #5
          Ok, thank you very much for your reply.

          Comment

          Working...
          X