Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Michael Parker
On Apr 21, 2008, at 8:40 AM, Chris St. Pierre wrote: On Mon, 21 Apr 2008, Michael Parker wrote: select * from bayes_vars; ... 2289 rows in set (0.00 sec) What user do you run bayes under on your MXs? I think you've found the issue. We run as spamd. # sa-learn -u spamd --dump magic 0.00

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Chris St. Pierre
On Mon, 21 Apr 2008, Michael Parker wrote: select * from bayes_vars; ... 2289 rows in set (0.00 sec) What user do you run bayes under on your MXs? I think you've found the issue. We run as spamd. # sa-learn -u spamd --dump magic 0.000 0 3 0 non-token data: bay

Re: Bayes DB growing without bound; expiry not working

2008-04-21 Thread Michael Parker
On Apr 21, 2008, at 8:17 AM, Chris St. Pierre wrote: Consequently, my database is growing, apparently without bound. Any ideas how I can get expiry to work properly again? (Hopefully without completely dumping the database?) select * from bayes_vars; What user do you run bayes under on yo

Bayes DB growing without bound; expiry not working

2008-04-21 Thread Chris St. Pierre
I have two MXes, both writing Bayes data to a shared MySQL database. Something is quite awry. My Bayes database is _huge_: -rw-rw 1 mysql mysql 145044032 Apr 21 08:09 bayes_seen.MYD -rw-rw 1 mysql mysql 189879296 Apr 21 08:09 bayes_seen.MYI -rw-rw 1 mysql mysql 1881960784 Apr 21 08