Purge Table DB

Purge Table DB

Postby italian_user on Tue Jan 18, 2011 10:07 am

1) Question
I don't use "bayesian_filter" (bayesian_filter_enabled = NOT)
so, can I PURGE (not DROP) the lt_bayesian_tokens Table?
'Cause in the first year I used it and it is 28,5 MiB!

2) Question
The Table lt_referers is 98,7 MiB
I don't like very much the statistics of lifetype, can I PURGE (not DROP) the lt_referers Table?
Is there a way to stop the statistics in lifetype?


Thanks very very much
italian_user
 
Posts: 193
Joined: Mon Apr 03, 2006 1:37 pm
LifeType Version: 1.2.11

Re: Purge Table DB

Postby jondaley on Tue Jan 18, 2011 9:38 pm

purging both of those tables is fine.
You can turn off referer tracking (I think - at least there is a setting for not tracking it when caching is enabled).
I'd be interested if your bayesian filter grows after you purge it - it shouldn't, but maybe there is a bug somewhere.
jondaley
Lifetype Expert
 
Posts: 6169
Joined: Thu May 20, 2004 6:19 pm
Location: Pittsburgh, PA, USA
LifeType Version: 1.2.11 devel branch

Re: Purge Table DB

Postby italian_user on Thu Jan 20, 2011 3:56 am

jondaley wrote:purging both of those tables is fine.
You can turn off referer tracking (I think - at least there is a setting for not tracking it when caching is enabled).
I'd be interested if your bayesian filter grows after you purge it - it shouldn't, but maybe there is a bug somewhere.


All it's ok! THANKS VERY MUCH!

I waited for reply, to estimate the operation!
It works very well and the table are not growed.
Both are still empty.

Thanks very much!
italian_user
 
Posts: 193
Joined: Mon Apr 03, 2006 1:37 pm
LifeType Version: 1.2.11


Return to Other Problems

cron