Goodday. I'm installing a new spamfilter for my company, and i figured i'd try Bayes is SQL. However i have some problems with maintenance and a few general questions.
I'm not completely sure that force-expire does anything. I ran it several times last week, and nothing showed up in the 'last expiry atime' column. So i figured it wasn't working. But lo and behold when i ran it to get output for this e-mail, something did happen. 1) Now, expiry gives me some 'strange' output. Can anyone take a look at this and tell me if it's normal? 2) The 'sync' apparently will not work. No sync atime is reported. I attached the sync, expire and dump magic for debugging purposes. The dump magic was run after sync and expire. 3) As i understand i need to run 'optimize table' on the 'tokens_seen' regularly to keep it clean right? 4) Are there any other things i need to run regularly, assuming i can make the sync/expire work? 5) Another 'problem' i'm having is that restoring from backup -> sql is horribly slow. Is this normal or might my mysql/network not be running optimally? I don't really know how to test bayes queries, but normal queries to the SQL go fast. sa-learn --force-expire -D http://pastebin.com/m5f32ae32 sa-learn --dump magic -D http://pastebin.com/m42066d18 sa-learn --sync -D http://pastebin.com/m3d4a8931 Versions: CentOS 5.3 Spamassassin 3.2.5 Perl: 5.8.8 MySQL: 5.0.45-7.el5 (The mysql is run on another server of WAN) perl-DBD-mysql: 4.011-1.el5.rf --- With regards, Kasper
