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

pt-query-digest and prepare statements

joyalaugustinejoyalaugustine EntrantInactive User Role Beginner
I am using pt-query-digest from Percona Toolkit and I found out that the tool is not examining the prepare or execute statements from MySQL query log.Could you please tell if it is possible to analyse prepare statements from log at all.

Comments

  • joyalaugustinejoyalaugustine Entrant Inactive User Role Beginner
    Eventually, I found out a solution by myself.Replace all occurrences of the word "prepare" or "execute" with the term "query" and save the corrected copy and let pt-query run on the copy.Other than this solution, I couldn't find any other way out of this.In Linux, I am using command sed for replacing and backup.Hopes this will help someone comes across this.
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.