# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql

symbolic-links=0

lower_case_table_names=1
default-storage-engine=INNODB  
character-set-server=utf8  
collation-server=utf8_general_ci
event_scheduler=ON
default-storage-engine=INNODB
max_allowed_packet = 16M
wait_timeout	= 500
interactive_timeout	= 500
connect_timeout = 20

back_log = 512
max_connections = 2048
max_connect_errors = 128
open_files_limit = 8192

key_buffer_size = 1024M

sort_buffer_size = 32M
read_buffer_size = 32M
join_buffer_size = 32M
read_rnd_buffer_size = 8M
bulk_insert_buffer_size = 32M

myisam_max_sort_file_size = 100G
myisam_sort_buffer_size=64M

thread_cache_size = 64
thread_stack = 512k

query_cache_limit = 4M
query_cache_size = 128M
query_cache_min_res_unit= 2k

tmp_table_size = 256M
max_heap_table_size = 256M
max_tmp_tables = 512 
bulk_insert_buffer_size = 16M
skip-name-resolve
slow_query_log
long_query_time = 0.1

innodb_open_files = 2048

#memlock
innodb_buffer_pool_instances=4
innodb_buffer_pool_size = 3G
innodb_log_file_size = 64M
innodb_lock_wait_timeout = 50
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_write_io_threads = 8
innodb_read_io_threads = 8
innodb_thread_concurrency = 16
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90

[mysqldump]
quick
max_allowed_packet = 48M

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

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