openpkg-packages/mysql51/my.cnf

##
##  my.cnf -- MySQL configuration
##

[client]
socket       = @l_prefix@/var/mysql/mysql.sock
port         = 3306

[mysqld]
#
#   Network settings
#

bind-address = 127.0.0.1
port         = 3306

#   Unix domain socket only, disables TCP/IP
#skip-networking

#
#   Log file settings
#

#   log file destinations (must be in sync with settings in rc.conf)
log          = @l_prefix@/var/mysql/common.log
log-update   = @l_prefix@/var/mysql/update.log
#   binary log (use instead of log-update, server-id must be unique for
#   replication)
#log-bin      = @l_prefix@/var/mysql/binary.log
#server-id    = 1

#
#   Performance settings
#

#   most important tuning parameters for mysqld
set-variable = key_buffer_size=64M
set-variable = table_cache=256

#   less important tuning parameters (change if special problems occur)
set-variable = join_buffer_size=1M
set-variable = max_connections=1000
set-variable = max_connect_errors=10
set-variable = max_delayed_threads=20
set-variable = max_heap_table_size=16777216
set-variable = max_sort_length=1024
set-variable = max_user_connections=1000
set-variable = record_buffer=131072
set-variable = sort_buffer=4M
set-variable = key_buffer=1M
set-variable = tmp_table_size=32M

#   permanent query caching
set-variable = query_cache_type=1
#   maximum caching size of an individual query
set-variable = query_cache_limit=1M
#   maximum query cache size
set-variable = query_cache_size=32M

#   minimum chars for full-text search (FTS) index
#ft_min_word_len=3

#   Berkeley DB
set-variable = bdb_cache_size=@l_mysql_bdb_cache_size@
set-variable = bdb_log_buffer_size=@l_mysql_bdb_log_buffer_size@
set-variable = bdb_max_lock=@l_mysql_bdb_max_lock@

#   Innobase DB
#set-variable = innodb_buffer_pool_size=70M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=20M
#set-variable = innodb_log_buffer_size=8M
#set-variable = innodb_lock_wait_timeout=50

#
#   Miscellaneous
#

#   directory for temporary tables
tmpdir=@l_prefix@/var/mysql/tmp

[mysqld_safe]
datadir      = @l_prefix@/var/mysql
socket       = @l_prefix@/var/mysql/mysql.sock
set-variable = pid_file=@l_prefix@/var/mysql/mysqld.pid
user         = @l_rusr@
basedir      = @l_prefix@