If you are running a Magento-based website, make sure you add the database maintenance script to the cron. Â For example, append this to the /etc/crontab:
# Magento log maintenance, as per # https://docs.nexcess.net/article/how-to-perform-magento-database-maintenance.html 0 23 * * 0 root (cd /var/www/html/mysite.com && php -f shell/log.php clean)
Thanks to this page, obviously. Â You’ll be surprised how much leaner your database will be, especially if you get any kind of traffic to the site. Â Your database backups will also appreciate the trim.