dataase cleanup

[gothstone]

I noticed my database was getting rather large. After looking around a bit I have created the folowing sql file to clean it up. I'm using a cron job to run it every night. Later in the night I also run mysqlcheck -uMyUsername -pMyPassword -ao --auto-repair MyDatabase
Are there other tables I should be cleaning up as well?

DELETE FROM `admin_activity_log` WHERE DATE_SUB(CURDATE(),INTERVAL 60 DAY ) > `access_date`;
DELETE FROM `paypal_session` WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY ) > FROM_UNIXTIME(`expiry`);
DELETE FROM `email_archive` WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY ) > `date_sent`;
DELETE FROM `linkpoint_api` WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY ) > `date_added`

[DrByte]

Those are probably the most common tables that will grow over time.
Running that cleanup daily is a bit of overkill. Every 2-4 weeks would typically be sufficient, except perhaps for the email history.
Might want to "optimize" those tables after deleting, too, to reclaim deleted space.