You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by Rocco Scappatura <Ro...@sttspa.it> on 2007/01/17 11:25:02 UTC
Expiring tokens in SA database
Hello,
I'm using SA with MySQL.
I have to Amavisd-new server, each talking with a different MySQL
server.
I run every night regularly this command:
sa-learn --sync --force-expire
for datbase maintaining.
I have noticed that on the first the 'bayes_token' table occupies always
about 1GB and the size never decrease even after I execute the command
above (se the output in the file attached), while on the second database
the same table occupies less space (about 250 MB).
It seems to me the the expiring doesn't works at all and I can't figure
out why.
Can sombody give an explanation?
TIA,
rocsca
RE: Expiring tokens in SA database
Posted by Rocco Scappatura <Ro...@sttspa.it>.
Hello,
> >> Do you compact the database afterwards?
> >>
> >> Nigel
> >
> >No. How I have to do?
> >
> >rocsca
>
> From the CL use something like this:
>
> mysql -u root --password=<yourpassword> -e "USE
> spamassassin;OPTIMIZE TABLE awl, bayes_expire, bayes_seen,
> bayes_token, bayes_vars;"
>
> Your tables may differ slightly from mine, and some may have
> no content at all; initially try compacting the one that's biggest.
>
Infact, that was the problem!!
Many thanks,
rocsca
Re: Expiring tokens in SA database
Posted by Nigel Frankcom <ni...@blue-canoe.net>.
On Wed, 17 Jan 2007 13:00:37 +0100, "Rocco Scappatura"
<Ro...@sttspa.it> wrote:
>> Do you compact the database afterwards?
>>
>> Nigel
>
>No. How I have to do?
>
>rocsca
From the CL use something like this:
mysql -u root --password=<yourpassword> -e "USE spamassassin;OPTIMIZE
TABLE awl, bayes_expire, bayes_seen, bayes_token, bayes_vars;"
Your tables may differ slightly from mine, and some may have no
content at all; initially try compacting the one that's biggest.
KR
Nigel
RE: Expiring tokens in SA database
Posted by Rocco Scappatura <Ro...@sttspa.it>.
> Do you compact the database afterwards?
>
> Nigel
No. How I have to do?
rocsca
Re: Expiring tokens in SA database
Posted by Nigel Frankcom <ni...@blue-canoe.net>.
On Wed, 17 Jan 2007 11:25:02 +0100, "Rocco Scappatura"
<Ro...@sttspa.it> wrote:
>Hello,
>
>I'm using SA with MySQL.
>
>I have to Amavisd-new server, each talking with a different MySQL
>server.
>
>I run every night regularly this command:
>
>sa-learn --sync --force-expire
>
>for datbase maintaining.
>
>I have noticed that on the first the 'bayes_token' table occupies always
>about 1GB and the size never decrease even after I execute the command
>above (se the output in the file attached), while on the second database
>the same table occupies less space (about 250 MB).
>
>It seems to me the the expiring doesn't works at all and I can't figure
>out why.
>
>Can sombody give an explanation?
>
>TIA,
>
>rocsca
Do you compact the database afterwards?
Nigel