Re: [Solved] Bad performance of Bayes with MySQL cluster

John Hardin wrote: > > Suggestion: open a feature request bug to allow bayes autolearn to use a > different database connection string than bayes scoring. That way you > could configure all the daemons' autolearns to write to the master, but > distribute their scoring queries across X number

Reduce Bayes DB

Hi, I would like to reduce the size of my bayes db. The filesize of the bayes_seen.MYI is now near 1GByte. # sa-learn -u filter --dump magic 0.000 0 3 0 non-token data: bayes db version 0.000 0 38413200 0 non-token data: nspam 0.000 0 4

Re: Reduce Bayes DB

WHERE lastupdate <= DATE_SUB(SYSDATE(), INTERVAL 2 MONTH);" | mysql So I thing I can do the same with bayes_seen. Frank furban wrote: > > Hi, > > I would like to reduce the size of my bayes db. > The filesize of the bayes_seen.MYI is now near 1GByte. > > # sa-le

Re: Reduce Bayes DB

-u filter --force-expire help or is that done automatic? Frank furban wrote: > > Hi, > > I would like to reduce the size of my bayes db. > The filesize of the bayes_seen.MYI is now near 1GByte. > > # sa-learn -u filter --dump magic > 0.000 0 3