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
