{"id":930,"date":"2018-07-09T21:24:20","date_gmt":"2018-07-09T13:24:20","guid":{"rendered":"https:\/\/blog.freesilo.com\/?p=930"},"modified":"2018-07-09T21:24:20","modified_gmt":"2018-07-09T13:24:20","slug":"mysql-5-6%e5%86%85%e5%ad%98%e5%8f%82%e6%95%b0%e8%b0%83%e4%bc%98","status":"publish","type":"post","link":"https:\/\/freesilo.com\/?p=930","title":{"rendered":"mysql 5.6\u5185\u5b58\u53c2\u6570\u8c03\u4f18"},"content":{"rendered":"<p>mysql 5.6\u9ed8\u8ba4\u542f\u52a8\u5360\u7528\u5185\u5b58400\u591aM\uff0c\u5982\u679c\u662fvps\u7b49\uff0c\u660e\u663e\u504f\u9ad8\u3002<br \/>\n\u4fee\u6539performance_schema_max_table_instances,table_definition_cache,table_open_cache\u8fd9\u4e2a\u4e09\u4e2a\u53c2\u6570\uff0c\u8c03\u4f4e\u503c\u80fd\u660e\u663e\u51cf\u5c0f\u3002<br \/>\n\u9ed8\u8ba4\u503c\u5982\u4e0b\uff1a<br \/>\nperformance_schema_max_table_instances 12500<br \/>\ntable_definition_cache 1400<br \/>\ntable_open_cache 2000<br \/>\n\u53c2\u6570\u542b\u4e49\uff1a<br \/>\nperformance_schema_max_table_instances :The maximum number of instrumented table objects.<br \/>\ntable_definition_cache:The number of table definitions (from .frm files) that can be stored in the definition cache<br \/>\ntable_open_cache:The number of open tables for all threads.<br \/>\n\u8c03\u4f4e\u5982\u4e0b\uff1a<br \/>\n<span style=\"color: #ff00ff;\">performance_schema_max_table_instances = 200<\/span><br \/>\n<span style=\"color: #ff00ff;\">table_definition_cache = 100<\/span><br \/>\n<span style=\"color: #ff00ff;\">table_open_cache = 100<\/span><\/p>\n<p>\u53ef\u964d\u4f4e\u523060\u591aM\u5de6\u53f3\u3002<br \/>\n\u8fdb\u4e00\u6b65\u8c03\u6574\u53c2\u6570\uff1a<br \/>\ninnodb_buffer_pool_size\uff0cinnodb_additional_mem_pool_size\uff0cinnodb_log_buffer_size\u8fd9\u4e2a\u4e09\u4e2a\u53c2\u6570\u53ef\u4ee5\u8c03\u5c0f\u3002<br \/>\n\u518d\u8fdb\u4e00\u6b65\u8c03\u6574\uff1a mysql 5.6\u9ed8\u8ba4\u542f\u7528performance_schema\uff0c\u5360\u7528\u5f88\u591a\u5185\u5b58\uff0c\u53ef\u4ee5\u7981\u7528\u3002<\/p>\n<p>\u5b8c\u6574\u914d\u7f6e\u6587\u4ef6\u5982\u4e0b\uff0c\u5185\u5b58\u5360\u7528\u523022M\uff1a<br \/>\ncat \/etc\/my.cnf &#8220;`<\/p>\n<p>[mysqld]<br \/>\nport = 3306<br \/>\nserver_id = 1<br \/>\nsocket = \/tmp\/mysql.sock<\/p>\n<p>performance_schema = OFF<\/p>\n<p>innodb_buffer_pool_size = 8M<br \/>\ninnodb_additional_mem_pool_size = 1M<br \/>\ninnodb_log_buffer_size = 1M<\/p>\n<p>key_buffer_size = 0<br \/>\nquery_cache_size = 0<\/p>\n<p>log_bin = mysql-bin<br \/>\nbasedir = \/usr\/local\/mysql<br \/>\ndatadir = \/usr\/local\/mysql\/data<\/p>\n<p>sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES &#8220;`<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql 5.6\u9ed8\u8ba4\u542f\u52a8\u5360\u7528\u5185\u5b58400\u591aM\uff0c\u5982\u679c\u662fvps\u7b49\uff0c\u660e\u663e\u504f\u9ad8\u3002 \u4fee\u6539p&#8230;<br \/><a class=\"read-more-button\" href=\"https:\/\/freesilo.com\/?p=930\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-930","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=930"}],"version-history":[{"count":1,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions"}],"predecessor-version":[{"id":931,"href":"https:\/\/freesilo.com\/index.php?rest_route=\/wp\/v2\/posts\/930\/revisions\/931"}],"wp:attachment":[{"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/freesilo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}