{"id":1153,"date":"2014-03-06T13:34:00","date_gmt":"2014-03-06T05:34:00","guid":{"rendered":"http:\/\/blog.dayandcarrot.net\/?p=1153"},"modified":"2014-03-06T13:34:00","modified_gmt":"2014-03-06T05:34:00","slug":"mysqld-exe-%e5%86%85%e5%ad%98%e5%8d%a0%e7%94%a8%e9%ab%98-%e8%be%be-400m-%e7%9a%84%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/dayandcarrot.space\/?p=1153","title":{"rendered":"mysqld.exe \u5185\u5b58\u5360\u7528\u9ad8 \u8fbe 400M \u7684\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"<p><a href=\"http:\/\/www.debugease.com\/mysql\/3404188.html\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/www.debugease.com\/mysql\/3404188.html<\/a><\/p>\n<ol>\n<li id=\"comment-293\">\n<div>mysqld.exe\u00a0\u5185\u5b58\u5360\u7528\u8fbe\u00a0400M\u00a0\u8fd9\u662f\u5f88\u6b63\u5e38\u7684\u554a\uff01mysqld\u9ed8\u8ba4\u9700\u8981\u90e8\u5206\u5185\u5b58\uff0c\u8fd8\u6709\u4f60\u5728my.ini\u914d\u7f6e\u7684\u5404\u79cd\u7f13\u5b58\uff0c\u4f8b\u5982\uff1a<br \/>\ninnodb_buffer_pool_size=107M<br \/>\ninnodb_log_file_size=18M<br \/>\ninnodb_log_buffer_size=2M<\/div>\n<p>&nbsp;<\/li>\n<li id=\"comment-293\">&nbsp;\n<div>\u54c8\u54c8,\u8fd9\u4e2a\u597d\u89e3\u51b3\u54c8,<br \/>\npaip.mysql\u00a05.6\u00a0\u6570\u636e\u5e93\u00a0\u5360\u7528\u00a0\u5185\u5b58\u00a0\u8fc7\u591a\u00a0\u7684\u00a0\u89e3\u51b3\u65b9\u6848<br \/>\n\u4e0b\u8f7d\u4e86mysql5.6.12\u00a0,\u9ed8\u8ba4\u5360\u7528\u5185\u5b58\u8fbe400\u591aM,\u00a0\u00a0\u800c\u539f\u6765\u4f7f\u7528\u76845.0\u00a0\u53ea\u670930M..<br \/>\n\u89e3\u51b3\u65b9\u6848:\u8c03\u6574\u4ee5\u4e0b\u53c2\u6570<br \/>\n&#8212;&#8212;&#8212;&#8212;&#8212;-<br \/>\nperformance_schema_max_table_instances=600<br \/>\ntable_definition_cache=400<br \/>\ntable_open_cache=256<br \/>\n\u8fd9\u6837\u4e0b\u6765,mysql5.6.12\u5c31\u53ea\u4f7f\u7528\u00a0\u00a040&#8212;60M\u5de6\u53f3\u7684\u5185\u5b58\u4e86.<\/div>\n<\/li>\n<\/ol>\n<p>&nbsp;<br \/>\n&nbsp;<br \/>\n<strong>\u9644\u6ce8\uff1amysql 5.6.x\u7684\u914d\u7f6e\u6587\u4ef6\u76ee\u5f55\uff0c\u5e94\u8be5\u5728\u5b89\u88c5\u76ee\u5f55\u7684\u6839\u76ee\u5f55\u4e0b\uff0c\u53cd\u6b63\u6587\u4ef6\u540d\u662fmy.ini\uff0c\u662f\u5728\u4e0d\u60f3\u5230\u5b89\u88c5\u7684\u5206\u533a\u641c\u7d22\u4e0b\u80af\u5b9a\u6709\u5566\u3002<\/strong><br \/>\n<strong>\u53e6\u5916\u66f4\u6539\u7ed3\u675f\u540e\u4e0d\u80fd\u5fd8\u8bb0\u91cd\u542f\u670d\u52a1\u54e6\uff01<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/www.debugease.com\/mysql\/3404188.html mysqld.exe\u00a0\u5185\u5b58\u5360\u7528\u8fbe\u00a0400M\u00a0\u8fd9\u662f\u5f88\u6b63\u5e38\u7684\u554a\uff01mysqld\u9ed8\u8ba4\u9700\u8981\u90e8\u5206\u5185\u5b58\uff0c\u8fd8\u6709\u4f60\u5728my.ini\u914d\u7f6e\u7684\u5404\u79cd\u7f13\u5b58\uff0c\u4f8b\u5982\uff1a innodb_buffer_pool_size=107M innodb_log_file_size=18M innodb_log_buffer_size=2M &nbsp; &nbsp; \u54c8\u54c8,\u8fd9\u4e2a\u597d\u89e3\u51b3\u54c8, paip.mysql\u00a05.6\u00a0\u6570\u636e\u5e93\u00a0\u5360\u7528\u00a0\u5185\u5b58\u00a0\u8fc7\u591a\u00a0\u7684\u00a0\u89e3\u51b3\u65b9\u6848 \u4e0b\u8f7d\u4e86mysql5.6.12\u00a0,\u9ed8\u8ba4\u5360\u7528\u5185\u5b58\u8fbe400\u591aM,\u00a0\u00a0\u800c\u539f\u6765\u4f7f\u7528\u76845.0\u00a0\u53ea\u670930M.. \u89e3\u51b3\u65b9\u6848:\u8c03\u6574\u4ee5\u4e0b\u53c2\u6570 &#8212;&#8212;&#8212;&#8212;&#8212;- performance_schema_max_table_instances=600 table_definition_cache=400 table_open_cache=256 \u8fd9\u6837\u4e0b\u6765,mysql5.6.12\u5c31\u53ea\u4f7f\u7528\u00a0\u00a040&#8212;60M\u5de6\u53f3\u7684\u5185\u5b58\u4e86. &nbsp; &nbsp; \u9644\u6ce8\uff1amysql 5.6.x\u7684\u914d\u7f6e\u6587\u4ef6\u76ee\u5f55\uff0c\u5e94\u8be5\u5728\u5b89\u88c5\u76ee\u5f55\u7684\u6839\u76ee\u5f55\u4e0b\uff0c\u53cd\u6b63\u6587\u4ef6\u540d\u662fmy.ini\uff0c\u662f\u5728\u4e0d\u60f3\u5230\u5b89\u88c5\u7684\u5206\u533a\u641c\u7d22\u4e0b\u80af\u5b9a\u6709\u5566\u3002 \u53e6\u5916\u66f4\u6539\u7ed3\u675f\u540e\u4e0d\u80fd\u5fd8\u8bb0\u91cd\u542f\u670d\u52a1\u54e6\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[76],"class_list":["post-1153","post","type-post","status-publish","format-standard","hentry","category-technical","tag-mysql"],"_links":{"self":[{"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=\/wp\/v2\/posts\/1153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1153"}],"version-history":[{"count":0,"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=\/wp\/v2\/posts\/1153\/revisions"}],"wp:attachment":[{"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dayandcarrot.space\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}