[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
big-tables
character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect='set collation_connection = utf8_unicode_ci;'
back_log = 75
# skip-locking
local-infile=0
skip-innodb
skip-networking
default-storage-engine = MyISAM
key_buffer_size = 4M
myisam_sort_buffer_size = 4M
join_buffer_size = 700k
read_buffer_size = 700k
sort_buffer_size = 700k
table_cache = 4000
open_files_limit = 8192
thread_cache_size = 384
wait_timeout = 15
connect_timeout = 20
interactive_timeout = 100
tmp_table_size = 100M
tmpdir=/home/mysqltmp
max_tmp_tables = 140
max_connections = 300
max_user_connections = 90
max_heap_table_size = 2048M
max_allowed_packet = 8M
net_buffer_length = 8M
max_connect_errors = 70
max_write_lock_count = 16
thread_concurrency = 2
thread_stack = 32K
binlog_cache_size = 64K
concurrent_insert = 2
# table_lock_wait_timeout = 40
read_rnd_buffer_size = 1M
bulk_insert_buffer_size = 8M
query_cache_limit = 1M
query_cache_size = 6M
query_cache_type = 1
query_prealloc_size = 131072
query_alloc_block_size = 131072
transaction_alloc_block_size = 16384
transaction_prealloc_size = 4096
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=4M
#set-variable = bdb_max_lock=10000
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
set-variable = key_buffer=32M
set-variable = sort_buffer=16M
set-variable = read_buffer=8M
set-variable = write_buffer=8M
