If set -x was on, there would be logging all over and as I recall it also does not log sub-shells.
Code:
$ for p in 9330 9329 9328 9327 9326 9314
do
ect=$( cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load' )
echo "show processlist;
set global max_connections=5;
show global variables like 'max_connections';"
kill -9 $p
while [ $ect = $( cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load' ) ]
do
sleep 5
done
echo "set global max_connections=151;
show global variables like 'max_connections';"
ect2=0
while [ $ect2 != $ect ]
do
ect2=$ect
sleep 5
ect=$( cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load' )
done
done | mysql -n -uxxxuser -pxxxpass xxx_db ; psm 9311
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Id User Host db Command Time State Info
41421 c64confuser arges9.xmen.eti:45334 host_sw_db Connect 1151 Reading from net NULL
41423 c64confuser arges9.xmen.eti:45336 host_sw_db Connect 1151 Reading from net NULL
41424 c64confuser arges9.xmen.eti:45337 host_sw_db Sleep 1151 NULL
41428 c64confuser arges9.xmen.eti:45343 host_sw_db Sleep 1 NULL
41434 c64confuser arges9.xmen.eti:45350 host_sw_db Sleep 245 NULL
41437 c64confuser arges9.xmen.eti:45353 host_sw_db Sleep 1151 NULL
41439 c64confuser arges9.xmen.eti:45355 host_sw_db Sleep 0 NULL
41440 c64confuser localhost host_sw_db Query 0 NULL show processlist
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Variable_name Value
max_connections 5
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Variable_name Value
max_connections 151
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Id User Host db Command Time State Info
41421 c64confuser arges9.xmen.eti:45334 host_sw_db Connect 1234 Reading from net NULL
41423 c64confuser arges9.xmen.eti:45336 host_sw_db Connect 1234 Reading from net NULL
41424 c64confuser arges9.xmen.eti:45337 host_sw_db Sleep 1234 NULL
41428 c64confuser arges9.xmen.eti:45343 host_sw_db Sleep 0 NULL
41437 c64confuser arges9.xmen.eti:45353 host_sw_db Sleep 1234 NULL
41439 c64confuser arges9.xmen.eti:45355 host_sw_db Sleep 1 NULL
41440 c64confuser localhost host_sw_db Query 0 NULL show processlist
41444 c64confuser arges9.xmen.eti:45414 host_sw_db Sleep 10 NULL
Variable_name Value
max_connections 5
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Variable_name Value
max_connections 151
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
cat host-local/var/log/*|grep -c 'MySQL server is experiencing heavy load'
Hi all...
I've completed the task of deploying SSH over my 400 servers.
I don't know if i'm right or wrong, but ssh doesn't do any command-logging, does it?
Is there a app i can use to log all commands passed ( besides the usual .sh_history), whith no modification possible by the user, and how... (2 Replies)
Hi, I am trying to recollect the command used to log a file.
We use this command just before starting, say, installation. At the end you get a file capturing the series of commands you used during the course of time and sytems response.
Could anybody please help.
Thanks,
Dasa (3 Replies)
Does anyone have a simple method of logging all shell commands typed by a user (csh in our case)?
- I could enable auditing, but this would be overkill
- I could enable process accounting, but AFAIK, this does not log arguments
Thanks all. (2 Replies)
I am looking for a really good command logging tool to improve the auditing of my servers. I have previously used snoopy but this is currently a bit flaky and causing serious problems for me, it doesn't look like it's been maintained since 2004, it didn't even want to compile until I added -fPIC... (1 Reply)
Hi.
I have the script shown below. If I execute it form the command line it seems to work properly, but when I fun it using the unix "at" command
"at -m now < ./kill-at-job.sh"
It appears to hang. Below is the script, the input file, and the execution as reported in the e-mail from the "at"... (3 Replies)
I'm looking at allowing remote telnet into my server.
like any security-minded administrator, I want to log what my users type on the telnet session.
I'm using the script command to generate transcripts of the users session.
I have /etc/profile set to automatically start the script command... (2 Replies)
Is it possible to store all standard-out of a bash script and the binaries it calls in a log file AND still display the stdout on screen?
I know this is possible to store ALL stdout/stderr of a script to a single log file like:
exec 1>&${logFile}
exec 2>&1
But running a script with the... (3 Replies)
HI ,
I have a simple script that moves files from one folder to another folder, I have already done the open-ssh server settings and the script is working fine and is able to transfer the files from one folder to another but right now I myself execute this script by using my creditianls to... (4 Replies)
I searched the forums for command logging and the user "Driver" seemed to provide a script for logging shell commands with related info like date and time. The subject was "logging command invocations -cmdlog" . I would be interested in this script.
Thanks (0 Replies)
BASH Gurus: Anyone know how to append continuous output command appending to a file, but limit that file to no more than 20 lines? The program I have running is simply monitoring my UDP port 53 for incoming packets endlessly. I just need to keep this file from going over 20 lines. Once the file... (3 Replies)