mark: Daily DB cleaning

MT 3.2 only deletes junk comments from your blog when you click on the name of your blog from the Main Menu. Presumably because they didn't want to add periodic triggers throughout the code and they thought that most people accessed their blogs every day from the Main Menu. In addition, the activity log can really slow down the DB. So I configured a cron job to clean out the DB every night:

#!/usr/local/bin/bash

# Set these to appropriate values
db_name=${USER}_XXXXXX
db_username=XXXXXX
db_password=XXXXXX
db_server=dbXXX.pair.com

# Delete junk comments
yesterday=$(/usr/local/bin/gdate -d yesterday +%Y-%m-%d)
/usr/local/bin/mysql \
-u "$db_username" \
-p"$db_password" \
-h "$db_server" \
-e "DELETE FROM mt_comment WHERE comment_junk_status < 0 AND comment_modified_on < '$yesterday'" \
$db_name

# Trim activity log
one_month_ago=$(/usr/local/bin/gdate -d '1 month ago' +%Y-%m-%d)
/usr/local/bin/mysql \
-u "$db_username" \
-p"$db_password" \
-h "$db_server" \
-e "DELETE FROM mt_log WHERE log_modified_on < '$one_month_ago'" \
$db_name

mark

Daily DB cleaning

Post a comment