[mysqld]
# server
skip-name-resolve
skip-innodb_adaptive_hash_index
max_connections=200
thread_cache_size=200
table_open_cache=9600
table_definition_cache=8000
max_connect_errors=100
max_allowed_packet=16M
query_cache_size=64M
tmp_table_size=128M
max_heap_table_size=128M
tmpdir=/home/mysql/tmp

# buffer
read_buffer_size=1M
read_rnd_buffer_size=1M
sort_buffer_size=256K

# MyISM
key_buffer_size=128M
myisam_sort_buffer_size=128M

# InnoDB
default-storage-engine=INNODB

innodb_thread_concurrency=%%MY_INNODB_THREAD_CONCURRENCY%%
innodb_buffer_pool_size=%%MY_INNODB_BUFFER_POOL_SIZE%%
innodb_log_file_size=128M
innodb_file_per_table
innodb_open_files=8000
innodb_flush_method=O_DIRECT

# Timeout
interactive_timeout=300
wait_timeout=300

# SSL
ssl-cert=/home/mysql/key/public.pem
ssl-key=/home/mysql/key/secret.pem

# Log
slow_query_log=1
long_query_time=10
log_output=FILE

# Character-set
character-set-server=utf8
collation-server=utf8_general_ci

[mysql]
default-character-set=utf8