Filter AuroraMysql slow query log file by specific queries

Question

I downloaded the slow query log file from Aurora Mysql. I want to playback these queries but separate them to just writes and reads. So a tool to extract only selects, or Inserts+Updates would be nice

For "playback" it might be better to capture the "general log". — Rick James, Jun 13 '20 at 22:11

score 0 · Accepted Answer · answered Jun 11 '20 at 16:43

0

Found it! we can use pt-query-digest

pt-query-digest mysql-slowquery.log --no-report --output slowlog --filter '$event->{fingerprint} =~ m/^insert|^update/' > writes-only.log

answered Jun 11 '20 at 16:43

edmamerto

7,605
11
42
66

Filter AuroraMysql slow query log file by specific queries

1 Answers1