[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0

# INNODB
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size=50M
innodb_flush_log_at_trx_commit=0
innodb_file_io_threads=8
innodb_lock_wait_timeout=50
#innodb_log_file_size=64M
#innodb_log_buffer_size=8M

key_buffer_size = 128M
key_cache_division_limit = 70

max_allowed_packet = 100M
max_connections = 50
table_cache = 4096

sort_buffer_size = 1M
read_buffer_size = 512k
read_rnd_buffer_size = 512k
join_buffer_size = 64M

net_buffer_length = 512k
thread_stack = 64K

query_cache_size = 1024M
query_cache_limit = 16M
query_cache_type = 1

tmpdir = /mnt/mysql
tmp_table_size = 1524M
max_heap_table_size = 1524M
thread_cache_size = 2048

wait_timeout = 30

default-storage-engine=MyISAM

loose_handlersocket_port = 9998
loose_handlersocket_threads = 16
loose_handlersocket_threads_wr = 1
open_files_limit = 65535

# LOG
log-error = /var/log/mysql/error.log
long_query_time = 3
log-slow-queries = /var/log/mysql/log-slow-queries.log
log-queries-not-using-indexes = /var/log/mysql/log-noindex-queries.log



server-id       = 1
skip-federated
#skip-innodb



[mysqld_safe]
log-error=/var/log/mysql/error.log
pid-file=/var/run/mysqld/mysqld.pid