#When this variable is enabled, InnoDB updates statistics during metadata statements such as SHOW TABLE STATUS or SHOW INDEX, or when accessing the INFORMATION_SCHEMA tables TABLES or STATISTICS. (These updates are similar to what happens for ANALYZE TABLE.) When disabled, InnoDB does not update statistics during these operations. Leaving this setting disabled can improve access speed for schemas that have a large number of tables or indexes. It can also improve the stability of execution plans for queries that involve InnoDB tables.
innodb_stats_on_metadata=OFF
the commands: innobackupex --apply-log --use-memory=20G ${backup_file_dir} >${backup_ file_dir} /apply. log 2>&1 \\u@\\d\ \r:\\m: \\s>
innobackupex version 2.4.7 Linux (x86_64) (revision id: 05f1fcf)
my.cnf :
[mysql]
port=*
prompt=
no-auto-rehash
[client]
port=*
socket=*/mysql.sock
[mysqld] log_file= */mysql. slow log_file= */mysql. genlog */mysql. pid
#dir
basedir=/usr
datadir=*
tmpdir=*
log-error=mysql.err
slow_query_
general_
socket=*/mysql.sock
pid-file=
#innodb file_format= Barracuda data_home_ dir=* log_group_ home_dir= * data_file_ path=ibdata1: 100M:autoextend buffer_ pool_size= 100G buffer_ pool_instances= 4 log_files_ in_group= 3 log_file_ size=1G log_buffer_ size=8M flush_log_ at_trx_ commit= 2 max_dirty_ pages_pct= 70 io_capacity= 400 thread_ concurrency= 0 read_io_ threads= 4 write_io_ threads= 16 open_files= 60000 file_per_ table=1 flush_method= O_DIRECT change_ buffering= all adaptive_ flushing= 1 old_blocks_ time=1000 use_native_ aio=1 lock_wait_ timeout= 120 timeout= 60 rollback_ on_timeout= 0 buffer_ pool_dump_ at_shutdown= ON buffer_ pool_load_ at_startup= ON table_size= 128M
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
lock_wait_
innodb_
innodb_
innodb_
max_heap_
#myisam sort_buffer_ size=128M insert= ALWAYS insert_ timeout= 300 buffer_ size=128K recover- options= default
key_buffer_size=32M
myisam_
concurrent_
delayed_
read_rnd_
myisam-
#replication
skip-slave-start
relay-log=relay
slave_load_tmpdir=*
#binlog host=10. 32.120. 7 cache_size= 1M cache_size= 2G size=1024M rows_query_ log_events= ON
log-bin=mysql-bin
server_id=32120007
report_
report_port=5002
binlog_
max_binlog_
max_binlog_
binlog-format=row
#sync_binlog=1
log-slave-updates
read_only=ON
expire_logs_days=7
max_binlog_files=0
binlog_
#server storage- engine= INNODB set-server= utf8mb4 server= utf8mb4_ unicode_ ci set_client= utf8mb4 limit=140000 admin_statement s=1 verbosity= microtime, query_plan, innodb not_using_ indexes= 1 time=0. 100000 slave_statement s=1 size=256M limit=1M min_res_ unit=1K n_cache= 65536 cache=65536 cache_size= 256 size=128K =2000 errors= 65536 packet= 16M timeout= 60 timeout= 90
default-
character-
collation_
character_
open_files_
log_slow_
log_slow_
log_warnings=2
#log_queries_
long_query_
slow_query_log=1
log_slow_
query_cache_type=0
query_cache_
query_cache_
query_cache_
table_definitio
table_open_
thread_stack=512K
thread_
sort_buffer_size=8M
join_buffer_size=8M
read_buffer_
port=5002
skip-name-resolve
skip-ssl
max_connections
max_connect_
max_allowed_
connect_timeout=8
net_read_timeout=30
net_write_
slave_net_
back_log=1024
#When this variable is enabled, InnoDB updates statistics during metadata statements such as SHOW TABLE STATUS or SHOW INDEX, or when accessing the INFORMATION_SCHEMA tables TABLES or STATISTICS. (These updates are similar to what happens for ANALYZE TABLE.) When disabled, InnoDB does not update statistics during these operations. Leaving this setting disabled can improve access speed for schemas that have a large number of tables or indexes. It can also improve the stability of execution plans for queries that involve InnoDB tables. stats_on_ metadata= OFF
innodb_
#because bug https:/ /bugs.launchpad .net/percona- server/ +bug/1199213, default is 1 adaptive_ hash_index_ partitions= 1
innodb_
#suppress warning suppress= 1592
log_warnings_
#on have performance problem. schema= OFF t_step= OFF gtid-consistenc y=ON
performance_
#gtid
#gtid_mode=ON
#gtid_deploymen
#enforce-
#replicate recovery= 1 info_repository =TABLE info_repository =TABLE d_protocol= ON
relay_log_
relay_log_
master_
slave_compresse
#userstat
userstat=ON
#audit log setting log_policy= LOGINS
#audit_