In the most recent pt-index-usage manual, it says to use pt-query-digest to convert the general log to slow log format first. However, I can’t find any way with the most recent pt-query-digest tool to convert the general log to slow log - the --print option seems to have gone missing. Does anyone know how to do this?
I haven’t tried this but reading through the pt-query-digest manual you can convert general_log file to slow_log file using --type and -output like:
pt-query-digest --type genlog <general_log.file> --output slowlog > slow_log.txt
Then parse slow_log.txt with pt-index-usage.