.my.cnf

[mysqld]
port = 3306
max_allowed_packet = 256M
max_connect_errors = 1000000

skip_external_locking
skip_name_resolve

innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT
innodb_flush_neighbors = 0
innodb_stats_on_metadata = 0

query_cache_type = 0
query_cache_size = 0

low_priority_updates = 1

back_log = 512

interactive_timeout = 120
wait_timeout = 120

table_definition_cache = 2000
table_open_cache = 2000

# Logging
log_queries_not_using_indexes = 1
long_query_time = 5
slow_query_log = 1
slow_query_log_file = slow.log
log_error = error.log

innodb_lock_wait_timeout = 15
connect_timeout = 15

lower_case_table_names = 1

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
character-set-client-handshake = FALSE
skip-character-set-client-handshake
init-connect = 'SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'

performance_schema = on
transaction-isolation = READ-COMMITTED

log_warnings = 2
innodb_print_all_deadlocks = 1

[mysql]
default-character-set = utf8mb4

[client]
port=3306
default-character-set = utf8mb4