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
#   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
key_buffer_size=64M
table_cache=256

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

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

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

<with_innobase>
#   Innobase DB
innodb_buffer_pool_size=70M
innodb_additional_mem_pool_size=2M
innodb_log_files_in_group=3
innodb_log_file_size=20M
innodb_log_buffer_size=8M
innodb_lock_wait_timeout=50

</with_innobase>
#
#   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
pid_file     = @l_prefix@/var/mysql/mysqld.pid
user         = @l_rusr@
basedir      = @l_prefix@