Moving Bayes database to tmps

[Zaeem Arshad]

On Fri, May 29, 2009 at 5:31 PM, Kai Schaetzl <maillists at conactive.com>wrote:

> Zaeem Arshad wrote on Fri, 29 May 2009 16:10:44 +0600:
>
> > Can I get noticecable performance improvement by moving the bayesian
> > database to tmpfs? Currently, it's being stored at /root/.spamassassin
> which
> > happens to be an ext3 partition.
>
> Maybe. But you have to regularly back it up and restore it once you reboot
> or
> lose tmpfs for other reasons. I would think you are better off with moving
> to
> SQL.


Doesn't MS expire the database every 24 hours?


> How big is the database at the moment? What's the data of
> "sa-learn --dump magic"?


bayes_seen 21M
bayes_toks 9.3M

0.000          0          3          0  non-token data: bayes db version
0.000          0     131710          0  non-token data: nspam
0.000          0      40140          0  non-token data: nham
0.000          0     469228          0  non-token data: ntokens
0.000          0 1241679918          0  non-token data: oldest atime
0.000          0 1243580885          0  non-token data: newest atime
0.000          0 1243594258          0  non-token data: last journal sync
atime
0.000          0 1243594283          0  non-token data: last expiry atime
0.000          0     691200          0  non-token data: last expire atime
delta
0.000          0      13745          0  non-token data: last expire
reduction count


>
> Have you determined *that* it is Bayes that is creating your asserted
> permonance problem?


I am trying to speed up I/O wherever it is involved within my resources.
Since, the bayes database is an oft accessed file, I would like to have it
on a faster filesystem or tmpfs.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.mailscanner.info/pipermail/mailscanner/attachments/20090529/413060d8/attachment.html