#!/bin/bash
export PATH
basepath=datasql
mkdir tmpsqls
cd $basepath
tablesqllist=(`ls -l *.sql | awk '{print $9}'`)
cd ..
for tablesql in ${tablesqllist[*]}
do
split -d -a 6 -l 3500 ${basepath}/${tablesql} tmpsqls/${tablesql}.
cursor=0
sqllist=(`ls -l tmpsqls/${tablesql}.* | awk '{print $9}'`)
count=${#sqllist[*]}
for sqlfile in ${sqllist[*]}
do
joblist=($(jobs -p))
while (( ${#joblist[*]} >= 30 ))
do
{
sleep 0.1
joblist=($(jobs -p))
}
done
echo $sqlfile " " $cursor " / " $count
mysql -uroot -ppwd -h 10.10.10.11 -P 3306 -Ddb1 < $sqlfile &
if [[ $cursor -eq 0 ]];then
sleep 5
else
sleep 0.2
fi
cursor=`expr $cursor + 1`
done
#exit
done
