Hi Dimitry,
now I got it :) thanks a lot :) it is logical, but I always wanted to choose more than 1 column in multi-host reports, therefore never saw it in the bookmarks list box.
One more question, while you are so kind to help me.... In v8 Dimstat server part was able to run for a long time.... When I started to use v9, I see that after short time, may be an hour, mysql is going down:
No mysqld pid file found. Looked for /apps/mysql/data/mysqld.pid.
When stopping dimstat server:
[root@test ADMIN]# ./dim_STAT-Server stop
================[ dim_STAT-Server: stop ]================
================[ Checking for ACTIVE collects... ]================
================[ MySQL Server is not running... ]================
I see that mysql is not running...
My question is : is it configuration issue or something missing ?
Another question I have is regarding multi-lines stats using awk. I have created shell script which is collecting pidtsat info about process threads. when I calling the script from command line, it is working fine. but when it is called from the dimstat, all parameters are shifting by 1.
Example:
[root@cpv-app-0 bin]# ./Pidstat.sh 8161 1
Engine-Worker-0 0.01 0.00 0.00 0.01 0
Engine-Worker-1 0.01 0.00 0.00 0.01 0
Engine-Worker-2 0.01 0.00 0.00 0.01 0
Engine-Worker-3 0.01 0.00 0.00 0.01 0
Engine-Worker-4 0.01 0.00 0.00 0.01 0
Engine-Worker-5 0.01 0.00 0.00 0.01 0
Engine-Worker-6 0.01 0.00 0.00 0.01 0
Engine-Worker-7 0.01 0.00 0.00 0.01 0
Engine-Worker-8 0.01 0.00 0.00 0.01 0
Engine-Worker-9 0.01 0.00 0.00 0.01 0
When calling from dimstat:
[root@cpv-app-0 bin]# ./STATcmd -h localhost -p 5000 -c "Pidstat 8161 1"
STAT *** OK CONNECTION 0 sec.
Pidstat.sh:
while true
do
pidstat -p $1 -t | awk '{if ($11 ~ "__Engine-Worker-") {print substr($11,4), $6,$7,$8,$9,$10; count++; if (count==10) {print "\n";count=0}}}'
sleep $2
done
But, when I change Pidstat.sh to:
while true
do
exec /usr/bin/pidstat -p $1 -t | awk '{print substr($10,4),$5,$6,$7,$8,$9}' | grep Engine-W
sleep $2
printf "\n"
done
it is working fine:
[root@cpv-app-0 bin]# ./STATcmd -h localhost -p 5000 -c "Pidstat 8161 1"
STAT *** OK CONNECTION 0 sec.
STAT *** OK COMMAND (cmd: Pidstat)
Engine-Worker-0 0.01 0.00 0.00 0.01 1
Engine-Worker-1 0.01 0.00 0.00 0.01 0
Engine-Worker-2 0.01 0.00 0.00 0.01 0
Engine-Worker-3 0.01 0.00 0.00 0.01 1
Engine-Worker-4 0.01 0.00 0.00 0.01 1
Engine-Worker-5 0.01 0.00 0.00 0.01 0
Engine-Worker-6 0.01 0.00 0.00 0.01 0
Engine-Worker-7 0.01 0.00 0.00 0.01 1
Engine-Worker-8 0.01 0.00 0.00 0.01 0
Engine-Worker-9 0.01 0.00 0.00 0.01 1
Many thanks for your effort !,
Pjotr