Dig Statistics domain acceleration

#!/bin/bash
#author yeqing <[email protected]>
#date 2015-07-19 10:26:28
Yesnum=0
Nonum=0
I=0
Data= "
Yeslist= ()
Nolist= ()
Date= ' date + '%y-%m-%d%h:%m '
while read URL; Do
Dig ${url}|egrep ' cloudglb.net|hacdn.net|hadns.net ' >/dev/null 2>&1
If [$?-eq 0]; Then
yeslist[$i]=${url}
yesnum= ' expr ${yesnum} + 1 '
Else
nolist[$i]=${url}
nonum= ' expr ${nonum} + 1 '
Fi
Let i++
Done < Url.txt
For Nourl in ${nolist[*]};d o
Data= "(' ${date} ', ' ${nourl} ', 0,${yesnum},${nonum}), ${data}"
Done
For Yesurl in ${yeslist[*]};d o
Data= "(' ${date} ', ' ${yesurl} ', 1,${yesnum},${nonum}), ${data}"
Done
Mysql-h 192.168.1.5-uroot-p "123456"-s-e "INSERT into TEST.FASTGLB (time,domain,flag,yes,no) values${data%,*}";

This article from "Technical Cock silk" blog, declined reprint!

Dig Statistics domain acceleration