Using Percona pt-query-digest to analyse slow query log for a specific database only

Question

Percona tool script, pt-query-digest, looks like it 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

Bill Karwin · Accepted Answer · 2012-12-10T00:32:32.387

0

pt-query-digest --filter '$event->{db} eq "mydatabase"' ...other arguments...

edited Dec 10 '12 at 00:32

answered Dec 10 '12 at 00:21

Bill Karwin

538,548
86
673
828

Using Percona pt-query-digest to analyse slow query log for a specific database only

1 Answers1