my.cnf

[mysqld]
max_connections               = 300            # default
character_set_server          = utf8
query_cache_size              = 64M
query_cache_type              = 1
table_open_cache              = 600            # 300 connections * 2 tables
table_definition_cache        = 200
key_buffer_size               = 500M
myisam_max_sort_file_size     = 100G
myisam_recover                = DEFAULT,BACKUP
read_buffer_size              = 128K           # default
read_rnd_buffer_size          = 256K           # default
join_buffer_size              = 128K           # default
log_bin                       = mysql-bin
binlog_format                 = MIXED
max_binlog_size               = 128M
expire_logs_day               = 15
server_id                     = 1
slow_query_log
long_query_time               = 3
log_queries_not_using_indexes
open_files_limit              = 3000
skip_innodb