We've found that our MyISAM tables being used with Bayes in MySQL have caused some bottlenecks on our busier mail servers. We're contemplating using inooDB just for the Bayes database. If MySQL will only be using innoDB, does anyone have any recommendations for innoDB settings in my.cnf to optimize this setup? Things such as:
# Set buffer pool size to 50-80% of your computer's memory innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size=512M innodb_additional_mem_pool_size=20M # # Set the log file size to about 25% of the buffer pool size innodb_log_file_size=128M innodb_log_buffer_size=8M Our current tables are of the order: bayes_expire 530 MyISAM bayes_global_vars 1 MyISAM bayes_seen 11,911 MyISAM bayes_token 8,173,050 MyISAM bayes_vars 260 MyISAM 5 table(s) Sum 8,185,752 MyISAM Thanks for any feedback for optimizing innoDB when it's used solely for a Bayes database. Rob
