IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
How Do I Keep The Size Of My Database Down Automatically?, My database is extremely large, is there a way to reduce the size?
Martyn
post Jun 14 2006, 07:07 PM
Post #1


WSF Commander
*******

Group: Admin
Posts: 4,662
Joined: 26-August 05
Member No.: 10



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
SQL
DELETE FROM vtp_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)

SQL
DELETE FROM vtp_text_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)

SQL
DELETE FROM vtp_bnr_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)


text exchange:
SQL
DELETE FROM vte_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)


banner exchange:
SQL
DELETE FROM vbe_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)


link tracking exchange:
SQL
DELETE FROM vtl_tracking WHERE action_date < DATE_SUB(CURDATE(),INTERVAL 14 DAY)
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 28th March 2024 - 03:15 PM