On 10/03/09 20:16, quoth Benny Pedersen: > On lør 03 okt 2009 23:41:41 CEST, "Steven W. Orr" wrote >> Thank you. I am still confused in one area: > > no problem > >> These scripts do not touch the bayes_token table, and it is this table >> that >> has by far the most number of rows. > > i do not touch it for one reason is that it will autoflush oldest > tokens, if > the db gets to big you simply have to much tokens know in the db, its not a > error > >> I currently have over 230000 rows in that >> table. Do I manage these myself, > > no this is part of how bayes works > >> or is there something that is supposed to >> make this happen automatically? > > nope, my setup above is all needed to make it optimized, i could make a > bug on > this for 3.3.x but it will be nice others can confirm if i miss > something :) > >> I admit that I am confused by the man page for >> sa-learn because it seems to suggest that "expiry" (whatever that is) is >> performed there, but I just don't see anything that says exactly what >> to do. >> Also, the man page refers to a "journal" that I know nothing about. > > this is for non mysql setup imho >
I did some googling, and the more I read, the more apparent that the documentation is a little light. So here are the questions that I think are really the 800 pound elephant in the room: * If I do set bayes_auto_expire to 0 and I am using MySQL then does any run of sa-learn cause the expired rows of bayes_token to be removed if there are no corresponding rows that relate back to bayes_seen? * If I set bayes_auto_expire to 0, and I am using MySQL then do I need to run a cron job which does this? How often should I run it? sa-learn --force-expire --sync * I set bayes_sql_override_username to something. If I did not, then do I have to have a cron job as described above that runs as each user that is listed in bayes_vars.username? * If I set bayes_auto_expire to 1, then does every update of any row in the spamassassin database try to clean up these rows that could be removed? I'm hoping that I'm not ranting. Sorry. -- Time flies like the wind. Fruit flies like a banana. Stranger things have .0. happened but none stranger than this. Does your driver's license say Organ ..0 Donor?Black holes are where God divided by zero. Listen to me! We are all- 000 individuals! What if this weren't a hypothetical question? steveo at syslang.net
signature.asc
Description: OpenPGP digital signature
