Is is possible to save all queries executed in mysql in a file (grouped by days) and view in PMM.
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.