Percona Toolkit moved to https://jira.percona.com/projects/PT

pt-stalk get wrong mysqld pid when the host installed multi mysql instance

Bug #1644694 reported by zhechen on 2016-11-25

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Toolkit moved to https://jira.percona.com/projects/PT	Confirmed	Undecided	Carlos Salguero	Percona Toolkit moved to https://jira.percona.com/projects/PT 2.2.21 "2.2.21"

Bug Description

host env:
Centos 6.8
percona-toolkit-2.2.19

two mysql instance:
$ pidof mysqld
33530 17881

my host have two mysql instance, 3304 port(pid: 17881) and 3306 port(pid: 33530), when I use pt-stalk to monitor 3304 port, the mysql info logs in /var/lib/pt-stalk/ is about 3306 port, this is wrong, I just want log the mysql 3304 port.

the following code in pt-stalk mabye get wrong mysql pid:

   792 collect() {
   793 local d="$1" # directory to save results in
   794 local p="$2" # prefix for each result file
   795
   796 local mysqld_pid=$(_pidof mysqld | awk '{print $1; exit;}')
   797

the subsequent mysql info will be wrong when mysqld_pid is wrong, pt-stalk should read mysql pid_file to get right pid number.

Tags:

Revision history for this message

Jericho Rivera (jericho-rivera) wrote on 2016-11-25:

stalk.out Edit (70.4 KiB, text/plain)

With port=3307 option only it will not pick the right instance:
[root@multi ~]# bash -x pt-stalk --no-stalk --iterations=2 --sleep=30 --user=root --password=p3rc0na --port=3307 > stalk.out 2>&1
[root@multi ~]# grep ^port /var/lib/pt-stalk/*-variables
/var/lib/pt-stalk/2016_11_25_04_49_31-variables:port 3306
/var/lib/pt-stalk/2016_11_25_04_50_01-variables:port 3306

Using the socket will pick the right instance:
[root@multi ~]# bash -x pt-stalk --no-stalk --iterations=2 --sleep=30 --user=root --password=p3rc0na --socket=/tmp/mysql1.sock > stalk1.out 2>&1
[root@multi ~]# grep ^port /var/lib/pt-stalk/*-variables
/var/lib/pt-stalk/2016_11_25_04_49_31-variables:port 3306
/var/lib/pt-stalk/2016_11_25_04_50_01-variables:port 3306
/var/lib/pt-stalk/2016_11_25_04_57_36-variables:port 3307
/var/lib/pt-stalk/2016_11_25_04_58_06-variables:port 3307