On 04/22/2010 09:46 AM, Dale Gallagher wrote:
> On 22 April 2010 10:42, Dale Gallagher<dale.gallag...@gmail.com>  wrote:
>    
>> potential issues with my MySQL config below? The server in question
>> runs mysql-standard-4.1.7-pc-linux-i686 and DSPAM 3.9.0. I've included
>> my dspam.conf file too.
>>      
> And here is the directory listing for the dspam MySQL database files:
>
> -rw-rw----    1 mysql    mysql          65 Dec  9  2004 db.opt
> -rw-rw----    1 mysql    mysql           0 Apr 11 11:52 dspam_preferences.MYD
> -rw-rw----    1 mysql    mysql        1024 Apr 11 11:52 dspam_preferences.MYI
> -rw-rw----    1 mysql    mysql        8632 Apr 11 11:52 dspam_preferences.frm
> -rw-rw----    1 mysql    mysql    157308904 Apr 22 08:44
> dspam_signature_data.MYD
> -rw-rw----    1 mysql    mysql     1080320 Apr 22 08:44 
> dspam_signature_data.MYI
> -rw-rw----    1 mysql    mysql        8704 Apr 11 10:38 
> dspam_signature_data.frm
> -rw-rw----    1 mysql    mysql       13248 Apr 22 08:44 dspam_stats.MYD
> -rw-rw----    1 mysql    mysql        4096 Apr 22 08:09 dspam_stats.MYI
> -rw-rw----    1 mysql    mysql        9002 Apr 11 10:39 dspam_stats.frm
> -rw-rw----    1 mysql    mysql    356053060 Apr 22 08:44 dspam_token_data.MYD
> -rw-rw----    1 mysql    mysql    553879552 Apr 22 08:44 dspam_token_data.MYI
> -rw-rw----    1 mysql    mysql        8716 Apr 11 11:54 dspam_token_data.frm
> -rw-rw----    1 mysql    mysql           0 Sep 16  2009 dspam_token_data_2.MYD
> -rw-rw----    1 mysql    mysql        1024 Sep 16  2009 dspam_token_data_2.MYI
> -rw-rw----    1 mysql    mysql        8716 Sep 16  2009 dspam_token_data_2.frm
> -rw-rw----    1 mysql    mysql        6308 Apr 11 11:53 dspam_virtual_uids.MYD
> -rw-rw----    1 mysql    mysql       12288 Apr 11 11:53 dspam_virtual_uids.MYI
> -rw-rw----    1 mysql    mysql        8596 Apr 11 11:53 dspam_virtual_uids.frm
>
> ------------------------------------------------------------------------------
>    


Hello Dale,

How are you feeding messages to dspam? through a .qmail file with 
preline? through simscan? other?

Also, note that your database already has ~679M in indexes. Is your 
MySQL server tunned for that ammount of data? What's the key_buffer 
size, query_cache_size and read_buffer_size? Is that MySQL server 
providing only DSPAM database or does it have other DBs? If there are 
others, are you sure it's DSPAM that's holding back?

You might want to take a look at some performance tuning pages, such as 
http://dev.mysql.com/doc/refman/5.0/en/optimization.html, or even 
http://www.debianhelp.co.uk/mysqlperformance.htm, or try the mysqltuner 
script available at http://blog.mysqltuner.com/download/

Don't forget to check that your purge scripts are being run.


Regards,

Hugo Monteiro.



-- 
fct.unl.pt:~# cat .signature

Hugo Monteiro
Email    : hugo.monte...@fct.unl.pt
Telefone : +351 212948300 Ext.15307
Web      : http://hmonteiro.net

Divisão de Informática
Faculdade de Ciências e Tecnologia da
                   Universidade Nova de Lisboa
Quinta da Torre   2829-516 Caparica   Portugal
Telefone: +351 212948596   Fax: +351 212948548
www.fct.unl.pt                ap...@fct.unl.pt

fct.unl.pt:~# _


------------------------------------------------------------------------------
_______________________________________________
Dspam-user mailing list
Dspam-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspam-user

Reply via email to