mysql 备份配置文件_【Mysql】备份一个mysql my.cnf配置文件

[client]

port    = 3306

socket  = /data/3306/mysql.sock

default-character-set=utf8mb4

[mysql]

no-auto-rehash

default-character-set=utf8mb4

[mysqld]

init-connect='SET NAMES utf8mb4'

character-set-server = utf8mb4

skip-character-set-client-handshake

lower_case_table_names = 1

federated

secure_file_priv=''

server-id=139

port    = 3306

socket  = /data/3306/mysql.sock

basedir = /usr/local/mysql

datadir = /data/3306/data

transaction_isolation = REPEATABLE-READ

log-error = /data/3306/error.log

slow_query_log_file=/data/3306/slow-log.log

slow_query_log = 1

pid-file = /data/3306/mysql.pid

log-bin = /data/3306/binlog/mysql-bin

binlog_format=ROW

slave-skip-errors = 1032,1062

skip-external-locking

skip-name-resolve

default-storage-engine = INNODB

wait_timeout=200

connect_timeout = 20

interactive_timeout=200

back_log = 500

event_scheduler = ON   --开启event事件支持

long_query_time = 1

max_binlog_size = 256M

binlog_cache_size = 8M

expire_logs_days = 7

relay_log_purge = 0      ----relay lof 自动清除关闭，开启后可通过flush logs手动清除

relay_log_recovery = 1

skip-slave-start = 1

log_slave_updates = 1

max_connections = 3000

table_open_cache = 6144

table_definition_cache = 4096

sort_buffer_size = 512K

read_buffer_size = 512K

read_rnd_buffer_size = 512K

tmp_table_size = 64M    --内存临时表的最大值

max_heap_table_size = 64M

bulk_insert_buffer_size = 32M   -- 批量插入暂存使用内存

thread_cache_size = 8M

thread_stack = 256K

max_allowed_packet = 500M

join_buffer_size = 4M

innodb_buffer_pool_size = 20G

innodb_buffer_pool_instances = 4

innodb_additional_mem_pool_size = 16M

innodb_log_file_size = 1024M

innodb_log_buffer_size = 64M

innodb_log_files_in_group = 3

innodb_flush_log_at_trx_commit = 1

innodb_sync_spin_loops = 40    --上下文切换自旋锁

innodb_max_dirty_pages_pct = 90

innodb_support_xa = 1

innodb_thread_concurrency = 0

innodb_thread_sleep_delay = 500

innodb_file_io_threads = 4

innodb_lock_wait_timeout = 200

innodb_concurrency_tickets = 1000

log_bin_trust_function_creators = 1

innodb_flush_method = O_DIRECT

innodb_file_per_table = 1

innodb_read_io_threads = 8

innodb_write_io_threads = 8

innodb_io_capacity = 1500

innodb_file_format = Barracuda

innodb_purge_threads = 4

innodb_purge_batch_size = 32

innodb_old_blocks_pct=75

innodb_change_buffering = all

group_concat_max_len=102400

loose_max_statement_time=600000

innodb_print_all_deadlocks = 1

[mysqldump]

quick

max_allowed_packet = 500M

[mysqld_safe]

log-error=/data/3306/mysql.err

pid-file=/data/3306/mysqld.pid