{"id":345,"date":"2011-04-28T17:03:11","date_gmt":"2011-04-28T17:03:11","guid":{"rendered":""},"modified":"2013-02-07T12:10:28","modified_gmt":"2013-02-07T04:10:28","slug":"mysql%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/ybzx.vip\/wp\/?p=345","title":{"rendered":"Mysql\u4f18\u5316"},"content":{"rendered":"<p>\u8d34\u4e00\u4efd\u4f18\u5316\u914d\u7f6e\uff0c\u5907\u67e5<!--more--><br \/>[mysqld]<br \/>datadir=\/var\/lib\/mysql<br \/>socket=\/var\/lib\/mysql\/mysql.sock<br \/>user=mysql<br \/><span style=\"color: #DC143C;\">tmp_table_size=200M<br \/>max_tmp_tables=100<br \/>back_log = 384<br \/>key_buffer_size = 256M<br \/>max_allowed_packet = 4M<br \/>thread_stack = 256K<br \/>table_cache = 128K<br \/>sort_buffer_size = 64M<br \/>read_buffer_size = 64M<br \/>join_buffer_size = 64M<br \/>myisam_sort_buffer_size = 128M<br \/>table_cache = 512<br \/>thread_cache = 16<br \/>query_cache_size = 512M<br \/>query_cache_size = 64M<br \/>max_connections = 768<br \/>wait_timeout = 20<br \/>interactive_timeout = 20<br \/>thread_concurrency = 8<\/span><\/p>\n<p># Default to using old password format for compatibility with mysql 3.x<br \/># clients (those using the mysqlclient10 compatibility package).<br \/># old_passwords=1<\/p>\n<p># Disabling symbolic-links is recommended to prevent assorted security risks;<br \/># to do so, uncomment this line:<br \/># symbolic-links=0<\/p>\n<p>[mysqld_safe]<br \/>log-error=\/var\/log\/mysqld.log<br \/>pid-file=\/var\/run\/mysqld\/mysqld.pid<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8d34\u4e00\u4efd\u4f18\u5316\u914d\u7f6e\uff0c\u5907\u67e5<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117],"tags":[79,78,91],"class_list":["post-345","post","type-post","status-publish","format-standard","hentry","category-network","tag-centos","tag-linux","tag-mysql"],"_links":{"self":[{"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=345"}],"version-history":[{"count":0,"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=\/wp\/v2\/posts\/345\/revisions"}],"wp:attachment":[{"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ybzx.vip\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}