File: //etc/my.cnf
[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
innodb_buffer_pool_size = 2G
max_allowed_packet = 268435456
open_files_limit=40000
innodb_file_per_table = 1
mysqlx = 0
tmp_table_size = 64M
max_heap_table_size = 64M
event_scheduler=off
max_connections = 200
# query_cache_size = 64M
# query_cache_limit = 2M
table_open_cache = 4000
innodb_flush_log_at_trx_commit = 2