Miscellany

[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
#log=/var/log/mysql-queries.log
log_slow_queries=/var/log/mysqld_slow.log
long_query_time=2
#log-queries-not-using-indexes

connect_timeout=15
interactive_timeout=100

key_buffer=348M
max_allowed_packet=16M
max_connections=500
max_connect_errors=10

myisam_sort_buffer_size=96M

max_heap_table_size = 348M
tmp_table_size=348M
concurrent_insert = 2
low_priority_updates = 1

sort_buffer_size=5M
read_buffer_size=5M
join_buffer_size=5M
read_rnd_buffer_size=8M
table_cache=2048
thread_cache_size=200
thread_concurrency=4
wait_timeout=60

query_cache_type=1
query_cache_limit=1M
query_cache_size=32M



#skip-innodb
#innodb_buffer_pool_size = 1024M

skip-locking
skip-name-resolve


[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/lib/mysql/localhost.localdomain.pid