cat queue_prepare.sh 
#!/bin/bash

MySQL_REQUEST="select id, ip, alive"
MySQL_CONDITION="ip!='' AND ip != ' '"

TMP_FREFIX="/tmp/trash"
QUEUE_FILE="/tmp/queue"

echo "$MySQL_REQUEST FROM $MySQL_READ_TABLE WHERE $MySQL_CONDITION" | mysql -u $MySQL_READ_USER -h $MySQL_READ_HOST --password $MySQL_READ_PASS $MySQL_READ_DB > $QUEUE_FILE

#отрезаем названия полей
sed -i.bak -e '1d' $QUEUE_FILE

let count=1
let file_count=1

cat $QUEUE_FILE | while read line
do
     echo $line >> $TMP_FREFIX/$file_count
 let count+=1
        if [ $count -eq 10 ]; then 
         pinger.sh $TMP_FREFIX/$file_count > /dev/null &
              let count=1
         let file_count+=1
   fi
done

cat pinger.sh 
#!/bin/bash

PING_OPTIONS="-c 1 -w 4"

FILE=$1

OUT_FILE='/tmp/result'

cat $FILE | while read line
do
    let alive=`echo $line | awk '{print $3}'`
   id=`echo $line | awk '{print $1}'`
  ip=`echo $line | awk '{print $2}'`
  ping $PING_OPTIONS $ip
      if [ $? -eq 0 -a $alive -eq 0 ]; then
               echo "$id $ip 1" >> $OUT_FILE
       fi
  if [ $? -ne 0 -a $alive -eq 1 ]; then
               echo "$id $ip 1" >> $OUT_FILE
       fi
done
rm $FILE