mysqlperconamysql-slow-query-logpt-query-digest

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


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


Solution

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