pt-index-usage Log file type

  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-index-usage Log file type

    I am attempting to deduce which indexes are not in use on a few RDS boxes. Without being able to run these tools locally, I have taken snapshot of those DBs and put them up on my local machine. At this point pt-index-usage is looking to use the slow or general query log to run the EXPLAINs against but I would like to check all of our extant SQL statements. Can I create a text file of all of the queries in sequence and feed that into pt-index-uasge?

    On this page http://hackmysql.com/mysqlidxchk he uses something he call a 'RawLog' which is what I intend to create. Can that type of log work?

    TIA for any help.

  • #2

    My initial thought it will work however, i didn't used pt-index-uage with RawLog.
    I will test it too and will get back to you on this.


    • #3
      Thank you for the assistance Mr. Irfan. I appreciate it.