{"id":1235,"date":"2020-05-18T06:22:17","date_gmt":"2020-05-17T22:22:17","guid":{"rendered":"http:\/\/39.97.231.10\/?p=1235"},"modified":"2020-05-18T06:22:17","modified_gmt":"2020-05-17T22:22:17","slug":"mysql%e9%85%8d%e7%bd%ae%e6%96%87%e4%bb%b6my-cnf%e5%8f%82%e6%95%b0%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=1235","title":{"rendered":"MySQL\u914d\u7f6e\u6587\u4ef6my.cnf\u53c2\u6570\u914d\u7f6e"},"content":{"rendered":"

MySQL\u6570\u636e\u5e93\u4f18\u5316\u914d\u7f6e\u6587\u4ef6my.cnf\u53c2\u6570\u4f18\u5316\u53c2\u8003\uff1a<\/p>\n

[client]\ndefault-character-set=utf8\nloose-local-infile=1\n#load data local infile\u6570\u636e\u52a0\u8f7d\u914d\u7f6e\n[mysqld]\n########basic\u00a0settings########\u00a0\nport = 3306\nautocommit = 0\n#commit\u63d0\u4ea4\ncharacter_set_server=utf8\nlower_case_table_names=1\n#MySQL\u5ffd\u7565\u5927\u5c0f\u5199\u542f\u7528\nevent_scheduler=ON\n#\u5f00\u542f\u4efb\u52a1\u8ba1\u5212\nskip_name_resolve\u00a0=\u00a01\n#\u7981\u7528dns\u89e3\u6790\nmax_connections\u00a0=\u00a016384\n#MySQL\u670d\u52a1\u5668\u5141\u8bb8\u7684\u6700\u5927\u8fde\u63a5\u657016384\nmax_connect_errors\u00a0=\u00a01000\n#\u8bbe\u7f6e\u9519\u8bef\u8fde\u63a5\u6570\uff0c\u963b\u6b62\u8fc7\u591a\u5c1d\u8bd5\u5931\u8d25\u7684\u5ba2\u6237\u7aef\ndatadir\u00a0=\u00a0\/usr\/local\/mysql\/data\ntransaction_isolation\u00a0=\u00a0READ-COMMITTED\n#\u8bbe\u7f6e\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\uff0c\u8bfb\u53d6\u63d0\u4ea4\u5185\u5bb9\nexplicit_defaults_for_timestamp\u00a0=\u00a01\n#timestamp\u5217\u5982\u679c\u6ca1\u6709\u663e\u5f0f\u5b9a\u4e49\u4e3anot null\uff0c\u5219\u652f\u6301null\u5c5e\u6027\njoin_buffer_size\u00a0=\u00a0134217728\n#\u8054\u5408\u67e5\u8be2\u64cd\u4f5c\u6240\u80fd\u4f7f\u7528\u7684\u7f13\u51b2\u533a\u5927\u5c0f128M\ntmp_table_size\u00a0=\u00a0268435456\n#\u8bbe\u7f6e\u5185\u5b58\u4e2d\u4e34\u65f6\u8868\u4e3a256M\ntmpdir\u00a0=\u00a0\/tmp\nmax_allowed_packet\u00a0=\u00a0\u00a0268435456\n#\u63a5\u6536\u7684\u6570\u636e\u5305256M\ninteractive_timeout\u00a0=\u00a01800\n#\u670d\u52a1\u5668\u5173\u95ed\u4ea4\u4e92\u5f0f\u8fde\u63a5\u524d\u7b49\u5f85\u6d3b\u52a8\u7684\u79d2\u6570\nwait_timeout\u00a0=\u00a01800\n#\u7b49\u5f85\u8fde\u63a5\u8d85\u65f6\u65f6\u95f4\nread_buffer_size\u00a0=\u00a016777216\n#MySql\u8bfb\u5165\u7f13\u51b2\u533a\u5927\u5c0f16M\nread_rnd_buffer_size\u00a0=\u00a033554432\n#MySql\u7684\u968f\u673a\u8bfb\u7f13\u51b2\u533a\u5927\u5c0f32M\nsort_buffer_size\u00a0=\u00a033554432\n#MySql\u6267\u884c\u6392\u5e8f\u4f7f\u7528\u7684\u7f13\u51b2\u5927\u5c0f32M\n########log\u00a0settings########\nlog_error = error.log\nslow_query_log = 1\nslow_query_log_file = slow.log\nlong_query_time = 5\n#\u8d85\u8fc75\u79d2\u7684SQL\u4f1a\u8bb0\u5f55\u4e0b\u6765\n#########print not use index#######\nlog_queries_not_using_indexes = 1\nlog_slow_admin_statements = 1\nlog_slow_slave_statements = 1\nlog_throttle_queries_not_using_indexes = 10\nmin_examined_row_limit = 100\n#\u67e5\u8be2\u68c0\u67e5\u8fd4\u56de\u5c11\u4e8e\u8be5\u53c2\u6570\u6307\u5b9a\u884c\u7684SQL\u4e0d\u88ab\u8bb0\u5f55\u5230\u6162\u67e5\u8be2\u65e5\u5fd7\n########replication\u00a0settings########\nlog-bin=mysql-bin\nbinlog-format=row\nserver_id=1\n#\u914d\u7f6emysql replaction\u9700\u8981\u5b9a\u4e49\uff0c\u4e0d\u80fd\u548c\u5176\u4ed6\u8282\u70b9\u91cd\u590d\nbinlog_annotate_row_events=true\n#\u5f00\u542f\u8bb0\u5f55annotate\u4e8b\u4ef6\nmaster_info_repository\u00a0=\u00a0TABLE\nrelay_log_info_repository\u00a0=\u00a0TABLE\nlog_bin\u00a0=\u00a0bin.log\nsync_binlog\u00a0=\u00a01\n#\u6bcf\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u65f6\u5019\uff0c\u628a\u4e8b\u52a1\u65e5\u5fd7\u4ece\u7f13\u5b58\u533a\u5199\u5230\u65e5\u5fd7\u6587\u4ef6\u4e2d\uff0c\u5e76\u4e14\u5237\u65b0\u65e5\u5fd7\u6587\u4ef6\u7684\u6570\u636e\u5230\u78c1\u76d8\u4e0a\nrelay_log\u00a0=\u00a0relay.log\nrelay_log_recovery\u00a0=\u00a01\nbinlog_gtid_simple_recovery\u00a0=\u00a01\nslave_skip_errors\u00a0=\u00a0ddl_exist_errors\n#\u5ffd\u7565\u6240\u6709\u7c7b\u578b\u4e3addl_exist_errors\u7684\u9519\u8bef\n########innodb\u00a0settings########\ninnodb_page_size\u00a0=\u00a08192\n#\u8bbe\u7f6e\u6570\u636e\u98758k\ninnodb_buffer_pool_size\u00a0=\u00a010G\n#\u7f13\u5b58\u7528\u6237\u8868\u53ca\u7d22\u5f15\u6570\u636e\u7a7a\u95f410G\ninnodb_buffer_pool_instances\u00a0=\u00a08\n#\u5f00\u542f\u591a\u4e2a\u5185\u5b58\u7f13\u51b2\u6c60\ninnodb_buffer_pool_load_at_startup\u00a0=\u00a01\n#\u5728\u542f\u52a8\u65f6\u5c06\u672c\u5730\u70ed\u6570\u636e\u52a0\u8f7d\u5230InnoDB\u7f13\u51b2\u6c60\u4e2d\ninnodb_buffer_pool_dump_at_shutdown\u00a0=\u00a01\n#\u5728\u5173\u95ed\u65f6\u628a\u70ed\u6570\u636edump\u5230\u672c\u5730\u78c1\u76d8\u4e2d\ninnodb_lru_scan_depth\u00a0=\u00a02000\n#\u63a7\u5236LRU\u6700\u5c11\u4f7f\u7528\u94fe\u8868\u5c3e\u90e8\u904d\u5386\u7684\u957f\u5ea6\ninnodb_lock_wait_timeout\u00a0=\u00a05\n\u9501\u7b49\u5f85\u8d85\u65f6\u65f6\u95f4\ninnodb_io_capacity\u00a0=\u00a04000\n#\u5237\u65b0\u7684\u810f\u9875\u7684\u6570\u91cf\ninnodb_io_capacity_max\u00a0=\u00a08000\n#\u8bbe\u7f6e\u4f1a\u5f71\u54cdInnoDB\u6bcf\u79d2\u5728\u540e\u53f0\u6267\u884c\u6b21\u6570\ninnodb_flush_method\u00a0=\u00a0O_DIRECT\n#InnoDB\u4f7f\u7528O_DIRECT\u6a21\u5f0f\u6253\u5f00\u6570\u636e\u6587\u4ef6\uff0c\u7528fsync()\u51fd\u6570\u53bb\u66f4\u65b0\u65e5\u5fd7\u548c\u6570\u636e\u6587\u4ef6\u3002\ninnodb_file_format\u00a0=\u00a0Barracuda\ninnodb_file_format_max\u00a0=\u00a0Barracuda\n#innodb\u8868\u7a7a\u95f4\u6587\u4ef6\u5b58\u50a8\u538b\u7f29\u683c\u5f0fBarracuda\ninnodb_undo_logs\u00a0=\u00a0128\n#\u63a7\u5236\u7528\u5230\u7684\u56de\u6eda\u6bb5\u7684\u4e2a\u6570\ninnodb_undo_tablespaces\u00a0=\u00a03\n#\u8bbe\u5b9a\u521b\u5efa\u7684undo\u8868\u7a7a\u95f4\u7684\u4e2a\u6570\ninnodb_flush_neighbors\u00a0=\u00a01\n#innodb\u7684\u5185\u90e8\u903b\u8f91\u4e5f\u4f1a\u628a\u591a\u4e2apage\u5408\u5e76\u6210\u4e00\u6b21IO\u8fdb\u884c\u63d0\u4ea4\u5237\u5199\u6027\u80fd\u66f4\u9ad8\ninnodb_log_file_size\u00a0=\u00a04G\n#\u65e5\u5fd7\u6587\u4ef6\u5927\u5c0f\ninnodb_log_buffer_size\u00a0=\u00a016777216\n#innodb\u7f13\u5b58\u5927\u5c0f\ninnodb_purge_threads\u00a0=\u00a04\n#\u5f00\u542f\u6e05\u5199\u7ebf\u7a0b\ninnodb_large_prefix\u00a0=\u00a01\n#\u5141\u8bb8\u5217\u7d22\u5f15\u6700\u5927\u8fbe\u52303072\ninnodb_thread_concurrency\u00a0=\u00a064\n#\u9650\u5236\u5e76\u53d1\u7ebf\u7a0b\u7684\u6570\u91cf\ninnodb_print_all_deadlocks\u00a0=\u00a01\n#\u628a\u6b7b\u9501\u4fe1\u606f\u6253\u5370\u5230\u9519\u8bef\u65e5\u5fd7\u91cc\ninnodb_strict_mode\u00a0=\u00a01\ninnodb_sort_buffer_size\u00a0=\u00a067108864\n#innodb\u6392\u5e8f\u7f13\u5b58\u5927\u5c0f\n#########################################<\/pre>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL\u6570\u636e\u5e93\u4f18\u5316\u914d\u7f6e\u6587\u4ef6my.cnf\u53c2\u6570\u4f18\u5316\u53c2\u8003\uff1a [client] default-character- …<\/p>\n
  MySQL\u914d\u7f6e\u6587\u4ef6my.cnf\u53c2\u6570\u914d\u7f6e<\/span> \u67e5\u770b\u5168\u6587 »<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[90],"tags":[],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false,"mailpoet_newsletter_max":false,"woocommerce_thumbnail":false,"woocommerce_single":false,"woocommerce_gallery_thumbnail":false,"shop_catalog":false,"shop_single":false,"shop_thumbnail":false},"uagb_author_info":{"display_name":"weijing","author_link":"http:\/\/www.weijing.co\/?author=4"},"uagb_comment_info":1,"uagb_excerpt":"MySQL\u6570\u636e\u5e93\u4f18\u5316\u914d\u7f6e\u6587\u4ef6my.cnf\u53c2\u6570\u4f18\u5316\u53c2\u8003\uff1a [client] default-character-…","_links":{"self":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1235"}],"collection":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1235"}],"version-history":[{"count":0,"href":"http:\/\/www.weijing.co\/index.php?rest_route=\/wp\/v2\/posts\/1235\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1235"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.weijing.co\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}