openpkg-packages/mysql/my.cnf

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

[client]

socket                           = @l_prefix@/var/mysql/mysql.sock
port                             = 3306

[mysqld]

bind-address                     = 127.0.0.1
port                             = 3306
#skip-networking

tmpdir                           = @l_prefix@/var/mysql/tmp
log                              = @l_prefix@/var/mysql/common.log
#log-bin                         = @l_prefix@/var/mysql/binary.log
#server-id                       = 1

key_buffer_size                  = 64M
table_cache                      = 256
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
query_cache_type                 = 1
query_cache_limit                = 1M
query_cache_size                 = 32M
ft_min_word_len                  = 3

<with_bdb>
bdb_cache_size                   = 8M
bdb_log_buffer_size              = 32k
bdb_max_lock                     = 10000

</with_bdb>
<with_innobase>
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>
[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@