Expiring tokens in SA database

2007-01-17 Thread Rocco Scappatura
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

Re: Expiring tokens in SA database

2007-01-17 Thread Nigel Frankcom
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 maintaining. I have

RE: Expiring tokens in SA database

2007-01-17 Thread Rocco Scappatura
Do you compact the database afterwards? Nigel No. How I have to do? rocsca

Re: Expiring tokens in SA database

2007-01-17 Thread Nigel Frankcom
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=yourpassword -e USE spamassassin;OPTIMIZE TABLE awl, bayes_expire,

RE: Expiring tokens in SA database

2007-01-17 Thread Rocco Scappatura
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