On Wed, May 12, 2010 at 11:31 AM, Gary Smith <gary.sm...@holdstead.com> wrote: >> 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: >> > > I think a lot of that really depends on the size of the database. If it's > under 1GB in size, I'd say that stock setting will work fine. There are some > guides out there on capacity planning innodb that you can search on. > Generally, if it's a dedicated mysql server, then you can tweak them. If > it's shared, I wouldn't change much (except maybe the maximum connections to > the server). > > This is what we run on a 4gb ram server. The innodb_buffer_pool_size is > larger than the entire dataset, so I think ours could even be low than that. > > innodb_file_per_table > innodb_flush_log_at_trx_commit = 1 > innodb_autoextend_increment = 2M > innodb_buffer_pool_size = 256M > innodb_additional_mem_pool_size = 48M
Thanks for the details Gary. We settled on the following innoDB settings for now: --- innodb_file_per_table innodb_flush_log_at_trx_commit = 2 innodb_data_file_path = ibdata1:10M:autoextend innodb_buffer_pool_size=512M innodb_additional_mem_pool_size=20M innodb_log_file_size=128M innodb_log_buffer_size=8M --- We'll see how it goes. Rob
