5.7 my.cnf

[mysqld]
binlog_format = ROW

character_set_server = utf8
connect_timeout = 10
collation_server = utf8_general_ci

innodb_buffer_pool_size = 8G # (adjust value here, 50%-70% of total RAM)
innodb_log_file_size = 1G
innodb_file_per_table
innodb_flush_log_at_trx_commit = 1 # may change to 2 or 0
innodb_flush_method = O_DIRECT
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_instances=8
innodb_thread_concurrency=0
interactive_timeout = 120

join_buffer_size = 2M
key_buffer_size = 8M

local-infile=0
long_query_time = 5

max_allowed_packet = 16M
max_connections=100
max_heap_table_size = 32M
myisam_sort_buffer_size = 64M

open_files_limit = 64000

port = 3306

query_cache_type = 0
query_cache_size = 32M
query_cache_limit = 128KM

table_open_cache = 4000
table_definition_cache = 10000
thread_cache_size = 80
tmp_table_size = 32M
tmpdir          = /tmpmysql/

#read_buffer = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 1M

skip-name-resolve
socket = /usr/local/mysql/data/mysql.sock
sort_buffer_size = 2M

#sql_mode = "NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

wait_timeout = 60
#write_buffer = 2M

[mysqldump]
max_allowed_packet = 16M
quick

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 1M
sort_buffer_size = 1M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[client]
port = 3306
socket = /usr/local/mysql/data/mysql.sock