Pavel wrote: >> Since you mentioned MySQL. I will assume you have done some tuning, >> but if not: If using MySQL >= 4.1, use MySQL and not SQL here:
> I have SQL module, not MySQL... I'll try it, thanks. >> >> bayes_store_module Mail::SpamAssassin::BayesStore::MySQL >> >> and these may be of interest (especially if you are using innodb): >> http://www200.pair.com/mecham/spam/mysqlspeed.txt >> http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ >> http://www.mysql.com/news-and-events/newsletter/2003-11/a0000000269.html >> >> MySQL crawls if using innodb and the default innodb_buffer_pool_size >> of 8M. Just increasing it to 128MB makes a hugh difference. >> > I already have > innodb_data_file_path = /var/lib/mysql/ibdata1:500M:autoextend > which should be enough... I don't know enough about MySQL to know if it is or not. This does not at first glance seem to be related to innodb_buffer_pool_size however. >> I assume you prune your AWL data on occasion? > I thought it is done automatically. Should I run a cronjob for this purpose? AFAIK AWL grows forever. Something like this may help somewhat: DELETE FROM `awl` WHERE `count` = 1 AND `totscore` > 5; I see you are on the Postfix list so you are in good hands. I hope you get this problem solved. I have seen others with similar issues lately but have no 'magic bullet' as far as a solution goes. On the surface it appears some servers are really getting hammered. Gary V ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
