
#!/bin/bash  

##
# this is work dir - the directory of the script itself
WORKDIR=/etc/scripts/mysql_db_size

##
# this is file where all stat from du are collected
STATFILE=$WORKDIR/STATFILE

##
# the command that allow you to collect information
COMMAND=`du -s /var/lib/mysql/* | sort -h | tail -50 |  sed -e 's/\/var\/lib\/mysql\//:/g' -e 's/\t//g' > $STATFILE `

##
# db size in kilobytes
DBSIZEKB=500000
#===================#
## 		   ##
#### DO NOT EDIT ####
##		   ##
#		    #
#===================#

##
# delete all previous created by script

rm -f $WORKDIR/temp/*.sh 

for i in `cat $STATFILE ` ; 
do 

##
# define variables for all infomation in stat file
BSIZE=`echo $i | awk -F":" '{print $1}' ` ; 
BUSER=`echo $i | awk -F":" '{print $2}'  ` ;  


##
# check if DB size is over 500MB and alert it

if [[ "$BSIZE" -gt "$DBSIZEKB" ]] 
then 
echo "WARNING du show that database $BUSER is $(echo $BSIZE/1024 | bc)M  "
echo "The real size is:"


echo $BUSER > $WORKDIR/.part2 

paste $WORKDIR/.part1  $WORKDIR/.part2  $WORKDIR/.part3 > $WORKDIR/temp/$BUSER.sh

sed 's/\t//g' $WORKDIR/temp/$BUSER.sh  -i

chmod +x $WORKDIR/temp/$BUSER.sh

bash $WORKDIR/temp/$BUSER.sh

echo "==========================================="
echo ""

fi

done