6

I'm having some difficulty coming up with correct syntax to pull in specific host information for my slow query log file:

I'm using the following:

sudo pt-query-digest mysql-slow.log --since "2017-05-07 22:00:00" --until "2017-05-08 22:00:00" --filter ‘$event->{host} !~ m/^ip-1-1-1-1/’ > slow.log

In this scenario I'm trying to exclude all IPs that are 1.1.1.1. I can't figure out what's wrong.

codeforester
  • 39,467
  • 16
  • 112
  • 140
JimRomeFan
  • 407
  • 6
  • 19

1 Answers1

2

Use ascii quote ('), not this non-ascii quote (‘);

Assuming that m/^ip-1-1-1-1/ works, it will catch both ip-1-1-1-1 and ip-1-1-1-123. So you may need something to terminate the ip. Perhaps m/^ip-1-1-1-1$/

Without hiding the arg in single-quotes, the shell is interpreting (at least) $event as a shell variable, {...} as something, and !~ as something.

Rick James
  • 135,179
  • 13
  • 127
  • 222