Hello, > >> 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.h > >> tml > >> > >> 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 have the same performance problems.. I will prune the bayes_token (InnoDB) table with the following query: delete from bayes_token where atime <= UNIX_TIMESTAMP(DATE_ADD(CURDATE(), INTERVAL -30 DAY)); but I get however a growing data lenght for that table, as well a growing index lenght. At certain time, I get poor performance for amavisd-new (Indeed I get this kind of error from amavis-milter - I have sendmail-milter configuration: amavis-milter: thread_create() failed: 12, try again ) so I have to switch from MySQL DB to the native (local) DB for SA. Maybe is it worth to change to MyISAM table? > >> 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; Could You explain why you choose 5 as value threshold? Thanks, rocsca ------------------------------------------------------------------------- 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/
