3
pt-query-digest --processlist h=host,D=db,u=uname,p=pwd --interval 0.5 > /tmp/process_qry.log

just says "Reading from STDIN ..."

I used to do this with MAATKIT all the time and it worked fine. Please tell me what I'm doing wrong.

[~]$ pt-query-digest --version
pt-query-digest 2.2.20

mysql > select version();
+-----------+
| version() |
+-----------+
| 5.5.53    |
+-----------+

I tried posting this on Percona's forums and that didn't work either.

Thanks,

Ken

KenP_olb
  • 91
  • 4

1 Answers1

6

Someone on Percon'a forum answered my question!

I needed to include "--output slowlog"

pt-query-digest --processlist h=host,D=db,u=uname,p=pwd --output slowlog > /tmp/process_qry.log

KenP_olb
  • 91
  • 4