#!/bin/bash

USER=root
PASS=pass
DB=db
LOWRECORDS=100
LOG="/var/log/mysql/general.log"



if [ -e "iamdone" ]; then
    exit 0
fi

COUNT=`mysql -u $USER --password=$PASS -D $DB -N -s -e "SELECT count(*) from eav_attribute_option_swatch;"`

if [[ $COUNT -gt $LOWRECORDS ]]; then
    mv "${LOG}" "${LOG}.tmp"
    mysqladmin -u $USER --password=$PASS flush-logs
    rm "${LOG}.tmp"
else
    `mysql -u $USER --password=$PASS -D $DB -N -s -e "SET GLOBAL general_log = 'OFF';"`
    touch "iamdone"
    echo "I am done"
fi