chef/cookbooks/mysql/templates/default/tuning.cnf.erb
[mysqld]
innodb_buffer_pool_size = <%= @innodb_buffer_pool_size %>M
innodb_log_file_size = <%= [8, @innodb_buffer_pool_size / 4].max %>M
innodb_buffer_pool_instances = <%= @innodb_buffer_pool_instances %>
<% node['database']['mysql']['innodb_tunings'].each do |line| %>
<%= line %>
<% end %>
# 0 should bring better performance but has slight risk of losing some logs
innodb_flush_log_at_trx_commit = <%= @innodb_flush_log_at_trx_commit %>
max_connections = <%= @max_connections %>
tmp_table_size = <%= @tmp_table_size %>M
max_heap_table_size = <%= @max_heap_table_size %>M
skip_name_resolve = 1