{"id":462,"date":"2018-06-12T21:54:02","date_gmt":"2018-06-12T13:54:02","guid":{"rendered":"http:\/\/pony.hk\/?p=462"},"modified":"2018-06-12T21:58:10","modified_gmt":"2018-06-12T13:58:10","slug":"%e5%b0%8f%e5%86%85%e5%ad%98vps%e7%9a%84mysql%e5%86%85%e5%ad%98%e8%b0%83%e4%bc%98","status":"publish","type":"post","link":"https:\/\/lnmp.ivan.xin\/?p=462","title":{"rendered":"\u5c0f\u5185\u5b58VPS\u7684mysql\u5185\u5b58\u8c03\u4f18"},"content":{"rendered":"<p>\u6709\u7684VPS\u5185\u5b58\u975e\u5e38\u5c0f\uff0c\u9700\u8981\u628amysql\u5360\u7528\u5185\u5b58\u964d\u5230\u5f88\u4f4e\uff0c\u6bd4\u598230MB\u4ee5\u5185\uff0c\/etc\/my.cnf\u53ef\u4ee5\u8fd9\u6837\u914d\u7f6e\uff1a<\/p>\n<blockquote><p>[mysqld]<br \/>\ndefault-storage-engine=MYISAM<br \/>\ndefault-tmp-storage-engine=MYISAM<br \/>\n# skip-innodb<br \/>\nloose-skip-innodb<br \/>\nloose-innodb-trx=0<br \/>\nloose-innodb-locks=0<br \/>\nloose-innodb-lock-waits=0<br \/>\nloose-innodb-cmp=0<br \/>\nloose-innodb-cmp-per-index=0<br \/>\nloose-innodb-cmp-per-index-reset=0<br \/>\nloose-innodb-cmp-reset=0<br \/>\nloose-innodb-cmpmem=0<br \/>\nloose-innodb-cmpmem-reset=0<br \/>\nloose-innodb-buffer-page=0<br \/>\nloose-innodb-buffer-page-lru=0<br \/>\nloose-innodb-buffer-pool-stats=0<br \/>\nloose-innodb-metrics=0<br \/>\nloose-innodb-ft-default-stopword=0<br \/>\nloose-innodb-ft-inserted=0<br \/>\nloose-innodb-ft-deleted=0<br \/>\nloose-innodb-ft-being-deleted=0<br \/>\nloose-innodb-ft-config=0<br \/>\nloose-innodb-ft-index-cache=0<br \/>\nloose-innodb-ft-index-table=0<br \/>\nloose-innodb-sys-tables=0<br \/>\nloose-innodb-sys-tablestats=0<br \/>\nloose-innodb-sys-indexes=0<br \/>\nloose-innodb-sys-columns=0<br \/>\nloose-innodb-sys-fields=0<br \/>\nloose-innodb-sys-foreign=0<br \/>\nloose-innodb-sys-foreign-cols=0<br \/>\n#skip-locking #old version<br \/>\nskip-external-locking<br \/>\nkey_buffer = 16K<br \/>\nquery_cache_limit = 256K<br \/>\nquery_cache_size = 4M<br \/>\nmax_allowed_packet = 1M<br \/>\n#table_cache = 8<br \/>\nmax_connections = 16<br \/>\nthread_concurrency = 2<br \/>\nsort_buffer_size = 64K<br \/>\nread_buffer_size = 256K<br \/>\nread_rnd_buffer_size = 256K<br \/>\nnet_buffer_length = 2K<br \/>\nthread_stack = 64K<br \/>\nlog-bin=mysql-bin<br \/>\nbinlog_format=mixed<br \/>\nexpire_logs_days = 30<br \/>\nperformance_schema_max_table_instances=100<br \/>\ntable_definition_cache=20<br \/>\ntable_open_cache=20<br \/>\nslow_query_log<br \/>\nlong_query_time = 2<br \/>\n##slow_query_log_file=\"\/tmp\/mysql_slow.log\"<br \/>\n##log_slave_updates<br \/>\n##gtid-mode=ON<br \/>\n##enforce-gtid-consistency=ON<br \/>\nexplicit_defaults_for_timestamp=true<br \/>\n[mysqldump]<br \/>\nquick<br \/>\nmax_allowed_packet = 16M<br \/>\n[mysql]<br \/>\nno-auto-rehash<br \/>\n#safe-updates<br \/>\n[isamchk]<br \/>\nkey_buffer = 8M<br \/>\nsort_buffer_size = 8M<br \/>\n[myisamchk]<br \/>\nkey_buffer = 8M<br \/>\nsort_buffer_size = 8M<br \/>\n[mysqlhotcopy]<br \/>\ninteractive-timeout<\/p><\/blockquote>\n<p>\u53c2\u8003\u6587\u7ae0\uff1ahttps:\/\/blog.csdn.net\/yidian815\/article\/details\/26278699<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6709\u7684VPS\u5185\u5b58\u975e\u5e38\u5c0f\uff0c\u9700\u8981\u628amysql\u5360\u7528\u5185\u5b58\u964d\u5230\u5f88\u4f4e\uff0c\u6bd4\u598230MB\u4ee5\u5185\uff0c\/etc\/my.cnf\u53ef\u4ee5\u8fd9\u6837\u914d\u7f6e\uff1a...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15330],"tags":[],"class_list":["post-462","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=462"}],"version-history":[{"count":0,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/462\/revisions"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}