[mysqld]
skip-locking
skip-innodb
ft_min_word_len=2
ft_max_word_len=56
log=/tmp/mysql.log
log-slow-queries=/tmp/slow.mysql.log
query_cache_limit=256M
query_cache_size=512M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=32M
table_cache=1280M
key_buffer=1024M
join_buffer=64M
max_allowed_packet=128M
record_buffer=1M
sort_buffer_size=512M
read_buffer_size=512M
read_rnd_buffer_size=512M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=8
myisam_sort_buffer_size=512M
myisam_max_sort_file_size=50G
#log-bin
server-id=1
init_connect='SET collation_connection = tis620_thai_ci'
init_connect='SET NAMES tis620'
default-character-set=tis620
long_query_time=3
log_slow_queries = /tmp/mysql.slow.log
log_queries_not_using_indexes
expire_logs_days=7
max_heap_table_size=4096M
tmp_table_size=4096M



[safe_mysqld]
err_log=/var/log/mysqld.log
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=128M

[mysql]
no-auto-rehash
default-character-set=utf8
#safe-updates

[isamchk]
key_buffer=2048M
sort_buffer=512M
read_buffer=512M
write_buffer=128M

[myisamchk]
key_buffer=2048M
sort_buffer=512M
read_buffer=512M
write_buffer=256M

[mysqlhotcopy]
interactive-timeout