Wiki tables cleanup

drop_per_wiki_table.sh

#!/bin/bash
CLUSTER=$1
TABLE_NAME=user

echo "Will remove per-wiki '${TABLE_NAME}' tables on '${CLUSTER}' cluster..."

WIKICITIES_PARAMS=`dbparams.pl --name wikicities_${CLUSTER} --type=slave`
MASTER_PARAMS=`dbparams.pl --name wikicities_${CLUSTER} --type=master`

for DBNAME in `mysql $WIKICITIES_PARAMS --batch --disable-column-names -e 'select TABLE_SCHEMA as wiki_db FROM information_schema.TABLES WHERE TABLE_NAME="'${TABLE_NAME}'"'`
do
	mysql $MASTER_PARAMS --verbose -e 'USE '${DBNAME}'; DROP /* SUS-3071 */ TABLE '${TABLE_NAME}';'

	echo "$DBNAME: dropped"
done

truncate_per_wiki_table.sh

#!/bin/bash
CLUSTER=$1
TABLE_NAME=job

echo "Will truncate (if not empty) per-wiki '${TABLE_NAME}' tables on '${CLUSTER}' cluster..."

WIKICITIES_PARAMS=`dbparams.pl --name wikicities_${CLUSTER} --type=slave`
MASTER_PARAMS=`dbparams.pl --name wikicities_${CLUSTER} --type=master`

for DBNAME in `mysql $WIKICITIES_PARAMS --batch --disable-column-names -e 'select TABLE_SCHEMA as wiki_db FROM information_schema.TABLES WHERE TABLE_NAME="'${TABLE_NAME}'" AND TABLE_ROWS > 0'`
do
	mysql $MASTER_PARAMS --verbose -e 'USE '${DBNAME}'; TRUNCATE /* SUS-3471 */ TABLE '${TABLE_NAME}';'

	echo "$DBNAME: truncated"
done