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

Feature to log all queries executed in mysql and view in Percona M and M.

Is is possible to save all queries executed in mysql in a file (grouped by days) and view in PMM.

Comments

  • Federico RazzoliFederico Razzoli Contributor Current User Role Patron
    I confess I'm not sure I understand the question :)

    I'm assuming that you already know how to log all queries in the slow query log but it's not enough for you. If I'm wrong please tell me and I'll show how to do that.

    To show the queries day by day in PMM, just select the correct time interval in the menu in the top of the page.

    If your problem is that PMM doesn't show all the queries, use pt-query-digest from Percona Toolkit instead. Use --limit '100%' to include all queries, and --since and --until to specify the time range.
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.