# HELP pt-query-digest for PROCESSLIST

**URL:** <https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420>\
**Category:** Percona Toolkit\
**Created:** [February 19, 2017, 3:13am UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420 "2017-02-19T03:13:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kpanacy\_olb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kpanacy_olb/32/1160_2.png) [@kpanacy\_olb](https://forums.percona.com/u/kpanacy_olb)\
**Post date:** [February 19, 2017, 3:13am UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/1 "2017-02-19T03:13:33Z")

</div>

Hello, I used Maatkit before it became Percona Toolkit and could regularly run this:

mk-query-digest --processlist h=host,D=db,u=uname,p=pwd --print --interval 0.5 \> /tmp/process\_qry.log

When I try to run pt-query-digest the same way I get a message that --print is no longer valid. When I run it without --print just says “Reading from STDIN …” and never actually records anything.

$\>pt-query-digest --processlist h=host,D=db,u=uname,p=pwd --interval 0.5 \> /tmp/process\_qry.log

Wait 10 minutes, then

$\>cat /tmp/process\_qry.log

Reading from STDIN …

What am I doing wrong?

Thanks,  
Ken

---

<div class="post-metadata">

**Author:** ![carlos.salguero](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/carlos.salguero/32/20_2.png) [@carlos.salguero](https://forums.percona.com/u/carlos.salguero)\
**Post date:** [February 21, 2017, 2:52pm UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/2 "2017-02-21T14:52:30Z")

</div>

Hi,

I’ve tested pt-query-digest and I wasn’t able to reproduce the problem.  
I ran

```auto
bin/pt-query-digest --processlist h=localhost --interval=0.01 --output slowlog

```

Then I ran some queries on that MySQL instance and I am was able to get an output:

```auto
Reading from STDIN ...
# Time: 2017-02-21T16:31:31
# User&#64;Host: root[root] &#64; localhost []
# Query_time: 0.020595 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use db_facturacion;
select * from clientes;

```

Could you run it enabling the debug mode?  
Example:

```auto

It will produce a HUGE amount of data so be careful, don't redirect the output, just check is there is any major error being reported.
Also, could you specify the toolkit version you are using? You can get the version using:

```

pt-query-digest --version

```auto

Regards
```

---

<div class="post-metadata">

**Author:** ![kpanacy\_olb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kpanacy_olb/32/1160_2.png) [@kpanacy\_olb](https://forums.percona.com/u/kpanacy_olb)\
**Post date:** [February 21, 2017, 3:07pm UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/3 "2017-02-21T15:07:04Z")

</div>

Thanks for the reply.

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

I just tested byadding “–output slowlog” and now it works!

Thanks very much!!!

---

<div class="post-metadata">

**Author:** ![wan\_fujinan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wan_fujinan/32/11963_2.png) [@wan\_fujinan](https://forums.percona.com/u/wan_fujinan)\
**Post date:** [July 30, 2023, 4:15pm UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/4 "2023-07-30T16:15:10Z")

</div>

I had this problem.

```auto
 pt-query-digest --processlist h=127.0.0.1,u=root --ask-pass
 pt-query-digest --processlist h=127.0.0.1,u=root --output /home/pt-query-digest.log --ask-pass --daemonize

```

no output, nor log file generated.

```auto
[root@server home]# pt-query-digest --version
pt-query-digest 3.5.4

```

---

<div class="post-metadata">

**Author:** ![Leonardo\_Figueroa](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/leonardo_figueroa/32/8187_2.png) [@Leonardo\_Figueroa](https://forums.percona.com/u/Leonardo_Figueroa)\
**Post date:** [July 30, 2023, 6:23pm UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/5 "2023-07-30T18:23:58Z")

</div>

Hello @wan_fujinan welcome to percona community!!!  
The --output parameter is used to specify the output type, not location.  
You need to set the --output as slowlog and --log option to send the output to a file

---

<div class="post-metadata">

**Author:** ![Ricardo\_Cescon](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ricardo_cescon/32/21407_2.png) [@Ricardo\_Cescon](https://forums.percona.com/u/Ricardo_Cescon)\
**Post date:** [July 3, 2025, 10:46am UTC](https://forums.percona.com/t/help-pt-query-digest-for-processlist/5420/6 "2025-07-03T10:46:52Z")

</div>

Hello, I have the same or really similar problem.

I have a AWS RDS and like to use _pt-query-digest --processlist_  
The RDS in in a internal network but I have a SSH tunnel over a Jumphost.

Connecting to the RDS via _mysql -h 127.0.0.1 -P 33036 -u my\_rds\_user -p_ works as intended.

Using _pt-query-digest --processlist h=127.0.0.1,P=33036,u=my\_rds\_user ,p=my\_rds\_pw_

or also

_pt-query-digest --processlist h=127.0.0.1,P=33036,u=my\_rds\_user --ask-pass_

shows me olnly the following output

_Reading from STDIN …_