#
# Base Container
#

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
max_heap_table_size = 8M
skip-name-resolve
open_files_limit = 8000

#
# * Basic Settings
#
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking
bind-address = 0.0.0.0

# For compatibility 
old_passwords	= 1

back_log=20
max_connections=60

# due to mysql internally considering connections from 'user@host1' as a separate user from 'user@host2',  max_user_connections is largely irrelevant in a clustered situation
max_user_connections=16
max_connect_errors=100000


key_buffer_size=24M
max_heap_table_size=4M
read_buffer_size=128K
read_rnd_buffer_size=128K
sort_buffer_size=256K
table_cache=1024
thread_cache_size=4
tmp_table_size=4M
join_buffer_size=4M
wait_timeout=60
thread_concurrency=4
innodb_file_per_table

max_allowed_packet	= 16M
thread_stack		= 128K

# query cache
query_cache_limit	= 1048576
query_cache_size        = 12M
query_cache_type        = 1

# slow query log
log-slow-queries	= /var/log/mysql/mysql-slow.log
long_query_time = 1

# memory trimming
#skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer		= 16M

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
