Not the answer you need?
Register and ask your own question!

pt-stalk multiple config issue

bardownbardown EntrantInactive User Role Beginner
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?

Comments

  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    Could you please share the config files you are using to try to reproduce the issue?
  • bardownbardown Entrant Inactive User Role Beginner
    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}'
    }
  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role
    I've created https://jira.percona.com/browse/PT-247 to track the issue.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.