Cleanup InfiniteWP history tables

iwp-cleanup-db.sh

#!/usr/bin/env bash
#################################################
# For each site in InfiniteWP,
# removes all but the latest history records.
# 
# This speeds up InfiniteWP and
# reduces the size of its tables,
# particularly iwp_history_raw_details.
#
# Indended to be run as a daily cronjob.
#################################################

echo "Cleaning up InfiniteWP outdated site history records"

set -x
mysql -N -s infinitewp -e 'delete from iwp_history where historyID not in ( select h.histID from ( select siteID, MAX(historyID) histID from iwp_history GROUP BY siteID ) h )'
mysql -N -s infinitewp -e 'delete from iwp_history_additional_data where historyID not in (select historyID from iwp_history)'
mysql -N -s infinitewp -e 'delete from iwp_history_raw_details where historyID not in (select historyID from iwp_history)'
set +x