OK, seemed that i will do the same like I have done with the AWL DB There I added a Date/Time Row and deleting out everything not used for longer than 2 month
Chang the database ALTER TABLE `awl` ADD `lastupdate` TIMESTAMP NOT NULL ; run a cronjob echo "USE spamassassin; DELETE FROM awl 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-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-tp17859100p17864030.html Sent from the SpamAssassin - Users mailing list archive at Nabble.com.
