Announcement

Announcement Module
Collapse
No announcement yet.

pt-query-digest not producing fingerprints, normalizing queries

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-query-digest not producing fingerprints, normalizing queries

    I'm trying to use pt-query-digest v2.2.7 to analyze my slow query log from standard mysql 5.5.33.
    I'm not sure if I'm doing something wrong but I don't see a query fingerprint in the output.
    Also it seems to not be normalizing some queries.

    Here is some output of two queries that I think should be the same.
    The only difference is whitespace

    # Query 7: 0.88 QPS, 0.00x concurrency, ID 0x76B57ADEE69582FD at byte 74429
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: 2014-03-11 15:11:05 to 15:11:31
    # Attribute pct total min max avg 95% stddev median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count 5 23
    # Exec time 4 2ms 39us 128us 66us 84us 21us 66us
    # Lock time 0 0 0 0 0 0 0 0
    # Rows sent 0 0 0 0 0 0 0 0
    # Rows examine 0 0 0 0 0 0 0 0
    # Query size 3 1.24k 54 59 55.26 56.92 1.61 54.21
    # String:
    # Databases idx_acnt
    # Hosts web11.idx.... (16/69%), web01.idx.... (7/30%)
    # Users idx_user
    # Query_time distribution
    # 1us
    # 10us ################################################## ##############
    # 100us ######
    # 1ms
    # 10ms
    # 100ms
    # 1s
    # 10s+
    # Tables
    # SHOW TABLE STATUS FROM `idx_acnt` LIKE 'mls_info'\G
    # SHOW CREATE TABLE `idx_acnt`.`mls_info`\G
    # EXPLAIN /*!50100 PARTITIONS*/
    SELECT * FROM mls_info WHERE mls_id='CA-SACMLS' LIMIT 1\G


    # Query 37: 0.50 QPS, 0.00x concurrency, ID 0xCE60EAE3FCAD414D at byte 60854
    # This item is included in the report because it matches --limit.
    # Scores: V/M = 0.00
    # Time range: 2014-03-11 15:11:27 to 15:11:31
    # Attribute pct total min max avg 95% stddev median
    # ============ === ======= ======= ======= ======= ======= ======= =======
    # Count 0 2
    # Exec time 0 155us 76us 79us 77us 79us 2us 77us
    # Lock time 0 0 0 0 0 0 0 0
    # Rows sent 0 0 0 0 0 0 0 0
    # Rows examine 0 0 0 0 0 0 0 0
    # Query size 0 114 57 57 57 57 0 57
    # String:
    # Databases idx_acnt
    # Hosts web11.idx.dev
    # Users idx_user
    # Query_time distribution
    # 1us
    # 10us ################################################## ##############
    # 100us
    # 1ms
    # 10ms
    # 100ms
    # 1s
    # 10s+
    # Tables
    # SHOW TABLE STATUS FROM `idx_acnt` LIKE 'mls_info'\G
    # SHOW CREATE TABLE `idx_acnt`.`mls_info`\G
    # EXPLAIN /*!50100 PARTITIONS*/
    SELECT * FROM mls_info WHERE mls_id = 'CA-SACMLS' LIMIT 1\G

    I don't know why these queries are not being considered to be the same query.
    Also how can I see the fingerprint of the queries.

    Thanks
Working...
X