本篇內(nèi)容介紹了“percona5.7的配置方法”的有關(guān)知識(shí)，在實(shí)際案例的操作過(guò)程中，不少人都會(huì)遇到這樣的困境，接下來(lái)就讓小編帶領(lǐng)大家學(xué)習(xí)一下如何處理這些情況吧！希望大家仔細(xì)閱讀，能夠?qū)W有所成！
[mysql@fund-mgmt-db-mog-2 ~]$ cat my3310.cnf [client] port = 3310 socket = /home/mysql/my3310/run/mysql.sock [mysqld] #***********************************common parameters****************************** skip-federated skip-blackhole performance_schema=ON default-storage-engine=InnoDB character_set_server=utf8 user=mysql port=3310 pid-file=/home/mysql/my3310/run/mysql.pid socket=/home/mysql/my3310/run/mysql.sock datadir=/home/mysql/my3310/data tmpdir=/home/mysql/my3310/tmp skip-name-resolve skip_external_locking report_host=10.50.61.21 log_slave_updates=1 log_timestamps=SYSTEM big-tables group_concat_max_len=1048576 flush=OFF lower_case_table_names=1 event-scheduler=ON back_log=100 read_only=1 max_connections=500 max_connect_errors=99999 max_allowed_packet=64M max_heap_table_size=512M tmp_table_size=256M max_length_for_sort_data=16k wait_timeout=172800 interactive_timeout=172800 net_buffer_length=8K read_buffer_size=2M read_rnd_buffer_size=8M sort_buffer_size=8M join_buffer_size=16M table_open_cache=1024 thread_cache_size=1024 query_cache_type=0 explicit_defaults_for_timestamp transaction-isolation=READ-COMMITTED gtid_mode=on enforce_gtid_consistency=on #****************************** *log Specific options **************************** log-bin=/home/mysql/my3310/log/mysql-bin.index log-bin=/home/mysql/my3310/log/binlog binlog_cache_size=2M max_binlog_size=512M binlog-format=ROW sync_binlog=0 expire_logs_days=10 server_id=61213310 log_slave_updates=0 log_bin_trust_function_creators=1 relay-log=/home/mysql/my3310/log/relay.index relay-log=/home/mysql/my3310/log/relaylog max_relay_log_size=512M skip-slave-start replicate_wild_ignore_table=test.% replicate_wild_ignore_table=mysql.% slave_parallel_workers = 10 ## 對(duì)應(yīng)從庫(kù)打開(kāi)配置，修改serverid log-error=/home/mysql/my3310/log/alert.log long_query_time=1 slow_query_log slow_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=64M bulk_insert_buffer_size=16M myisam_sort_buffer_size=64M myisam_max_sort_file_size=10G myisam_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/data innodb_data_file_path=ibdata1:4096M:autoextend innodb_autoextend_increment=128 innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=2 innodb_fast_shutdown=1 innodb_force_recovery=0 innodb_log_buffer_size=8M innodb_log_file_size=256M innodb_log_files_in_group=4 innodb_log_group_home_dir=/home/mysql/my3310/log/iblog innodb_max_dirty_pages_pct=40 innodb_purge_threads=1 innodb_lock_wait_timeout=120 innodb_rollback_on_timeout=1 #skip-innodb_doublewrite innodb_flush_method=O_DIRECT innodb_commit_concurrency=0 innodb_thread_concurrency=0 innodb_concurrency_tickets=1024 innodb_autoinc_lock_mode=2 innodb_change_buffering=all #innodb plugin innodb_read_io_threads=16 innodb_write_io_threads=16 innodb_io_capacity=2000 innodb_file_format_check=1 innodb_strict_mode=1 innodb_stats_on_metadata=0 innodb_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] quick max_allowed_packet=2G default-character-set=utf8 [mysql] no-auto-rehash prompt="\\u@\\h:\\d \\r:\\m:\\s> " default-character-set=utf8 show-warnings
“percona5.7的配置方法”的內(nèi)容就介紹到這里了，感謝大家的閱讀。如果想了解更多行業(yè)相關(guān)的知識(shí)可以關(guān)注創(chuàng)新互聯(lián)-成都網(wǎng)站建設(shè)公司網(wǎng)站，小編將為大家輸出更多高質(zhì)量的實(shí)用文章！
重慶分公司
重慶分公司
