Statistics Database Tables Delete Safely

Hi,

To reset your stats data, you’d need to truncate the following tables:

TRUNCATE TABLE www_ta_link_clicks;
TRUNCATE TABLE www_ta_link_clicks_meta;

Please make sure to create a database backup before proceeding in case something goes wrong.

To keep them from building up, you can enable the auto clicks deleting feature under ThirstyAffiliates->Settings->General section.

Set it to maybe 90 days to start.

It might take a day or two for it to trim out the old hits.

Please note that trimming old clicks is the permanent deletion of that data though.

The stats trimmer runs on the first day of each month, so you can use a plugin like WP Crontrol to edit the implement_stats_trimmer cron and set it to run October 1st (that should force it to run now).

Hi again,

Just a small note: I noticed that I wrote the wrong table prefixes in my previous reply.

These are the correct ones:

TRUNCATE TABLE wp_ta_link_clicks;
TRUNCATE TABLE wp_ta_link_clicks_meta;

You might need to change the wp_ part if your database uses a different prefix.

Thanks

hi,

yeah, I figured you missed the wp_ but I was not sure which ones were the tables in the first place and if using: truncate or delete, so now I have deleted them all, I had one table that was 3.6GB, a little too big!

thanks a lot