专职DBA-MySQL配置文件my.cnf参数设置
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了专职DBA-MySQL配置文件my.cnf参数设置，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含13135字，纯文字阅读大概需要19分钟。
内容图文
专职DBA-MySQL配置文件my.cnf参数设置
[mysql] port = 3306 character-set-client = utf8 #utf8mb4 auto-rehash prompt = "\\u@\\h [\\d]>" #prompt = "MySQL [\\d]> \" #prompt = "Master [\\d]> \" #prompt = "Slave [\\d]> \" #pager = "less -i -n -S" #tee = /opt/mysql/query.log [mysqld] # for mysql global user = mysql # mysql basedir = /usr/local/mysql # /usr/local/mysql datadir = /data/mysql/3306/data # /usr/local/mysql/data tmpdir = /data/mysql/3306/tmp # pid_file = /data/mysql/3306/3306.pid # socket = /data/mysql/3306/mysql.sock # /tmp/mysql.sock port = 3306 # 3306 server_id = 113306 # 0 character_set_server = utf8 # latin1 #utf8mb4 explicit_defaults_for_timestamp = off # off log_timestamps = system # default_time_zone = '+8:00' # utc read_only = on # off super_read_only = on # skip_name_resolve = off # 0 auto_increment_increment = 1 # 1 auto_increment_offset = 1 # 1 lower_case_table_names = 1 # 0 secure_file_priv = /tmp # null open_files_limit = 65536 # 1024 max_connections = 1000 # 151 thread_cache_size = 64 # 9 table_open_cache = 81920 # 2000 table_definition_cache = 4096 # 1400 table_open_cache_instances = 64 # 16 max_prepared_stmt_count = 1048576 # # for binlog binlog_format = row # row log_bin = /data/mysql/3306/logs/mysql-bin # off binlog_rows_query_log_events = on # off log_slave_updates = on # off # MHA,PXC,MGR expire_logs_days = 7 # 0 binlog_cache_size = 65536 # 65536(64k) #binlog_checksum = none # CRC32 sync_binlog = 1 # 1 slave-preserve-commit-order = on # # for error log log_error = /data/mysql/3306/error.log # /usr/local/mysql/data/localhost.localdomain.err # general log general_log = off # off general_log_file = /data/mysql/3306/general.log # hostname.log # for slow query log slow_query_log = on # off slow_query_log_file = /data/mysql/3306/slow.log # hostname.log #log_queries_not_using_indexes = on # off long_query_time = 1.000000 # 10.000000 # for gtid #gtid_executed_compression_period = 1000 # 1000 gtid_mode = on # off enforce_gtid_consistency = on # off # for replication skip_slave_start = 1 # #master_info_repository = table # file #relay_log_info_repository = table # file slave_parallel_type = logical_clock # database|LOGICAL_CLOCK slave_parallel_workers = 4 # 0 #rpl_semi_sync_master_enabled = 1 # 0 #rpl_semi_sync_slave_enabled = 1 # 0 #rpl_semi_sync_master_timeout = 1000 # 1000(1 second) #plugin_load_add = semisync_master.so # #plugin_load_add = semisync_slave.so # binlog_group_commit_sync_delay = 100 # 500(0.05%秒) 默认值0 binlog_group_commit_sync_no_delay_count = 10 # 0 # for innodb innodb_data_file_path = ibdata1:100M:autoextend # ibdata1:12M:autoextend innodb_temp_data_file_path = ibtmp1:12M:autoextend # ibtmp1:12M:autoextend innodb_buffer_pool_filename = ib_buffer_pool # ib_buffer_pool innodb_log_files_in_group = 3 # 2 innodb_log_file_size = 100M # 50331648(48M) innodb_file_per_table = on # on innodb_online_alter_log_max_size = 128M # 134217728(128M) innodb_open_files = 65535 # 2000 innodb_page_size = 16k # 16384(16k) innodb_thread_concurrency = 0 # 0 innodb_read_io_threads = 4 # 4 innodb_write_io_threads = 4 # 4 innodb_purge_threads = 4 # 4(垃圾回收) innodb_page_cleaners = 4 # 4(刷新lru脏页) innodb_print_all_deadlocks = on # off innodb_deadlock_detect = on # on innodb_lock_wait_timeout = 20 # 50 innodb_spin_wait_delay = 128 # 6 innodb_autoinc_lock_mode = 2 # 1 innodb_io_capacity = 200 # 200 innodb_io_capacity_max = 2000 # 2000 # Persistent Optimizer Statistics innodb_stats_auto_recalc = on # on innodb_stats_persistent = on # on innodb_stats_persistent_sample_pages = 20 # 20 innodb_change_buffer_max_size = 25 # 25 innodb_flush_neighbors = 1 # 1 #innodb_flush_method = # innodb_doublewrite = on # on innodb_log_buffer_size = 128M # 16777216(16M) innodb_flush_log_at_timeout = 1 # 1 innodb_flush_log_at_trx_commit = 1 # 1 innodb_buffer_pool_size =100M # 134217728(128M) innodb_buffer_pool_instances = 4 # # innodb scan resistant innodb_old_blocks_pct = 37 # 37 innodb_old_blocks_time = 1000 # 1000 # innodb read ahead innodb_read_ahead_threshold = 56 # 56 (0..64) innodb_random_read_ahead = off # off # innodb buffer pool state innodb_buffer_pool_dump_pct = 25 # 25 innodb_buffer_pool_dump_at_shutdown = on # on innodb_buffer_pool_load_at_startup = on # on innodb_flush_method = O_DIRECT # # Percona XtraDB Cluster #default_storage_engine = InnoDB #innodb_locks_unsafe_for_binlog = 1 #innodb_autoinc_lock_mode = 2 #wsrep_cluster_name = pxc_mysql #cluster的名字 #wsrep_cluster_address = gcomm://10.0.0.11,10.0.0.12,10.0.0.13 #cluster中的节点ip #wsrep_node_address = 10.0.0.11 #cluster当前节点的ip，每个节点当前节点ip不能一样 #wsrep_provider = /usr/local/mysql/lib/libgalera_smm.so #wsrep_sst_method = xtrabackup-v2 #wsrep_sst_auth = sst:123 # MySQL Group Replication #master_info_repository = table #relay_log_info_repository = table #binlog_checksum = none #log_slave_updates = on #transaction_write_set_extraction = XXHASH64 #loose-group_replication_group_name = "3ff8dc74-e421-43eb-add3-abf2671886c5" #loose-group_replication_start_on_boot = off #loose-group_replication_local_address = "10.0.0.11:33061" #loose-group_replication_group_seeds = "10.0.0.11:33061,10.0.0.12:33061,10.0.0.13:33061" #loose-group_replication_bootstrap_group = off # MGR multi-master loose-group_replication_single_primary_mode = off loose-group_replication_enforce_update_everywhere_checks = on
内容总结
以上是互联网集市为您收集整理的专职DBA-MySQL配置文件my.cnf参数设置全部内容，希望文章能够帮你解决专职DBA-MySQL配置文件my.cnf参数设置所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源：【匿名】