配置文件如下:
[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8mb4
[mysqld_safe]
socket=/tmp/mysql.sock
nice=0
[mysqld]
character-set-client-handshake=FALSE
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
user= mysql
pid-file=/app/mysqld.pid
socket=/tmp/mysql.sock
port=3306
basedir=/usr/local/mysql
datadir=/app/data
tmpdir=/tmp
lc_messages_dir=/usr/share/mysql
lc_messages=en_US
skip_name_resolve=on
skip-external-locking
max_connections=5000
wait_timeout=600
max_allowed_packet=16M
thread_cache_size=256
sort_buffer_size=4M
bulk_insert_buffer_size=16M
tmp_table_size=64M
max_heap_table_size=64M
myisam_recover=BACKUP
key_buffer_size=256M
table_open_cache=400
myisam_sort_buffer_size=1024M
concurrent_insert=2
read_buffer_size=8M
read_rnd_buffer_size=8M
query_cache_limit=512K
query_cache_size=256M
general_log_file=/var/log/mysql/mysql.log
general_log=1
log_error=/var/log/mysql/err.log
log_warnings=2
slow_query_log=1
slow_query_log_file=/var/log/mysql/mariadb-slow.log
long_query_time=1
log_slow_verbosity=query_plan
log_bin=/var/log/mysql/mariadb-bin
log_bin_index=/var/log/mysql/mariadb-bin.index
expire_logs_days=10
max_binlog_size=100M
default_storage_engine=InnoDB
innodb_buffer_pool_size=256M
innodb_log_buffer_size=8M
innodb_file_per_table=1
innodb_open_files=400
innodb_io_capacity=400
innodb_flush_method=O_DIRECT
[mysqldump]
quick
quote-names
max_allowed_packet=16M
[mysql]
default-character-set=utf8mb4
[isamchk]
key_buffer=16M
!includedir /etc/mysql/conf.d/