Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: bash logging al $() command lines
Top Forums Shell Programming and Scripting bash logging al $() command lines Post 302580455 by DGPickett on Thursday 8th of December 2011 02:21:57 PM
Old 12-08-2011
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'

 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

SSH and command logging

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)
Discussion started by: penguin-friend
2 Replies

2. UNIX for Dummies Questions & Answers

What is command for logging?

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)
Discussion started by: dtamminx
3 Replies

3. Solaris

shell command logging

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)
Discussion started by: minkie
2 Replies

4. Cybersecurity

Full Command Logging?

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)
Discussion started by: humbletech99
1 Replies

5. Shell Programming and Scripting

Reading lines from a file, using bash, "at" command

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)
Discussion started by: jbsimon000
3 Replies

6. Shell Programming and Scripting

bash telnet session logging

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)
Discussion started by: ramnet
2 Replies

7. Shell Programming and Scripting

Logging ALL standard out of a bash script to a log file, but still show on screen

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)
Discussion started by: ckmehta
3 Replies

8. Shell Programming and Scripting

running a bash script even after logging out from the current session

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)
Discussion started by: nks342
4 Replies

9. Shell Programming and Scripting

Command Logging

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)
Discussion started by: starcraft
0 Replies

10. Shell Programming and Scripting

BASH logging to file, limit lines

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)
Discussion started by: scorpius2k1
3 Replies
All times are GMT -4. The time now is 06:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy