[mysqld]
user=mysql
port=3306
server-id=901
symbolic-links=0
init-connect='SET NAMES utf8'
innodb_support_xa=0
skip-name-resolve
#table_cache=600
thread_cache_size=156
myisam-recover=FORCE,BACKUP
bulk_insert_buffer_size=33554432
# Modify to 75% of memory or a max of 32GB
innodb_buffer_pool_size=16G
myisam_sort_buffer_size=33554432
innodb_log_file_size=1G
key_buffer_size=512M
max_heap_table_size=512M
query_cache_size=512M
tmp_table_size=512M
sort_buffer_size=8388608
local_infile=1
skip-symbolic-links
connect_timeout=20
default-storage-engine=innodb
innodb_log_buffer_size=8388608
federated=on
innodb_file_per_table
table_open_cache=2250
open_files_limit = 100000
character_set_client=utf8
innodb_file_format=Barracuda

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock
log-error=/var/lib/mysql/mysqld.log
log=1
general_log=1
pid-file=/var/lib/mysql/mysqld.pid
set-variable=max_connections=250
default-character-set=system_character_set
#character-set-client-handshake=utf8
character_set_connection=utf8
character_set_results=utf8
max_allowed_packet=64M
innodb_log_file_size=1G

[client]
default-character-set=utf8