Not the answer you need?
Register and ask your own question!

Using pt-query-digest to convert general log to slow log format for pt-index-usage ?

sheersheer EntrantCurrent User Role Beginner
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?


  • jriverajrivera Percona Support Engineer Percona Staff Role
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.