I looks good ALTER TABLE `bayes_seen` ADD `lastupdate` TIMESTAMP NOT NULL ;
DELETE FROM bayes_seen WHERE lastupdate <= DATE_SUB(SYSDATE(), INTERVAL 2 DAY); but there is still a large bayes_token DB with also more than 200MB. Is there also a way to reduce that? Does a cronjob with sa-learn -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 0 non-token data: bayes db version > 0.000 0 38413200 0 non-token data: nspam > 0.000 0 48964536 0 non-token data: nham > 0.000 0 17639510 0 non-token data: ntokens > 0.000 0 1213554746 0 non-token data: oldest atime > 0.000 0 1213597971 0 non-token data: newest atime > 0.000 0 0 0 non-token data: last journal sync > atime > 0.000 0 1213597961 0 non-token data: last expiry atime > 0.000 0 43200 0 non-token data: last expire atime > delta > 0.000 0 9765 0 non-token data: last expire > reduction count > > yes, thats a little bit larger site ;-) > > Two month ago the database was about 4Gbyte and I purged all and created a > new one. But now its again very large and I looking for a way to reduce > it. > > Greetings > > Frank > > > -- View this message in context: http://www.nabble.com/Reduce-Bayes-DB-tp17859100p17864337.html Sent from the SpamAssassin - Users mailing list archive at Nabble.com.
