[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" 
max_connections = 4096

innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit=40000
innodb_file_per_table = 1

collation-server = utf8_unicode_ci
character-set-server = utf8

bind-address = 127.0.0.1
#table_open_cache = 2048
performance_schema = ON
#innodb_buffer_pool_size = 3G
#innodb_log_files_in_group = 4

#query_cache_size = 0 #(=0)
#query_cache_type = 0 #(=0)
#query_cache_limit = 10M #(> 1M, or use smaller result sets)
#join_buffer_size = 10M #(> 1.0M, or always use indexes with JOINs)
#tmp_table_size = 256M #(> 32M)
#max_heap_table_size = 256M #(> 32M)
#table_open_cache = 4096 #(> 2048)
#table_definition_cache = 12758 #(1424) > 12756 or -1 (autosizing if supported)
#innodb_log_file_size = 192M #should be 192M (=192M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
#innodb_buffer_pool_instances = 18 #(=3)

skip-name-resolve=0
join_buffer_size=1M #(> 256.0K, or always use indexes with JOINs)
table_definition_cache=11555 # (2000) > 11555 or -1 (autosizing if supported)
key_buffer_size=0
innodb_buffer_pool_size=6G #(>= 5.9G) if possible.
innodb_redo_log_capacity=1G # should be (=32M) if possible, so InnoDB Redo log Capacity equals 25% of buffer pool size.
innodb_log_buffer_size=64M #(> 16M)

log-error-verbosity=1
max_connections = 4096
mysqlx=0