# Example mysql config file.
# You can copy this to one of:
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is @localstatedir@) or
# ~/.my.cnf to set user-specific options.
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
 
# This will be passed to all mysql clients
[client]
port            = 4500
socket          = /tmp/mysql_2.sock
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# The MySQL server
[mysqld]
default-character-set   = latin1
port            = 4500
socket          = /tmp/mysql_2.sock
language        = /usr/local/mysql/share/mysql/english/
base            = /usr/local/mysql
skip-locking
set-variable    = key_buffer=64M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
set-variable    = table_cache=200
set-variable    = read_buffer_size=256K
set-variable    = read_rnd_buffer_size=256K
set-variable    = back_log=300
set-variable    = thread_cache=200
set-variable    = query_cache_size=16M
set-variable    = sort_buffer_size=256K
set-variable    = delayed_insert_timeout=150
set-variable    = wait_timeout=20
set-variable    = max_connections=320
set-variable    = myisam_sort_buffer_size=128M
set-variable    = thread_concurrency=2
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=140M
set-variable = innodb_additional_mem_pool_size=40M
set-variable = innodb_log_file_size=5M
set_variable = innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1
## Start logging
#log
 
[mysqldump]
default-character-set   = latin1
#quick
#set-variable   = max_allowed_packet=16M
 
[mysql]
default-character-set   = latin1
#no-auto-rehash
 
[isamchk]
#set-variable   = key_buffer=16M