crowbar/crowbar-openstack

View on GitHub
chef/cookbooks/mysql/templates/default/tuning.cnf.erb

Summary

Maintainability
Test Coverage
[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