mysql_tuning_basic

[mysqld]
max_connections = 100

default_authentication_plugin=mysql_native_password

thread_cache_size = 1024
innodb_thread_concurrency = 0

table_open_cache = 10240
table_definition_cache = 10240
open_files_limit = 10000

key_buffer_size = 128M
myisam_sort_buffer_size = 8M

read_buffer_size = 2M
read_rnd_buffer_size = 4M
join_buffer_size = 2M
sort_buffer_size = 2M

innodb_buffer_pool_size = 1G
innodb_log_buffer_size = 12M
innodb_log_file_size = 64M
innodb_flush_log_at_trx_commit  = 1
innodb_file_per_table
innodb_io_capacity = 500
innodb_read_io_threads = 10
innodb_write_io_threads = 5
innodb_flush_method='O_DIRECT'
innodb_sync_array_size=16

transaction_isolation='READ-COMMITTED'

binlog_row_image='minimal'

# https://www.percona.com/blog/a-dive-into-mysql-multi-threaded-replication/
#binlog_group_commit_sync_no_delay_count=8
#binlog_group_commit_sync_delay=3

tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 512M

binlog_cache_size = 131072

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

explicit_defaults_for_timestamp = 1
log-timestamps = 'SYSTEM'

innodb_monitor_enable='all'

[mysql-5.7]
query_cache_type=0
query_cache_size=0