On Jun 8, 2007, at 2:22 PM, alex handle wrote: >> Hi Alex, please forgive me for jumping in, but I have a question >> about this. My bayes-related tables are set up to use the MyISAM >> engine...Is InnoDB's r/w concurrency a big enough benefit for me to >> change my existing setup? > > if you have a lot of traffic i would consider to switch to innodb, not > only for performance, but also because innodb is more robust! > > If your server crashes it is very likely that your tables get > trashed and you > have to run "repair table". With Innodb your system should be up > and running > after a crash.
Excellent, thank you for the info. My mail server at work handles a good deal of traffic (small ISP), so this sounds worthwhile...I will make this change during my next maintenance window. > see http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html I will give this a read. Thanks again! -Dave -- Dave McGuire Port Charlotte, FL ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/