GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

can pt-query-digest support query call count trend?

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

  • can pt-query-digest support query call count trend?

    can pt-query-digest support query call count trend?

    when I find the slave is delay, I need to know why, sometimes it's not very obvious. So I use pt-query-digest to digest two different time section to compare, to find if some query rise too much.
    pt-query-digest --since="2013-09-26 22:35:00" --until="2013-09-26 22:45:00" --type=binlog mysql-bin.000806.sql>2235
    ​pt-query-digest --since="2013-09-26 22:25:00" --until="2013-09-26 22:35:00" --type=binlog mysql-bin.000806.sql>2225

  • #2
    pt-query-digest do support query call count. There is high summarized view of the unique events for pt-query-digest report. Fourth column in that contains "CALLS" column which points to the number of times the query executed. You can read more about it in pt-query-digest documentation.

    # Profile
    # Rank Query ID Response time Calls R/Call Apdx V/M Item

    Comment

    Working...
    X