Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1759

``pt-stalk`` with ``--mysql-only`` option didn't collect MySQL Status variables.

Details

    • Bug
    • Status: Done
    • High
    • Resolution: Fixed
    • 3.1.0
    • 3.2.0
    • None
    • None

    Description

      Hi,

      Noticed that the pt-stalk with --mysql-only options doesn't collect the MySQL Status variables which is needed for troubleshooting issues. The collected processlist and transactions files are also empty (noticed Jira - PT-1576 for processlist file empty issue).

       

      [root@vinodh-krishnaswamy-test2-standalone-1 collected]# pt-stalk --mysql-only --no-stalk  --dest=/tmp/pt/collected --sleep=10 --iterations=1
      2019_08_27_05_34_34 Starting /usr/bin/pt-stalk --function=status --variable=Threads_running --threshold=25 --match= --cycles=0 --interval=1 --iterations=1 --run-time=30 --sleep=10 --dest=/tmp/pt/collected --prefix= --notify-by-email= --log=/var/log/pt-stalk.log --pid=/var/run/pt-stalk.pid --plugin=
      2019_08_27_05_34_34 Not stalking; collect triggered immediately
      2019_08_27_05_34_34 Collect 1 triggered
      2019_08_27_05_34_34 MYSQL_ONLY: yes
      2019_08_27_05_34_34 Collect 1 PID 949
      2019_08_27_05_34_34 Collect 1 done
      2019_08_27_05_34_34 Waiting up to 90 seconds for subprocesses to finish...
      2019_08_27_05_35_04 Exiting because no more iterations
      2019_08_27_05_35_04 /usr/bin/pt-stalk exit status 0
      [root@vinodh-krishnaswamy-test2-standalone-1 collected]# pwd
      /tmp/pt/collected
      [root@vinodh-krishnaswamy-test2-standalone-1 collected]# ls -ltrh
      [root@vinodh-krishnaswamy-test2-standalone-1 collected]# ls -ltrh
      total 504K
      -rw-r--r--. 1 root root  145 Aug 27 05:34 2019_08_27_05_34_34-disk-space
      -rw-r--r--. 1 root root  355 Aug 27 05:34 2019_08_27_05_34_34-trigger
      -rw-r--r--. 1 root root  14K Aug 27 05:34 2019_08_27_05_34_34-variables
      -rw-r--r--. 1 root root 4.4K Aug 27 05:34 2019_08_27_05_34_34-innodbstatus1
      -rw-r--r--. 1 root root  579 Aug 27 05:34 2019_08_27_05_34_34-mutex-status1
      -rw-r--r--. 1 root root 3.1K Aug 27 05:34 2019_08_27_05_34_34-opentables1
      -rw-r--r--. 1 root root    0 Aug 27 05:34 2019_08_27_05_34_34-transactions
      -rw-r--r--. 1 root root    0 Aug 27 05:34 2019_08_27_05_34_34-processlist
      -rw-r--r--. 1 root root    0 Aug 27 05:34 2019_08_27_05_34_34-lock-waits
      -rw-r--r--. 1 root root  57K Aug 27 05:35 2019_08_27_05_34_34-slave-status
      -rw-r--r--. 1 root root 4.4K Aug 27 05:35 2019_08_27_05_34_34-innodbstatus2
      -rw-r--r--. 1 root root 385K Aug 27 05:35 2019_08_27_05_34_34-output
      -rw-r--r--. 1 root root 3.1K Aug 27 05:35 2019_08_27_05_34_34-opentables2
      -rw-r--r--. 1 root root  579 Aug 27 05:35 2019_08_27_05_34_34-mutex-status2
      

       

      Tested in 3.0.13

       

       

      [root@vinodh-krishnaswamy-test2-standalone-1 collected]# pt-stalk --version
      pt-stalk 3.0.13
      

       

       

       

      Attachments

        Activity

          People

            carlos.salguero Carlos Salguero (Inactive)
            vinodh.krishnaswamy Vinodh Krishnaswamy
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist