{"id":8966,"date":"2014-07-12T04:45:23","date_gmt":"2014-07-11T20:45:23","guid":{"rendered":"http:\/\/bohu.net\/blog\/?p=8966"},"modified":"2014-07-12T04:45:23","modified_gmt":"2014-07-11T20:45:23","slug":"vps%e4%b8%8b%e5%af%b9mysql%e5%86%85%e5%ad%98%e6%80%a7%e8%83%bd%e7%9a%84%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/www.bohu.net\/blog\/8966\/","title":{"rendered":"VPS\u4e0b\u5bf9mysql\u5185\u5b58\u6027\u80fd\u7684\u4f18\u5316"},"content":{"rendered":"<p>VPS\u7684\u5185\u5b58\u5bf9\u6027\u80fd\u81f3\u5173\u91cd\u8981\uff0c\u6240\u4ee5\u5f88\u6709\u5fc5\u8981\u4f18\u5316\u4e00\u4e0b\u3002<\/p>\n<p>\u770b\u4e86\u51e0\u7bc7\u9488\u5bf9vps\u5c0f\u5185\u5b58\u4f18\u5316\u7684\u6587\u7ae0\uff0c\u4e8e\u662f\u81ea\u5df1\u4e5f\u52a8\u624b\u53c2\u7167\u4f18\u5316\u4e0b\u81ea\u5df1\u7684mysql\u3002<\/p>\n<p>\u4fee\u6539\u8fc7\u8c03\u6574\u597d\u7684 my.cnf \uff0cservice mysqld restart \u542f\u52a8\u65f6\u62a5\u9519\u3002<\/p>\n<p>\u67e5\u770blog\uff0c\u53d1\u73b0 skip-innodb \/ skip-bdb \/ skip-locking\uff0c\u8fd9\u51e0\u4e2a\u53c2\u6570\u6709\u95ee\u9898\u3002<\/p>\n<p>&nbsp;<\/p>\n<p>\u7ee7\u7eed\u5b66\u4e60\uff0c\u67e5\u8d44\u6599\uff0c\u5f97\u77e5 \u4f7f\u7528\u7684\u53c2\u6570\u90fd\u662f\u8001\u7248\u672c\u7684\u53c2\u6570\uff0cmysql5.1\u5bf9\u5e94\u7684\u4e3a\uff1a<\/p>\n<p>skip-innodb\u00a0 &#8211;&gt; \u00a0loose-skip-innodb<\/p>\n<p>skip-locking\u00a0 &#8211;&gt; skip-external-locking<\/p>\n<p>skip-bdb (\u5df2\u7ecf\u5e9f\u9664\u4e86skip-bdb\u8fd9\u4e2a\u53c2\u6570\uff01)<\/p>\n<p>&nbsp;<\/p>\n<p>\u914d\u7f6e\u6587\u4ef6: \/etc\/my.cnf<\/p>\n<blockquote>\n<h4><\/h4>\n<p># low memory stuff &#8211; Mr.Tang<br \/>\n# Tue May 26 22:23:15 CST 2015<\/p>\n<p>[mysqld]<\/p>\n<p>loose-skip-innodb<br \/>\nskip-external-locking<br \/>\nskip-host-cache<br \/>\nskip-name-resolve<\/p>\n<p>character_set_server = utf8<br \/>\ndefault-storage-engine = myisam<\/p>\n<p>key_buffer_size = 256M<br \/>\nkey_buffer = 256K<br \/>\nmax_allowed_packet = 1M<br \/>\nmyisam_sort_buffer_size = 8M<br \/>\nnet_buffer_length = 128K<br \/>\nquery_cache_size= 16M<br \/>\nread_buffer_size = 1M<br \/>\nread_rnd_buffer_size = 4M<br \/>\nsort_buffer_size = 1M<br \/>\ntable_cache = 4M<br \/>\ntable_open_cache = 16M<br \/>\nthread_cache_size = 8M<br \/>\nthread_stack = 131072<\/p>\n<p>[mysqldump]<br \/>\nquick<br \/>\nmax_allowed_packet = 16M<\/p>\n<p>[mysql]<br \/>\nno-auto-rehash<br \/>\n#safe-updates<\/p>\n<p>[isamchk]<br \/>\nkey_buffer = 8M<br \/>\nsort_buffer_size = 8M<\/p>\n<p>[myisamchk]<br \/>\nkey_buffer_size = 128M<br \/>\nsort_buffer_size = 128M<br \/>\nread_buffer = 2M<br \/>\nwrite_buffer = 2M<\/p>\n<p>[mysqlhotcopy]<br \/>\ninteractive-timeout<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>VPS\u7684\u5185\u5b58\u5bf9\u6027\u80fd\u81f3\u5173\u91cd\u8981\uff0c\u6240\u4ee5\u5f88\u6709\u5fc5\u8981\u4f18\u5316\u4e00\u4e0b\u3002 \u770b\u4e86\u51e0\u7bc7\u9488\u5bf9vps\u5c0f\u5185\u5b58\u4f18\u5316\u7684\u6587\u7ae0\uff0c\u4e8e\u662f\u81ea\u5df1\u4e5f\u52a8\u624b\u53c2\u7167\u4f18\u5316 &hellip; <a href=\"https:\/\/www.bohu.net\/blog\/8966\/\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u201cVPS\u4e0b\u5bf9mysql\u5185\u5b58\u6027\u80fd\u7684\u4f18\u5316\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,7,8,11,16,27,28,29],"tags":[259,406,462,468,520],"class_list":["post-8966","post","type-post","status-publish","format-standard","hentry","category-linux","category-mysql","category-sql","category-web","category-wordpress","category-27","category-28","category-29","tag-mysql","tag-vps","tag-462","tag-468","tag-520"],"_links":{"self":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/comments?post=8966"}],"version-history":[{"count":0,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/posts\/8966\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/media?parent=8966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/categories?post=8966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bohu.net\/blog\/wp-json\/wp\/v2\/tags?post=8966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}