{"id":444,"date":"2015-01-16T15:52:50","date_gmt":"2015-01-16T07:52:50","guid":{"rendered":"http:\/\/elon.852128.com\/blog\/?p=444"},"modified":"2015-01-16T15:52:50","modified_gmt":"2015-01-16T07:52:50","slug":"mysql%e4%bc%98%e5%8c%96my-cnf%e7%bc%93%e5%ad%98","status":"publish","type":"post","link":"https:\/\/elon.852128.com\/blog\/2015\/01\/16\/mysql%e4%bc%98%e5%8c%96my-cnf%e7%bc%93%e5%ad%98\/","title":{"rendered":"MySQL\u4f18\u5316my.cnf\u7f13\u5b58"},"content":{"rendered":"<p><script src=\"http:\/\/www.google-analytics.com\/ga.js\" async=\"\" type=\"text\/javascript\"><\/script><script src=\"http:\/\/csdnimg.cn\/pubfooter\/js\/tracking.js\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><script type=\"text\/javascript\">\/\/ <![CDATA[\n        var protocol = window.location.protocol;\n        document.write('<script type=\"text\/javascript\" src=\"' + protocol + '\/\/csdnimg.cn\/pubfooter\/js\/repoAddr2.js?v=' + Math.random() + '\"><\/' + 'script>');\n    \n\/\/ ]]><\/script><script src=\"http:\/\/csdnimg.cn\/pubfooter\/js\/repoAddr2.js?v=0.15900243918533025\" type=\"text\/javascript\"><\/script><script id=\"allmobilize\" src=\"http:\/\/a.yunshipei.com\/46aae4d1e2371e4aa769798941cef698\/allmobilize.min.js\" charset=\"utf-8\"><\/script>MySQL\u4f18\u5316\u6b65\u9aa4\u53camy.cnf\u7f13\u5b58\u4f18\u5316 &#8211; \u4f3c\u6c34\u6d41\u5e74 &#8212; \u97e9\u6b23\u7684\u535a\u5ba2 &#8211; \u535a\u5ba2\u9891\u9053 &#8211; CSDN.NET<script src=\"http:\/\/static.blog.csdn.net\/scripts\/jquery.js\" type=\"text\/javascript\"><\/script><script src=\"http:\/\/static.blog.csdn.net\/scripts\/ad.js?v=1.1\" type=\"text\/javascript\"><\/script><!--new top--> <!--new top--><script src=\"http:\/\/bdimg.share.baidu.com\/static\/api\/js\/share.js?v=89860593.js?cdnversion=394829\"><\/script><script src=\"\/\/csdnimg.cn\/rabbit\/tracking-ad\/main.js?75eacd6\" type=\"text\/javascript\" charset=\"utf-8\"><\/script><script src=\"http:\/\/s.yunshipei.com\/javascript\/sm.min.js\" async=\"\" charset=\"utf-8\"><\/script><script src=\"http:\/\/bdimg.share.baidu.com\/static\/js\/logger.js?cdnversion=394831\"><\/script><\/p>\n<div id=\"container\">\n<div id=\"body\">\n<div id=\"main\">\n<div class=\"main\">\n<div id=\"article_details\" class=\"details\">\n<div id=\"article_content\" class=\"article_content\">\n<div id=\"blogtext_fks_084070082095085070093080094095087094082067085085082\" class=\"g_t_left c07 content\">\n<p>my.cnf\u7f13\u5b58\u4f18\u5316<br \/>\n\u5728 my.cnf \u4e2d\u6dfb\u52a0\/\u4fee\u6539\u4ee5\u4e0b\u9009\u9879:<\/p>\n<div>\n<div>#\u53d6\u6d88\u6587\u4ef6\u7cfb\u7edf\u7684\u5916\u90e8\u9501<br \/>\nskip-locking<\/p>\n<p>#\u4e0d\u8fdb\u884c\u57df\u540d\u53cd\u89e3\u6790,\u6ce8\u610f\u7531\u6b64\u5e26\u6765\u7684\u6743\u9650\/\u6388\u6743\u95ee\u9898<br \/>\nskip-name-resolve<\/p>\n<p>#\u7d22\u5f15\u7f13\u5b58,\u6839\u636e\u5185\u5b58\u5927\u5c0f\u800c\u5b9a,\u5982\u679c\u662f\u72ec\u7acb\u7684db\u670d\u52a1\u5668,\u53ef\u4ee5\u8bbe\u7f6e\u9ad8\u8fbe80%\u7684\u5185\u5b58\u603b\u91cf<br \/>\nkey_buffer = 512M<\/p>\n<p>#\u8fde\u63a5\u6392\u961f\u5217\u8868\u603b\u6570<br \/>\nback_log = 200<br \/>\nmax_allowed_packet = 2M<\/p>\n<p>#\u6253\u5f00\u8868\u7f13\u5b58\u603b\u6570,\u53ef\u4ee5\u907f\u514d\u9891\u7e41\u7684\u6253\u5f00\u6570\u636e\u8868\u4ea7\u751f\u7684\u5f00\u9500<br \/>\ntable_cache = 512<\/p>\n<p>#\u6bcf\u4e2a\u7ebf\u7a0b\u6392\u5e8f\u6240\u9700\u7684\u7f13\u51b2<br \/>\nsort_buffer_size = 4M<\/p>\n<p>#\u6bcf\u4e2a\u7ebf\u7a0b\u8bfb\u53d6\u7d22\u5f15\u6240\u9700\u7684\u7f13\u51b2<br \/>\nread_buffer_size = 4M<\/p>\n<p>#MyISAM\u8868\u53d1\u751f\u53d8\u5316\u65f6\u91cd\u65b0\u6392\u5e8f\u6240\u9700\u7684\u7f13\u51b2<br \/>\nmyisam_sort_buffer_size = 64M<\/p>\n<p>#\u7f13\u5b58\u53ef\u91cd\u7528\u7684\u7ebf\u7a0b\u6570<br \/>\nthread_cache = 128<\/p>\n<p>#\u67e5\u8be2\u7ed3\u679c\u7f13\u5b58<br \/>\nquery_cache_size = 128M<\/p>\n<p>#\u8bbe\u7f6e\u8d85\u65f6\u65f6\u95f4,\u80fd\u907f\u514d\u957f\u8fde\u63a5<br \/>\nset-variable = wait_timeout=60<\/p>\n<p>#\u6700\u5927\u5e76\u53d1\u7ebf\u7a0b\u6570,cpu\u6570\u91cf*2<br \/>\nthread_concurrency = 4<\/p>\n<p>#\u8bb0\u5f55\u6162\u67e5\u8be2,\u7136\u540e\u5bf9\u6162\u67e5\u8be2\u4e00\u4e00\u4f18\u5316<br \/>\nlog-slow-queries = slow.log<br \/>\nlong_query_time = 1<\/p>\n<p>#\u5173\u95ed\u4e0d\u9700\u8981\u7684\u8868\u7c7b\u578b,\u5982\u679c\u4f60\u9700\u8981,\u5c31\u4e0d\u8981\u52a0\u4e0a\u8fd9\u4e2a<br \/>\nskip-innodb<br \/>\nskip-bdb<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u4f18\u5316\u6b65\u9aa4\u53camy.cnf\u7f13\u5b58\u4f18\u5316 &#8211; \u4f3c\u6c34\u6d41\u5e74&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-444","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/comments?post=444"}],"version-history":[{"count":1,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/444\/revisions"}],"predecessor-version":[{"id":445,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/posts\/444\/revisions\/445"}],"wp:attachment":[{"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/media?parent=444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/categories?post=444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elon.852128.com\/blog\/wp-json\/wp\/v2\/tags?post=444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}