mysql+clone_MySQL8 clone plugin

[client]

port= 5432socket= /data/mysql8017/tmp/mysql.sock

[mysql]

no-auto-rehash

default-character-set =utf8mb4

prompt=mysql(\\U[\\d])>[mysqld]

###############basic setting#################

#skip-grant-tables

sql_mode= 'TRADITIONAL'#ngram_token_size= 1basedir= /usr/local/mysql8

datadir= /data/mysql8017/var

port= 5432mysqlx_port= 54321admin_port= 54322server_id= 158socket= /data/mysql8017/tmp/mysql.sock

mysqlx_socket= /data/mysql8017/tmp/mysqlx.sock

pid-file = /data/mysql8017/var/mysql.pid

tmpdir= /data/mysql8017/tmp

default_authentication_plugin=mysql_native_password

explicit_defaults_for_timestamp= 1auto_increment_increment= 1auto_increment_offset= 1#lower_case_table_names= 1secure-file-priv = '/data/mysql8017/tmp'default-time-zone =system

character-set-server =utf8mb4

collation_server=utf8mb4_general_ci

#default_collation_for_utf8mb4=utf8mb4_general_ci

interactive_timeout= 1800wait_timeout= 1800max_connections= 2000max_allowed_packet=64M

#####skip

#skip-name-resolve

#skip-grant-tables

#skip-external-locking

#skip-networking

skip-slave-start

thread_cache_size= 768####log settings###############

expire_logs_days= 7log-bin = mysql-bin

log-bin-index = mysql-bin.index

relay-log = relay-log

relay_log_index= relay-log.index

#log-warnings = 1log_error_verbosity= 3log-error = /data/mysql8017/log/mysql.err

slow_query_log= 1

long-query-time = 1log_queries_not_using_indexes= 1log_throttle_queries_not_using_indexes= 10log_slow_admin_statements= 1log_slow_slave_statements= 1#min_examined_row_limit= 100slow_query_log_file= /data/mysql8017/log/slow.log

general_log= 0general_log_file= /data/mysql8017/log/mysql.log

max_binlog_size=1G

max_relay_log_size=1G

#####InnoDB setting###########

default_storage_engine=innodb

innodb_buffer_pool_size=4G

innodb_data_home_dir= /data/mysql8017/var

innodb_data_file_path=ibdata1:1G:autoextend

innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:10G

innodb_lru_scan_depth= 2000innodb_file_per_table= 1innodb_write_io_threads= 8innodb_read_io_threads= 8innodb_purge_threads= 8innodb_thread_concurrency= 0innodb_flush_log_at_trx_commit= 0innodb_log_buffer_size=32M

innodb_log_file_size=2G

innodb_log_files_in_group= 3innodb_log_group_home_dir= /data/mysql8017/var

innodb_flush_neighbors= 1innodb_print_all_deadlocks= 1innodb_strict_mode= 1innodb_sort_buffer_size= 67108864innodb_undo_tablespaces= 3innodb_max_dirty_pages_pct= 75innodb_flush_method=O_DIRECT

innodb_lock_wait_timeout= 5innodb_open_files= 65535innodb_use_native_aio=on

innodb_buffer_pool_dump_pct= 40innodb_page_cleaners= 4innodb_undo_log_truncate= 1innodb_purge_rseg_truncate_frequency= 128binlog_gtid_simple_recovery= 1innodb_io_capacity= 2000innodb_io_capacity_max= 3000log_timestamps=system

###replication settings###########

master_info_repository=table

relay_log_info_repository=table

binlog_format=row

sync_binlog= 0transaction_isolation= READ-COMMITTED

log_slave_updates=on

relay_log_recovery= 1#forgtid

gtid_mode=on

enforce_gtid_consistency=on

binlog_gtid_simple_recovery= 1#####MyISAM setting##########

key_buffer_size=128M

read_buffer_size=8M

read_rnd_buffer_size=8M

join_buffer_size=8M

bulk_insert_buffer_size=64M

sort_buffer_size=8M

myisam_sort_buffer_size=1G

myisam_max_sort_file_size=10G

myisam_repair_threads= 1table_open_cache= 4096[mysqldump]

quick

max_allowed_packet=64M

[myisamchk]

key_buffer_size=64M

sort_buffer_size=16M

read_buffer_size=64M

write_buffer_size=64M

[mysqlhotcopy]

interactive-timeout