{"id":239,"date":"2019-09-06T17:28:31","date_gmt":"2019-09-06T09:28:31","guid":{"rendered":"https:\/\/wp.dj47.top\/?p=239"},"modified":"2021-10-20T16:16:47","modified_gmt":"2021-10-20T08:16:47","slug":"ubuntu%e4%b8%8b%e4%bf%ae%e6%94%b9mysql%e7%9a%84%e9%bb%98%e8%ae%a4%e8%bf%9e%e6%8e%a5%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.djlog.cn\/?p=239","title":{"rendered":"Ubuntu\u4e0b\u4fee\u6539mysql\u7684\u9ed8\u8ba4\u8fde\u63a5\u6570"},"content":{"rendered":"<h5 style=\"box-sizing: border-box; font-family: inherit; font-weight: 500; line-height: 1.1; color: inherit; margin-top: 10px; margin-bottom: 10px; font-size: 14px;\">\u4fee\u6539mysql\u4e2d\u7684mysqld.cnf\u6587\u4ef6<\/h5>\n<pre class=\"language-javascript\"><code>cd \/etc\/mysql\/mysql.conf.d\r\n\/\/\u6267\u884c\u4e0b\u9762\u7684\u64cd\u4f5c\u6765\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\r\nsudo vim mysqld.cnf\r\n\/\/\u5728 [mysqld] \u4e2d\u65b0\u52a0\r\nmax_connections  =1000\uff1b\r\n\/\/\u6309\u4e0besc\u6309\u952e\u8f93\u5165\uff1awq\u4fdd\u5b58\u9000\u51fa<\/code><\/pre>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px;\"><span style=\"box-sizing: border-box; font-weight: bold;\">\u91cd\u542fmysql\u670d\u52a1\u5668<\/span><\/p>\n<pre class=\"language-javascript\"><code>sudo service mysql restart\uff1b<\/code><\/pre>\n<h6 style=\"box-sizing: border-box; font-family: inherit; font-weight: 500; line-height: 1.1; color: inherit; margin-top: 10px; margin-bottom: 10px; font-size: 12px;\">\u767b\u5f55\u8fdb\u53bb\u67e5\u770bmysql\u914d\u7f6e<\/h6>\n<pre class=\"language-javascript\"><code>mysql -uroot -p\r\n\/\/\u8f93\u5165\u5bc6\u7801\u767b\u5f55\r\n\/\/\u67e5\u770b\u521a\u521a\u914d\u7f6e\u4fe1\u606f\r\nmysql&gt;show variables like '%max_connections%';\r\n\/\/\u53d1\u73b0\u6ca1\u6709\u6539\u4e3a\u9ed8\u8ba4\u6700\u5927\u662f214\r\n\/\/\u56e0\u4e3aubuntu\u7cfb\u7edf\u672c\u8eab\u6709\u9650\u5236\u6587\u4ef6\u6253\u5f00\u548c\u8fde\u63a5\u6570\u91cf\uff0c\u6240\u4ee5\u9700\u8981\u4fee\u6539\u7cfb\u7edf\u914d\u7f6e\u6765\u8fbe\u5230\u6211\u4eec\u7684\u8981\u6c42<\/code><\/pre>\n<h6 style=\"box-sizing: border-box; font-family: inherit; font-weight: 500; line-height: 1.1; color: inherit; margin-top: 10px; margin-bottom: 10px; font-size: 12px;\">\u4fee\u6539\u7cfb\u7edf\u914d\u7f6e<\/h6>\n<pre class=\"language-javascript\"><code>cd  \/etc\/systemd\/system\/multi-user.target.wants\r\nsudo vim mysql.service\r\n\/\/\u5728 [Service] \u6700\u540e\u52a0\u5165\uff1a\r\nLimitNOFILE=65535\r\nLimitNPROC=65535\r\n\/\/\u6309\u4e0besc\u6309\u952e\u8f93\u5165\uff1awq\u4fdd\u5b58\u9000\u51fa<\/code><\/pre>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px;\">\u5237\u65b0\u7cfb\u7edf\u914d\u7f6e<\/p>\n<pre class=\"language-javascript\"><code>systemctl daemon-reload\r\nsystemctl restart mysql.service<\/code><\/pre>\n<h6 style=\"box-sizing: border-box; font-family: inherit; font-weight: 500; line-height: 1.1; color: inherit; margin-top: 10px; margin-bottom: 10px; font-size: 12px;\">\u68c0\u9a8c\u914d\u7f6e\u662f\u5426\u6210\u529f<\/h6>\n<pre class=\"language-javascript\"><code>mysql -uroot -p\r\n\/\/\u8f93\u5165\u5bc6\u7801\u767b\u5f55\r\n\/\/\u67e5\u770b\u521a\u521a\u914d\u7f6e\u4fe1\u606f\r\nmysql&gt;show variables like '%max_connections%';<\/code><\/pre>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px;\">\u8fd9\u662f\u53ef\u4ee5\u770b\u5230\u5df2\u4fee\u6539\u4e3a1000\u4e86<\/p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 10px;\">\n","protected":false},"excerpt":{"rendered":"<p>\u4fee\u6539mysql\u4e2d\u7684mysqld.cnf\u6587\u4ef6 cd \/etc\/mysql\/mysql.conf.d \/\/\u6267\u884c\u4e0b\u9762 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[40,45],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-linux","tag-ubuntu"],"_links":{"self":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=239"}],"version-history":[{"count":0,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}