> 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
