**Comment from Launchpad by: Daniel Nichter on: 02-08-2013 18:33:47

I agree, this would be useful. Created https://blueprints.launchpad.net/percona-toolkit/+spec/pt-stalk-collect-show-slave-status for this feature.

**Comment from Launchpad by: Fernando Ipar on: 27-06-2013 19:11:51

Fact is, this would take of 1050497 too.

=== modified file 'lib/bash/collect.sh'
— lib/bash/collect.sh 2013-03-12 21:23:02 +0000
+++ lib/bash/collect.sh 2013-06-27 19:11:16 +0000
@@ -222,6 +222,14 @@
(echo $ts; netstat -antp) >> "$d/$p-netstat" &
(echo $ts; netstat -s) >> "$d/$p-netstat_s" &

+ if [ -n "$($CMD_MYSQL $EXT_ARGV -e 'show slave status\G')" ]; then
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW SLAVE STATUS\G") \ >> "$d/$p-slave-status" &
+ fi
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW MASTER LOGS\G") \ >> "$d/$p-master-logs" &
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW MASTER STATUS\G") \ >> "$d/$p-master-status" &
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW FULL PROCESSLIST\G") \ >> "$d/$p-processlist" &

**Comment from Launchpad by: Fernando Ipar on: 27-06-2013 19:04:14

I believe the following should do this:

=== modified file 'lib/bash/collect.sh'
— lib/bash/collect.sh 2013-03-12 21:23:02 +0000
+++ lib/bash/collect.sh 2013-06-27 19:02:03 +0000
@@ -222,6 +222,10 @@
(echo $ts; netstat -antp) >> "$d/$p-netstat" &
(echo $ts; netstat -s) >> "$d/$p-netstat_s" &

+ if [ -n "$($CMD_MYSQL $EXT_ARGV -e 'show slave status\G')" ]; then
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW SLAVE STATUS\G") \ >> "$d/$p-slave-status" &
+ fi
(echo $ts; $CMD_MYSQL $EXT_ARGV -e "SHOW FULL PROCESSLIST\G") \ >> "$d/$p-processlist" &