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
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