The configuration method of percona5.7

This article introduces the relevant knowledge of "percona5.7 configuration method". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

[mysql@fund-mgmt-db-mog-2 ~]$ cat my3310.cnf [client]port = 3310socket = /home/mysql/my3310/run/mysql.sock[mysqld]#***********************************common parameters******************************skip-federatedskip-blackhole performance_schema=ONdefault-storage-engine=InnoDB character_set_server=utf8user=mysqlport=3310pid-file=/home/mysql/my3310/run/mysql.pidsocket=/home/mysql/my3310/run/mysql.sockdatadir=/home/mysql/my3310/datatmpdir=/home/mysql/my3310/tmpskip-name-resolve skip_external_locking report_host=10.50.61.21log_slave_updates=1log_timestamps=SYSTEMbig-tablesgroup_concat_max_len=1048576flush=OFF lower_case_table_names=1 event-scheduler=ON back_log=100read_only=1max_connections=500 max_connect_errors=99999 max_allowed_packet=64Mmax_heap_table_size=512Mtmp_table_size=256Mmax_length_for_sort_data=16kwait_timeout=172800 interactive_timeout=172800 net_buffer_length=8Kread_buffer_size=2Mread_rnd_buffer_size=8Msort_buffer_size=8Mjoin_buffer_size=16Mtable_open_cache=1024thread_cache_size=1024query_cache_type=0explicit_defaults_for_timestamptransaction-isolation=READ-COMMITTEDgtid_mode=onenforce_gtid_consistency=on#****************************** *log Specific options ****************************log-bin=/home/mysql/my3310/log/mysql-bin.indexlog-bin=/home/mysql/my3310/log/binlogbinlog_cache_size=2Mmax_binlog_size=512Mbinlog-format=ROWsync_binlog=0expire_logs_days=10server_id=61213310log_slave_updates=0log_bin_trust_function_creators=1relay-log=/home/mysql/my3310/log/relay.indexrelay-log=/home/mysql/my3310/log/relaylogmax_relay_log_size=512Mskip-slave-startreplicate_wild_ignore_table=test.% replicate_wild_ignore_table=mysql.% slave_parallel_workers = 10##corresponds to open configuration from library, Fix serveridlog-error=/home/mysql/my3310/log/alert.loglong_query_time= 1slow_query_log_file =/home/mysql/my3310/log/slow.log#log_queries_not_using_indexes#bind-address= 0.0.0#**************** MyISAM Specific options ***********************************************key_buffer_size=64Mbulk_insert_buffer_size=16Mmyisam_sort_buffer_size=64Mmyisam_max_sort_file_size=10Gmyisam_repair_threads=1#***************************** INNODB Specific options ****************************innodb_file_per_table innodb_buffer_pool_size= 40G innodb_buffer_pool_instances=16 innodb_data_home_dir=/home/mysql/my3310/datainnodb_data_file_path=ibdata1:4096M:autoextendinnodb_autoextend_increment=128innodb_thread_concurrency=0innodb_flush_log_at_trx_commit=2 innodb_fast_shutdown=1 innodb_force_recovery=0 innodb_log_buffer_size=8Minnodb_log_file_size=256Minnodb_log_files_in_group=4innodb_log_group_home_dir=/home/mysql/my3310/log/ibloginnodb_max_dirty_pages_pct=40 innodb_purge_threads=1innodb_lock_wait_timeout=120 innodb_rollback_on_timeout=1#skip-innodb_doublewriteinnodb_flush_method=O_DIRECT innodb_commit_concurrency=0 innodb_thread_concurrency=0innodb_concurrency_tickets= 1024 innodb_autoinc_lock_mode=2innodb_change_buffering=all#innodb plugininnodb_read_io_threads=16innodb_write_io_threads=16innodb_io_capacity=2000innodb_file_format_check=1innodb_strict_mode=1innodb_stats_on_metadata=0innodb_support_xa=1 sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER"show_compatibility_56=ON#plugin_load = "validate_password.so;rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so"[mysqldump]quickmax_allowed_packet=2Gdefault-character-set=utf8[mysql]no-auto-rehashprompt="\\u@\\h:\\d \\r:\\m:\\s> "default-character-set=utf8show-warnings"percona5.7 configuration method "is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!