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

LP #1377888: [DOC] Manual for pt-query-digest --type binlog is ambiguous

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Przemek last update 14-11-2014 14:15:02

      The manual suggests that the pt-query-digest is able to parse a raw binary log file, while it can only parse a file which was decoded with mysqlbinlog tool before.
      http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html#cmdoption-pt-query-digest--type

      Moreover, the tool does not write any errors when we try to parse raw binlog:

      pt-query-digest --type binlog master/data/mysql-bin.000003

      1. 290ms user time, 10ms system time, 33.70M rss, 228.73M vsz
      2. Current date: Mon Oct 6 13:17:59 2014
      3. Hostname: pmlap
      4. Files: master/data/mysql-bin.000003
      5. Overall: 0 total, 1 unique, 0 QPS, 0x concurrency ______________________
      6. Time range: unknown
      7. Attribute total min max avg 95% stddev median
      8. ============ ======= ======= ======= ======= ======= ======= =======
      9. Query size 1.12k 1.12k 1.12k 1.12k 1.12k 0 1.12k
      1. Profile
      2. Rank Query ID Response time Calls R/Call V/M Item
      3. =========== =========== =========== =========== =========== ===== ======

      In PTDEBUG=1 we can see:

      1. Pipeline:11527 28350 Pipeline process BinaryLogParser
        \ogParser:9635 28350 bins2Ttx5.6.21-logs2T8
      2. BinaryLogParser:9687 28350 Got the query/arg line at pos 109
      3. BinaryLogParser:9708 28350 It's not a query/arg, it's just some SQL fluff
      4. BinaryLogParser:9743 28350 Properties of event: $VAR1 = [
      5. 'pos_in_log',
      6. 0,
      7. 'cmd',
      8. 'Query',
      9. 'ts',
      10. undef,
      11. 'arg',
        \s2Ttx5.6.21-logs2T8
      12. -/s2Tv!@std!!
        testDROP TABLE `test`.`t1` /* generated by server */ns2T~l!@std!!
        testcreate table test.t1 (id int auto_increment primary key)[s2TD@std!BEGIN+ts2T-Ftestt1*!^s2T(FOs2T(uF%s2Tev2TD@std!BEGINlY?v2T-Ftestt1v2T(-F95Jv2TL)Nw2T/{mysql-bin.000004OU',1

      13. 'bytes',
      14. 1147
      15. ];

      No clear errors though.

        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: