SYMPTOMS
My database is extremely large, is there a way to reduce the size automatically rather than running the optimizer regularly?
CAUSE
There are a number of tables in your database with the postfix _tracking, these tables store temporary information that is used for performance processing and statistics.
SOLUTION
None of this data is required for more than 8 days and can safely be removed via a cron job or other similar process. Run following SQL daily to remove the old data from your tables:
traffic exchange + text exchange + banner exchange
Powered by Invision Power Board (http://www.invisionboard.com)
© Invision Power Services (http://www.invisionpower.com)