#
# Cookbook Name:: mysql
# Attributes:: server
#
# Copyright 2008-2009, Opscode, Inc.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.
#

#::Chef::Node.send(:include, Opscode::OpenSSL::Password)

#set_unless[:mysql][:server_root_password] = secure_password
#set_unless[:mysql][:server_repl_password] = secure_password
default[:mysql][:bind_address]         = "127.0.0.1"
default[:mysql][:datadir]              = "/usr/local/var/mysql"

default[:mysql][:tunable][:back_log]             = "128"
default[:mysql][:tunable][:key_buffer]           = "32M"
default[:mysql][:tunable][:max_allowed_packet]   = "16M"
default[:mysql][:tunable][:max_connections]      = "20"
default[:mysql][:tunable][:max_heap_table_size]  = "32M"
default[:mysql][:tunable][:myisam_recover]       = "BACKUP"
default[:mysql][:tunable][:net_read_timeout]     = "30"
default[:mysql][:tunable][:net_write_timeout]    = "30"
default[:mysql][:tunable][:table_cache]          = "256"
default[:mysql][:tunable][:table_open_cache]     = "256"
default[:mysql][:tunable][:thread_cache]         = "128"
default[:mysql][:tunable][:thread_cache_size]    = 8
default[:mysql][:tunable][:thread_concurrency]   = 10
default[:mysql][:tunable][:thread_stack]         = "256K"
default[:mysql][:tunable][:wait_timeout]         = "180"

default[:mysql][:tunable][:query_cache_limit]    = "1M"
default[:mysql][:tunable][:query_cache_size]     = "32M"

default[:mysql][:tunable][:tmp_table_size]       = "32M"
default[:mysql][:tunable][:max_heap_table_size]  = "64M"


default[:mysql][:tunable][:log_slow_queries]     = "/usr/local/var/log/mysql/slow.log"
default[:mysql][:tunable][:long_query_time]      = 2

default[:mysql][:tunable][:innodb_buffer_pool_size] = "256M"
default[:mysql][:tunable][:key_buffer_size]      = "4M"
default[:mysql][:tunable][:join_buffer_size]     = "4M"
default[:mysql][:tunable][:read_buffer_size]     = "4M"
default[:mysql][:tunable][:read_rnd_buffer_size] = "4M"
default[:mysql][:tunable][:sort_buffer_size]     = "4M"