GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-query-digest how to use for a specific database only to analyse slow query log

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

  • pt-query-digest how to use for a specific database only to analyse slow query log

    Percona tool script, pt-query-digest, looks like its will be very useful to analyse a MySQL slow query log. Does someone know how I can get the script to only look at queries relating to a specific database?

    Thanks

  • #2
    Hi,

    You can use the filters for that. For example, you can add the following filter if you want to check only the events in "mydb"

    --filter '($event->{db} || "") =~ m/mydb/'

    More information: http://www.percona.com/doc/percona-toolkit/2.1/pt-query-dige st.html#cmdoption-pt-query-digest--filter

    Martin Arrieta
    @martinarrietac

    Comment


    • #3
      Thanks!

      Comment

      Working...
      X