Shell Programming and Scripting

 
LIST='wmi_product wmi_patches employee actions jobs appversions os hardware detection_apps status wmi_networkadapterconfig wmi_logicaldisk'
let counter=0;
for i in $LIST
do
   echo "    Dumping and Importing table $i" " ( `date +'%x %X'` ) "
   $MYSQLDUMP -h$DBHOST -u$USER -p$PASSWORD -q --opt --single-transaction --add-drop-table $DB --tables $i | $MYSQL -u$DBuser -p$DBpass $DB > $ilog.txt &
    let counter=$counter+1
    echo "$counter%4" | bc
    if [ `echo "$counter%4" | bc` -eq 0 ] ; then
          wait
    fi
done;

counter=`ps -f | grep -c $MYSQLDUMP`

while read LINE                          # go through the output file from the view one line at a time
do

### Commented a lot of code - but basically, based on the LINE, 
###   set up the job with export statements

###   the secret is the jobs command gives a list of background jobs to this process
###   then the wc -l tells me how many

###   if it is >= 4, it goes to sleep for 30 seconds, then checks the count again

    # getting here, we want to submit the job to run, up to the limit of 4 jobs running at one time
    # See if there are 4 jobs running right now
      while [[ $( jobs | wc -l ) -ge 4 ]]
      do
        echo_f going to sleep now at $(date)
        sleep 30
      done

      /avidyn/scripts/avd_runit_002.ksh 1>/dev/null 2>&1 &   # parameters are passed by the export statements

done < /avidyn/tmp/avd_runit_001_jobs_to_run.txt

###  Not show after the done, is a "wait" command, to wait until all background jobs are finished.

 
echo $$ >/tmp/caller.pid
HOSTFROM=192.168.0.3
HOSTTO=192.168.0.2
DBFROM=hronline
DBTO=hronline
DBUSER=admin
DBPASSWD=password
TABLES1=`mysql -u$DBUSER -p$DBPASSWD -h $HOSTFROM -e "SELECT table_name as 'removebeforeuse' FROM information_schema.tables WHERE table_schema='$DBFROM';" |grep -v removebeforeuse`
TABLES=( ${TABLES1} )
CALLERPID=`cat /tmp/caller.pid`
COUNTER=0
while [ $COUNTER -lt ${#TABLES[@]} ]; do
    NUMPROC=` ps -ef | grep $CALLERPID | grep -v grep | grep -v bash | wc -l `
    if [ $NUMPROC -lt 5 ]; then
        echo Dumping table $COUNTER of ${#TABLES[@]} -- ${TABLES[$COUNTER]} Processes running concurrently: $NUMPROC
        mysqldump -v -u$DBUSER -p$DBPASSWD -q -h $HOSTFROM -e -C $DBFROM ${TABLES[$COUNTER]} | mysql -u$DBUSER -p$DBPASSWD -h  $HOSTTO $DBTO &
        sleep 3;
        let COUNTER=COUNTER+1
    fi
done
rm -f /tmp/caller.pid

$ ps -o pid="" -p 7693,3351,25875,9999 |wc -w
     2

while [ $(ps ax|grep -ic $MYSQLDUMP) -gt 4 ] ;do sleep 3;done