Details
-
Bug
-
Status: Done
-
High
-
Resolution: Fixed
-
3.1.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