[mysqld]

#tmpdir=/dev/shm
tmpdir=/tmp/mysqltmp/

slow_query_log=1
slow_query_log_file=/var/log/mysql/slow.log
long_query_time=1
#log_queries_not_using_indexes=1

max_connections=150
max_user_connections=18

innodb_file_per_table=1
local-infile=0
max_allowed_packet=268435456
open_files_limit=43762
ft_min_word_len=3

# was not there, was default 8M
key_buffer_size=1400

thread_cache_size=12
max_connections=200
innodb_buffer_pool_size=760M
join_buffer_size=64M
sort_buffer_size=64M

#was not there, was default 128k
read_buffer_size=64M

# was 512M
query_cache_size=512M
query_cache_limit=512M
table_cache=1024
table_open_cache=1024
tmp_table_size=512M
max_heap_table_size=512M

default-storage-engine=MyISAM
[myisamchk]
ft_min_word_len=3