Thanks Gary V for you answers, Could you suggest me something about this problem..
> > > 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? > TIA, 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/
