Revision of Database Purging from Thu, 10/15/2015 - 09:40

Revisions allow you to track differences between multiple versions of your content, and revert back to older versions.

Nightly script to purge the dspam database of old information.

Performance Tuning

Nightly Maintenance Script

mkdir /var/dspam/sql
cp /extra/src/dspam-3.10.2/src/tools.mysql_drv/purge-4.1.sql /var/dspam/sql/

Test the script out:

/usr/local/mysql/bin/mysql -u simscan -p \
dspamdb < /var/dspam/sql/purge-4.1.sql

Create a cron task to run it nightly:

cd /etc/cron.d
echo "0 0 * * * root /usr/local/mysql/bin/mysql -u simscan -p<password> dspamdb < /var/dspam/sql/purge-4.1.sql" > dspam
touch /etc/crontab

Optimizing purge-4.1.sql

Purging a user
Script to delete dspam users

Recent Updates

  • nginx
    11 months 1 week ago
    1.27.2 update
  • lighttpd
    11 months 3 weeks ago
    Drupal 10/11 config
  • Drupal 11
    11 months 3 weeks ago
  • PHP
    11 months 3 weeks ago
    PHP 8.3.11 and AlmaLinux
  • Pound SSL Proxy
    11 months 3 weeks ago
    New version of Pound
Error | Production Monkeys

Error

The website encountered an unexpected error. Please try again later.