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 th
On Wed, 17 Jan 2007 11:25:02 +0100, "Rocco Scappatura"
<[EMAIL PROTECTED]> 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 maintain
> Do you compact the database afterwards?
>
> Nigel
No. How I have to do?
rocsca
On Wed, 17 Jan 2007 13:00:37 +0100, "Rocco Scappatura"
<[EMAIL PROTECTED]> 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= -e "USE spamassassin;OPTIMIZE
TABLE awl, bayes_expire, bayes
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= -e "USE
> spamassassin;OPTIMIZE TABLE awl, bayes_expire, bayes_seen,
> bayes_token, bayes_vars;"
>
> Your tabl
