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