# pt-stalk multiple config issue

**URL:** <https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100>\
**Category:** Percona Toolkit\
**Created:** [January 4, 2018, 11:40am UTC](https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100 "2018-01-04T11:40:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bardown](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@bardown](https://forums.percona.com/u/bardown)\
**Post date:** [January 4, 2018, 11:40am UTC](https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100/1 "2018-01-04T11:40:45Z")

</div>

Unable to get pt-stalk working with multiple config files. For example:

/usr/bin/pt-stalk --config /usr/local/bin/mysql/pt-stalk/configs/idleconnections.conf,/usr/local/bin/mysql/pt-stalk/configs/longquery.conf --dest=/var/lib/mysql/pt-stalk --log=/var/log/mysql/pt-stalk.log --sleep=300 --interval=300 --defaults-file=/etc/percona-toolkit.conf --daemonize

I then replicate an idle connection, and it triggers successfully… when I simulate a long query… it does not. If I reverse the order of the config files:

/usr/bin/pt-stalk --config /usr/local/bin/mysql/pt-stalk/configs/longquery.conf,/usr/local/bin/mysql/pt-stalk/configs/idleconnections.conf --dest=/var/lib/mysql/pt-stalk --log=/var/log/mysql/pt-stalk.log --sleep=300 --interval=300 --defaults-file=/etc/percona-toolkit.conf --daemonize

pt-stalk then triggers on longquery, but not on idleconnections.

Am I missing something?

---

<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:** [January 12, 2018, 8:38am UTC](https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100/2 "2018-01-12T08:38:50Z")

</div>

Could you please share the config files you are using to try to reproduce the issue?

---

<div class="post-metadata">

**Author:** ![bardown](https://avatars.discourse-cdn.com/v4/letter/b/b9e5f3/32.png) [@bardown](https://forums.percona.com/u/bardown)\
**Post date:** [January 12, 2018, 11:02am UTC](https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100/3 "2018-01-12T11:02:49Z")

</div>

Thank you for a response!

The setup:

Directories:

- configs
- functions

config1: idleconnections.conf

# Config for idle connections

function=/usr/local/bin/mysql/pt-stalk/functions/idleconnections.sh  
variable=idle\_connections  
threshold=0  
dest=/var/log/mysql/pt-stalk/  
log=/var/log/mysql/pt-stalk.log  
pid=/var/run/pt-stalk.pid

Content of idleconnections.sh:  
trg\_plugin() {  
mysqladmin --defaults-file=/etc/percona-toolkit.conf ‘processlist’ | awk -F|   
‘BEGIN{counter=0} {if ($6 ~ /Sleep/ && $7 \> 3600 ) counter++; } END {print counter}’  
}

config2: longquery.conf

# Config for Queries running long

function=/usr/local/bin/mysql/pt-stalk/functions/longquery.sh  
variable=Long\_Query  
threshold=0  
dest=/var/log/mysql/pt-stalk/  
log=/var/log/mysql/pt-stalk.log  
pid=/var/run/pt-stalk.pid

Content of longquery.sh:  
trg\_plugin() {  
mysqladmin --defaults-file=/etc/percona-toolkit.conf ‘processlist’ | awk -F|   
‘BEGIN{counter=0} {if ($6 ~ /Query/ && $7 \> 1200 ) counter++; } END {print counter}’  
}

---

<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:** [January 12, 2018, 11:48am UTC](https://forums.percona.com/t/pt-stalk-multiple-config-issue/6100/4 "2018-01-12T11:48:07Z")

</div>

I’ve created [url][[PT-247] pt-stalk multiple config issue - Percona JIRA](https://jira.percona.com/browse/PT-247%5B/url%5D) to track the issue.