[client]
port=3306

[mysql]
default-character-set=utf8

[mysqld]
port=3306
basedir=/data/server/mysql
datadir=/data/server/mysql/data
socket=/dev/shm/mysql.5.7.sock
log-error=/data/server/mysql/logs/mysql_error.log
explicit-defaults-for-timestamp=true

character-set-server=utf8
default-storage-engine=MyISAM
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=16000

query_cache_size=0
tmp_table_size=18M

thread_cache_size=8
myisam_max_sort_file_size=64G
myisam_sort_buffer_size=35M
key_buffer_size=25M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K

innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M

innodb_buffer_pool_size=47M
innodb_log_file_size=24M
innodb_thread_concurrency=8

slow-query-log=On
slow_query_log_file=/data/server/mysql/logs/mysql_slow_query.log
long_query_time=3
log_queries_not_using_indexes = ON

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/data/server/mysql/logs/mysql5.7.log
pid-file=/data/server/mysql/logs/mysql5.7.pid

#
# These groups are read by MariaDB command-line tools
# Use it for options that affect only one utility
#

[mysql]

[mysql_upgrade]

[mysqladmin]

[mysqlbinlog]

[mysqlcheck]

[mysqldump]

[mysqlimport]

[mysqlshow]

[mysqlslap]