Ok, how can I use signature-less? Another question: I need to truncate the tables and restart from the scratch ? In your opinion, what is the best dspam setup (dspam, mysql, postfix, etc.) to my case?
----- Mensagem original ----- De: k...@rice.edu Para: "Alfredo Saldanha" <asalda...@infolink.com.br> Cc: dspam-user@lists.sourceforge.net Enviadas: Quinta-feira, 20 de junho de 2013 16:27:22 Assunto: Re: [Dspam-user] Huge MySQL Database On Thu, Jun 20, 2013 at 03:57:15PM -0300, Alfredo Saldanha wrote: > Hi Ken, > > My space should be tokens, I think... > > mysql> select count(*) from dspam_token_data; +----------+ > | count(*) | > +----------+ > | 12948090 | > +----------+ > 1 row in set (2 min 11.29 sec) > > mysql> select count(*) from dspam_signature_data; > +----------+ > | count(*) | > +----------+ > | 423411 | > +----------+ > 1 row in set (4.71 sec) > > I can change the configuration, no problem. > What settings you suggest? > Here is one sample I have: dspam_token_data = 126768978 dspam_signature_data = 733144 size: dspam_token_data = 4563683208 dspam_signature_data = 11444956019 A row of dspam_token_data is much smaller than on in dspam_signature_data. I guess I do not see how you are blowing out your mysql when your counts are so much less than these which are about 18GB, far less than your 70GB. Regards, Ken ------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
