percona5.7的配置方法

本篇内容介绍了"percona5.7的配置方法"的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

[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## 对应从库打开配置，修改serveridlog-error=/home/mysql/my3310/log/alert.loglong_query_time=1slow_query_logslow_query_log_file=/home/mysql/my3310/log/slow.log#log_queries_not_using_indexes#bind-address=0.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的配置方法"的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注网站，小编将为大家输出更多高质量的实用文章！