[server]

[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking

key_buffer_size		= 4G
max_allowed_packet	= 6G
thread_stack		= 192K
thread_cache_size       = 8
sort_buffer_size        = 2M
net_buffer_length       = 16K
myisam_sort_buffer_size = 4G
myisam_recover_options  = BACKUP
max_connections         = 10000
table_open_cache        = 3167
#table_cache            = 64
#thread_concurrency     = 10

query_cache_limit	= 1M
query_cache_size        = 20M

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1
log_error = /var/log/mysql/error.log
slow_query_log_file	= /var/log/mysql/mariadb-slow.log
long_query_time = 10
log_slow_rate_limit	= 1000
log_slow_verbosity	= query_plan
log-queries-not-using-indexes

expire_logs_days	= 10
max_binlog_size   	= 100M

innodb_buffer_pool_size   = 8G
innodb_log_file_size      = 48M
innodb_log_buffer_size    = 16M
innodb_data_home_dir      = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
innodb_data_file_path     = ibdata1:12M:autoextend
innodb_lock_wait_timeout  = 50
innodb_flush_log_at_trx_commit = 1

character-set-server  = utf8mb4
collation-server      = utf8mb4_general_ci

#bind 127.0.0.1 remove this for remote access
#GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'some_characters' WITH GRANT OPTION; FLUSH PRIVILEGES;

[embedded]

[mariadb]