MySQL 5.7 my.cnfプロファイルの説明
5790 ワード
: 5.7.18 my-default.cnf 。 :https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
, 5.7.18 , tar.gz , , my.cnf 。
my.cnf MySQL cnf , 。
my.cnf , , ,MySQL ( deb APT , ):
Unix Unix
/etc/my.cnf
/etc/mysql/my.cnf
SYSCONFDIR/my.cnf
$MYSQL_HOME/my.cnf ( )
defaults-extra-file --defaults-extra-file( )
~/.my.cnf
~/.mylogin.cnf ( )
,~ ( $HOME)。
/etc/my.cnf , , /etc/mysql/my.cnf ,
:
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html?spm=5176.7920929.0.0.42e941d6WvwfAQ#sysvar_block_encryption_modehttps://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#ngram_token_sizehttps://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#innodb_monitor_enablehttps://github.com/xpchild/SQL/wiki/Changes-in-AliSQL-5.6.32-(2016-09-15)#10-sql-filter
, APT deb , ( tar.gz) , my.cnf MySQL 。
5.7.18 , my-default.cnf, 5.7.17 , ,my-default.cnf :
# For advice on how to change settings please see
#
# *** DO NOT EDIT THIS FILE. It‘s a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
, ,
Mysql , , , , , , , , , , , , 。
my.cnf :
*******************************************************
[client]
default-character-set = utf8mb4
[mysql]
# tab
#auto-rehash
default-character-set = utf8mb4
[mysqld]
port=3306
basedir=/data/server/mysql57/
datadir=/data/server/mysql57/data/
socket=/data/server/mysql57/data/mysql.sock
symbolic-links=0
log-error=/data/logs/mysql57/mysqld.log
pid-file=/data/server/mysql57/data/mysqld57.pid
#
skip-name-resolve
#
default-storage-engine = InnoDB
innodb-file-per-table=1innodb_force_recovery = 1#
group_concat_max_len = 10240sql_mode=expire_logs_days = 7memlock
###
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'### GTID
server_id = 330759# GTID ,
binlog_format = row
# gtid
gtid_mode = on
# GTID
# enforce_gtid_consistency ,
# MySQL , SQL ,
# create table ... select create temporarytable ,
# SQL
enforce-gtid-consistency = true# ,
# binlog
log_bin = mysql57-bin
# binlog
log-slave-updates = on
#slave mysql
skip_slave_start=1###
#
slow_query_log = 1# 2
long_query_time = 2#
log_queries_not_using_indexes = 0slow_query_log_file =/data/logs/mysql57/slow.log
#log=/data/logs/mysql57/all.log
###
# relay.info
relay_log_info_repository = TABLE
# master.info
master_info_repository = TABLE
# relaylog
relay_log_recovery = on
# SQL relaylog
relay_log_purge = 1###
# wei master function
log_bin_trust_function_creators = on
#
sync_binlog = 1# timestamp not null, null
# timestamp null, current timestamp
explicit_defaults_for_timestamp=true###
#
ft_min_word_len = 1# ,
lower_case_table_names = 1#
# ( )
max_allowed_packet = 256M
#
#rpl_semi_sync_master_enabled = 1#rpl_semi_sync_slave_enabled = 1#
#rpl_semi_sync_master_timeout = 1000# ( )
#rpl_semi_sync_master_wait_point = AFTER_SYNC
# relaylog
#rpl_semi_sync_master_wait_slave_count = 1#
#
slave_parallel_type = logical_clock
# SQL , 1
転載先:https://blog.51cto.com/moerjinrong/2092791