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

Polyglot Projects Percona Toolkit
1

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

3

Thanks!