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?



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: st.html#cmdoption-pt-query-digest–filter

Martin Arrieta