my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
server-id = 1
default_storage_engine = InnoDB
character-set-server=utf8mb4 

thread_cache_size = 128
table_definition_cache=4096
table_open_cache = 4096
query_cache_size = 128M
tmp_table_size = 128M
sort-buffer-size = 128M
innodb_buffer_pool_size = 1024M
innodb_file_per_table = 1
slow_query_log = ON
long-query-time = 2
slow_query_log_file = /var/log/mariadb/slow.log
interactive_timeout = 2592000
wait_timeout = 2592000
max_allowed_packet = 100G
max_connections = 100000
max_connect_errors = 1000000

[mysqld_safe]
open_files_limit = 65535
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
# include all files from the config directory
!includedir /etc/my.cnf.d