Archive Impressions

Archive Script on Research Example

#!/bin/bash

SRCDB=honeydew_production
SRCTABLE=impressions
DSTDB=honeydew_archive_2012
DSTTABLE=impressions

SQL="alter table $DSTDB.$DSTTABLE disable keys"
echo "$SQL"
echo "$SQL" | mysql

SID=3962169320
EID=4727791949
INC=100000
for ((sid=SID; sid<EID; sid+=INC)); do
  eid=$((sid+INC))
  if ((eid>EID)); then
    eid=$EID
  fi
  SQL="insert into $DSTDB.$DSTTABLE select * from $SRCDB.$SRCTABLE where id>=$sid and id<$eid"
  echo "$SQL"
  echo "$SQL" | mysql
done

SQL="alter table $DSTDB.$DSTTABLE enable keys"
echo "$SQL"
echo "$SQL" | mysql

echo "DONE"

Drop Partitions Example

#!/bin/bash

for year in {2012..2012} ; do
  for week in {27..39} ; do
    partition="y$year"`printf "w%02d" $week`
    echo "alter table honeydew_production.impressions drop partition $partition"
    echo "alter table honeydew_production.impressions drop partition $partition" | mysql
  done
done