{"id":488,"date":"2024-05-07T22:15:54","date_gmt":"2024-05-07T14:15:54","guid":{"rendered":"https:\/\/sharebits.link\/?p=488"},"modified":"2024-05-26T17:57:20","modified_gmt":"2024-05-26T09:57:20","slug":"488-2","status":"publish","type":"post","link":"https:\/\/sharebits.link\/?p=488","title":{"rendered":"mysql\u542f\u52a8\u540e\u81ea\u52a8\u505c\u6b62_\u5b9d\u5854mysql\u603b\u662f\u81ea\u52a8\u505c\u6b62\u89e3\u51b3\u65b9\u6cd5\u603b\u6c47"},"content":{"rendered":"
<\/div>\n

\ud83d\udd16\u4e00\u53e5\u8bdd\u63cf\u8ff0:
\n\u670d\u52a1\u5668\u5185\u5b58\u4e0d\u8db3\u5bfc\u81f4\u5b9d\u5854\u9762\u677f\u6570\u636e\u5e93\u7ecf\u5e38\u6027\u81ea\u52a8\u505c\u6b62\uff0c\u7279\u522b\u662fZBlog\u7a0b\u5e8f\u9891\u7e41\u8bf7\u6c42\u6570\u636e\u5e93\u3002\u89e3\u51b3\u65b9\u6cd5\u5305\u62ec\u6dfb\u52a0SWAP\u5927\u5c0f\u3001\u6839\u636e\u5b9e\u9645\u5185\u5b58\u8fdb\u884cMySQL\u4f18\u5316\u3001\u6dfb\u52a0Mysql\u5b88\u62a4\u6267\u884c\u5468\u671f\u3001\u589e\u52a0\u670d\u52a1\u5668\u5185\u5b58\u6216\u4f7f\u7528\u4e91\u6570\u636e\u5e93\u3002<\/p>\n

\ud83d\udd16\u6587\u7ae0\u8981\u70b9\uff1a
\n1.\u670d\u52a1\u5668\u5185\u5b58\u4e0d\u8db3\u5bfc\u81f4\u6570\u636e\u5e93\u81ea\u52a8\u505c\u6b62
\n2.ZBlog\u7a0b\u5e8f\u9891\u7e41\u8bf7\u6c42\u6570\u636e\u5e93
\n3.\u89e3\u51b3\u65b9\u6cd5\u4e00\uff1a\u6dfb\u52a0\u8bbe\u7f6eSWAP\u5927\u5c0f
\n4.\u89e3\u51b3\u65b9\u6cd5\u4e8c\uff1a\u6839\u636e\u5b9e\u9645\u5185\u5b58\u8fdb\u884cMySQL\u4f18\u5316
\n5.\u89e3\u51b3\u65b9\u6cd5\u4e09\uff1a\u6dfb\u52a0Mysql\u5b88\u62a4\u6267\u884c\u5468\u671f
\n6.\u89e3\u51b3\u65b9\u6cd5\u56db\uff1a\u589e\u52a0\u670d\u52a1\u5668\u5185\u5b58\u6216\u4f7f\u7528\u4e91\u6570\u636e\u5e93<\/p>\n

 <\/p>\n

\u5b9d\u5854\u7684\u6570\u636e\u5e93<\/a>\u7ecf\u5e38\u6027\u81ea\u52a8\u505c\u6b62\uff0c\u662f\u56e0\u4e3a\u7f51\u7ad9\u9891\u7e41\u7684\u8bf7\u6c42\u6570\u636e\u5e93\uff0c\u800c\u670d\u52a1\u5668<\/a>\u5185\u5b58\u53c8\u4e0d\u8db3\uff0c\u4e3a\u4e86\u4fdd\u8bc1\u670d\u52a1\u5668\u4e0d\u5f7b\u5e95\u5361\u6b7b\uff0c\u4fdd\u62a4\u6027\u7684\u81ea\u52a8\u505c\u6b62\u6570\u636e\u5e93\uff0c\u7279\u522b\u662f\u6709\u4e9b\u7a0b\u5e8f\u6bd4\u5982ZBlog\u7684\u6570\u636e\u5e93\u67e5\u8be2\u6b21\u6570\u5c24\u4e3a\u7a81\u51fa\uff0c\u52a0\u4e0aZBlog\u63d2\u4ef6\u4e4b\u591a\uff0c\u5c31\u7b97\u4f60\u4e0d\u8fdb\u884c\u4efb\u4f55\u64cd\u4f5c\uff0c\u4f60\u7684\u540e\u53f0\u4e5f\u662f\u5728\u9891\u7e41\u7684\u8bf7\u6c42\u6570\u636e\u5e93\uff01<\/p>\n

\u200b<\/p>\n

\u5c31\u66f4\u4e0d\u8981\u63d0\u901a\u8fc7\u4e00\u4e9b\u63d2\u4ef6\u5907\u4efd\u7f51\u7ad9\uff0c\u505a\u5927\u91cf\u7684\u6587\u7ae0\u66f4\u65b0\uff0c\u4ee5\u53ca\u91c7\u96c6\u7b49\uff0c\u5982\u679c\u670d\u52a1\u5668\u914d\u7f6e\u5f88\u4f4e\uff0c\u751a\u81f3\u91c7\u96c6\u4e00\u7bc7\u6587\u7ae0\u5341\u51e0\u5f20\u56fe\u7247\u5c31\u80fd\u77ac\u95f4\u8ba9\u4f60\u7684\u5185\u5b58\u8dd1\u6ee1\u5bfc\u81f4\u670d\u52a1\u5668\u5f7b\u5e95\u5361\u6b7b\uff01\u5f53\u7136\u5bfc\u81f4\u8fd9\u79cd\u95ee\u9898\u9664\u4e86\u670d\u52a1\u5668\u914d\u7f6e\u4e0d\u591f\u8fd8\u8ddf\u4f60\u8bbe\u7f6e\u4e0d\u5f53\u6240\u5bfc\u81f4\u6709\u5173\uff0c\u6bd4\u5982MySQL<\/span>\u3001php\u7b49\u6027\u80fd\u8bbe\u7f6e\uff01\u5f53\u7136\u4eca\u5929\u8ba8\u8bba\u7684\u4e3b\u9898\u5e76\u4e0d\u662f\u8fd9\u3002<\/p>\n

\u867d\u7136ZBlog\u53ef\u4ee5\u901a\u8fc7\u7f13\u5b58\u51cf\u8f7b\u6570\u636e\u5e93\u8d1f\u62c5\uff0c\u4f46\u662f\u5f53\u4f60\u7ba1\u7406\u540e\u53f0\u66f4\u65b0\u6587\u7ae0\u6216\u5176\u4ed6\u64cd\u4f5c\u8fd8\u662f\u4f1a\u4e0d\u53ef\u907f\u514d\u7684\u8bf7\u6c42\u6570\u636e\u5e93\uff0c\u7279\u522b\u662fZBlog\u8fd9\u79cd\u8d8a\u6765\u8d8a\u81c3\u80bf\u7684\u7a0b\u5e8f\uff0c\u4e14\u907f\u514d\u4e0d\u4e86\u4e00\u4e9b\u4eba\u6076\u610f\u7684\u8bf7\u6c42\u4ee5\u53ca\u5783\u573e\u8718\u86db\u7684\u6076\u610f\u722c\u53d6\uff0c\u5bfc\u81f4\u6570\u636e\u5e93\u4fdd\u62a4\u6027\u6682\u505c\u3002<\/p>\n

\u5f53\u7136\u8fd9\u91cc\u662f\u63a8\u8350\u4f60\u66f4\u6362\u66f4\u9ad8\u914d\u7f6e\u7684\u670d\u52a1\u5668\uff0c\u5982\u679c\u4f60\u4e0d\u6253\u7b97\u66f4\u6362\u53ef\u4ee5\u8003\u8651\u4e00\u4e0b\u65b9\u6cd5\u89e3\u51b3\u5b9d\u5854\u9762\u677f\u6570\u636e\u5e93\u81ea\u52a8\u505c\u6b62\u7684\u95ee\u9898\uff01<\/p>\n

\u51fa\u73b0\u6570\u636e\u5e93\u7ecf\u5e38\u505c\u6b62\u53ef\u4ee5\u53c2\u7167\u4e0b\u9762\u89e3\u51b3\u65b9\u6848\uff1a<\/p>\n

\u89e3\u51b3\u65b9\u6cd5\u4e00\uff1a<\/p>\n

\u5b89\u88c5\u5b9d\u5854\u9762\u677f\u3010linux<\/span>\u5de5\u5177\u7bb1\u3011<\/p>\n

\n
<\/div>\n<\/figure>\n
\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n<\/figure>\n

\u6dfb\u52a0\u8bbe\u7f6eSWAP\u5927\u5c0f\uff0c\u6839\u636e\u4f60\u7684\u5b9e\u9645\u5185\u5b58\u8fdb\u884c\u8c03\u6574\uff0cswap\u662fLinux\u4e0b\u7684\u865a\u62df\u5185\u5b58\uff0c\u8bbe\u7f6e\u9002\u5f53\u7684swap\u53ef\u589e\u52a0\u670d\u52a1\u5668\u7a33\u5b9a\u6027\uff0c\u5efa\u8baeswap\u5bb9\u91cf\u5728\u771f\u5b9e\u5185\u5b58\u5bb9\u91cf\u76841.5\u500d\u5de6\u53f3\uff0c\u82e5\u60a8\u7684\u670d\u52a1\u5668\u5185\u5b58\u5927\u4e8e4GB\uff0c\u53ef\u8bbe1-2GB\u7684\u56fa\u5b9a\u503c\uff0cswap\u6587\u4ef6\u9ed8\u8ba4\u4fdd\u5b58\u5728\/www\/swap\uff0c\u8bbe\u7f6e\u524d\u8bf7\u786e\u4fdd\u78c1\u76d8\u7a7a\u95f4\u591f\u7528\u3002<\/p>\n

\u5728\u8fd9\u91cc\u6ce8\u610f \uff1aOVZ\u865a\u62df\u67b6\u6784\u673a\u5668\u4e0d\u53ef\u7528\u6b64\u529f\u80fd<\/p>\n

\u89e3\u51b3\u65b9\u6cd5\u4e8c\uff1a<\/p>\n

\u6839\u636e\u4f60\u7684\u5b9e\u9645\u5185\u5b58\u8fdb\u884cmysql\u4f18\u5316<\/p>\n

\n
<\/div>\n<\/figure>\n

\u89e3\u51b3\u65b9\u6cd5\u4e09\uff1a<\/p>\n

\u4e0a\u4e2a\u6587\u7ae0\u8bb2\uff0c\u4f46\u662f\u4e0d\u79d1\u5b66\uff0c\u65e0\u7f18\u65e0\u6545\u5c31\u53bb\u542f\u52a8\u6570\u636e\u5e93 \u5e94\u8be5\u5148\u6dfb\u52a0\u4e00\u4e2a\u68c0\u6d4b \u786e\u5b9a\u6570\u636e\u5e93\u505c\u6b62 \u5728\u53bb\u542f\u52a8<\/p>\n

\u5b9d\u5854\u7248\u9762\u5185\u5b58\u592a\u5c0f\uff0c\u673a\u5668\u7ecf\u5e38\u6570\u636e\u5e93\u81ea\u5df1\u505c\u6b62\uff0c\u6dfb\u52a0\u4e00\u4e2a\u81ea\u52a8\u6570\u636e\u5e93\u4efb\u52a1\u518d\u8bd5\u8bd5\uff1f<\/a><\/p>\n

\u767b\u9646\u5b9d\u5854\u540e\u53f0-\u8ba1\u5212\u4efb\u52a1-\u6dfb\u52a0Mysql\u5b88\u62a4\uff0c\u6267\u884c\u5468\u671f\uff0c\u53ef\u9009\u62e9\u591a\u957f\u65f6\u95f4\u6267\u884c\u4e00\u6b21\uff0c\u6bd4\u598210\u5206\u949f\u76d1\u63a7\u6267\u884c\u4e00\u6b21\uff0c\u5177\u4f53\u7684\u5468\u671f\u8bf7\u7ad9\u957f\u6839\u636e\u81ea\u5df1\u670d\u52a1\u5668\u5b9e\u9645\u60c5\u51b5\u6765\u8bbe\u7f6e\u3002<\/p>\n

\u4f46\u662f\u6211\u53d1\u73b0\u8fd9\u4e2a\u811a\u672c\u8bef\u5bfc\u4e86\u5f88\u591a\u4eba\uff0c\u8fd9\u4e2a\u811a\u672c\u53ea\u80fd\u5b9a\u65f6\u81ea\u52a8\u91cd\u542f\u5728\u8fd0\u884c\u4e2d\u7684\u6570\u636e\u5e93\u3002\u7f13\u51cf\u6570\u636e\u5e93\u7684\u538b\u529b\uff0c\u5982\u679c\u6570\u636e\u5e93\u5df2\u7ecf\u505c\u6b62\uff0c\u8fd8\u662f\u53ea\u80fd\u624b\u52a8\u6267\u884c\u624d\u884c\uff0c\u65e0\u6cd5\u81ea\u52a8\u5c06\u5df2\u505c\u6b62\u7684\u6570\u636e\u5e93\u91cd\u542f\uff01<\/p>\n

\n
\n
\n
\u4ee3\u7801\u8bed\u8a00\uff1a<\/span>javascript<\/div>\n<\/div>\n
\n
<\/i>\u590d\u5236<\/span><\/div>\n<\/div>\n<\/div>\n
\n
pgrep -<\/span>x mysqld &<\/span>><\/span> \/<\/span>dev\/<\/span>nullif [<\/span> $?<\/span> -<\/span>ne 0<\/span> ]<\/span>;<\/span>thenbash \/<\/span>www\/<\/span>server\/<\/span>panel\/<\/span>script\/<\/span>rememory.<\/span>sh\/<\/span>etc\/<\/span>init.<\/span>d\/<\/span>mysqld startfi<\/code><\/pre>\n<\/div>\n<\/div>\n
\u60f3\u8981\u81ea\u52a8\u68c0\u6d4b\u6570\u636e\u5e93\u662f\u5426\u505c\u6b62\uff0c\u5982\u679c\u68c0\u6d4b\u5230\u6570\u636e\u5e93\u505c\u6b62\uff0c\u81ea\u52a8\u91cd\u542f\uff01\u4e0b\u9762\u8fd9\u6bb5\u811a\u672c\u624d\u662f\u6b63\u786e\u7684\uff01<\/p>\n
\n
\n
\n
\u4ee3\u7801\u8bed\u8a00\uff1a<\/span>javascript<\/div>\n<\/div>\n
\n
<\/i>\u590d\u5236<\/span><\/div>\n<\/div>\n<\/div>\n
\n
#!\/bin\/bash PATH=\/bin:\/sbin:\/usr\/bin:\/usr\/sbin:\/usr\/local\/bin:\/usr\/local\/sbin:~\/bin export PATH pgrep -x mysqld \/dev\/null if [ $? -ne 0 ] echo At time:$(date) :MySQL is stop . \/var\/log\/mysql_messages service mysqld start fi<\/span><\/code><\/pre>\n<\/div>\n<\/div>\n
\n
<\/div>\n<\/figure>\n
\u6267\u884c\u5468\u671f\u6211\u8bbe\u7f6e\u76841\u5206\u949f\u68c0\u6d4b\u4e00\u6b21\uff0c\u4e5f\u5c31\u5f53\u4f60\u6570\u636e\u5e93\u505c\u6b62\u540e\uff0c1\u5206\u949f\u4f1a\u91cd\u542f\uff0c\u7f51\u7ad9\u53ef\u4ee5\u6b63\u5e38\u8bbf\u95ee\u4e86\uff01\u4e2a\u4eba\u89c9\u5f97\u8fd9\u4e2a\u811a\u672c\u7684\u6267\u884c\u5468\u671f\u53ef\u4ee5\u8bbe\u7f6e\u77ed\u4e00\u70b9\u3002<\/p>\n
\u4e24\u4e2a\u8ba1\u5212\u811a\u672c\u5efa\u8bae\u5206\u522b\u90fd\u6dfb\u52a0\u4e0a\uff0c\u4f46\u662f\u8981\u6ce8\u610f\u7684\u4e00\u70b9\uff0c\u672c\u6587\u4e2d\u7684\u7b2c\u4e00\u4e2a\u811a\u672c\u6267\u884c\u5468\u671f\u65f6\u95f4\u4e0d\u5efa\u8bae\u8bbe\u7f6e\u7684\u8fc7\u5c0f\uff0c10\u5206\u949f\u5373\u53ef\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u811a\u672c\u65f6\u95f4\u8bbe\u7f6e\u8fc7\u77ed\uff0c\u5f53\u4f60\u624d\u540e\u53f0\u66f4\u65b0\u6587\u7ae0\u6216\u8005\u5347\u7ea7\u7f51\u7ad9\u7a0b\u5e8f\u65f6\u53ef\u80fd\u4f1a\u9020\u6210\u9519\u8bef\uff01<\/p>\n
\u89e3\u51b3\u65b9\u6cd5\u56db\uff1a<\/p>\n
\u8fd9\u4e2a\u65b9\u6cd5\u7b80\u5355\u7c97\u66b4\uff0c\u9002\u5408\u571f\u8c6a\u7ad9\u957f\uff0c\u76f4\u63a5\u589e\u52a0\u670d\u52a1\u5668\u5185\u5b58\u6216\u4f7f\u7528\u4e91\u6570\u636e\u5e93<\/a>\uff0c\u628a\u6570\u636e\u5e93\u5206\u79bb\u51fa\u53bb\u3002<\/p>\n
\u5bfc\u81f4\u6570\u636e\u5e93\u81ea\u52a8\u6682\u505c\u662f\u591a\u65b9\u9762\u7684\uff0c\u8fd9\u7bc7\u6587\u7684\u65b9\u6cd5\u5e76\u6ca1\u6709\u4ece\u6839\u672c\u4e0a\u89e3\u51b3\u8fd9\u4e2a\u95ee\u9898\uff0c\u800c\u662f\u5c3d\u91cf\u51cf\u5c11\u6570\u636e\u5e93\u5bfc\u81f4\u7f51\u7ad9\u957f\u65f6\u95f4\u65e0\u6cd5\u6b63\u5e38\uff0c\u5982\u679c\u4f60\u7684\u6570\u636e\u5e93\u4e00\u4e2a\u661f\u671f\u53ea\u662f3-4\u6b21\u81ea\u5b9a\u505c\u6b62\uff0c\u901a\u8fc7\u8fd9\u4e2a\u53ef\u4ee5\u6709\u6548\u89e3\u51b3\uff0c\u5bf9seo\u4f18\u5316\u548c\u7528\u6237\u4f53\u9a8c\u4e5f\u4e0d\u4f1a\u6709\u592a\u5927\u5f71\u54cd\uff01<\/p>\n
\u5982\u679c\u7ecf\u5e38\u6027\u7684\u4e00\u5929\u6570\u636e\u5e93\u5c31\u505c\u6b62\u597d\u51e0\u6b21\uff0c\u90a3\u4e48\u5c31\u662f\u5b9d\u5854\u8bbe\u7f6e\u6709\u95ee\u9898\u4e86\uff0c\u8bf7\u68c0\u67e5\u4f60\u7684\u5b9d\u5854\u8bbe\u7f6e\u662f\u5426\u6709\u5b89\u5168\u95ee\u9898\uff0c\u4ee5\u53ca\u6570\u636e\u5e93\u914d\u7f6e\u548cphp\u7248\u672c\u8bbe\u7f6e\u662f\u5426\u5f97\u5f53\uff0c\u7ecf\u5e38\u770b\u770b\u65e5\u5fd7\u662f\u5426\u6709\u6076\u610f\u8bf7\u6c42\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\ud83d\udd16\u4e00\u53e5\u8bdd\u63cf\u8ff0: \u670d\u52a1\u5668\u5185\u5b58\u4e0d\u8db3\u5bfc\u81f4\u5b9d\u5854\u9762\u677f\u6570\u636e\u5e93\u7ecf\u5e38\u6027\u81ea\u52a8\u505c\u6b62\uff0c\u7279\u522b\u662fZBlog\u7a0b\u5e8f\u9891\u7e41\u8bf7\u6c42\u6570\u636e\u5e93\u3002\u89e3\u51b3\u65b9\u6cd5\u5305 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[48],"class_list":["post-488","post","type-post","status-publish","format-standard","hentry","category-100","tag-48"],"_links":{"self":[{"href":"https:\/\/sharebits.link\/index.php?rest_route=\/wp\/v2\/posts\/488","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sharebits.link\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sharebits.link\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sharebits.link\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sharebits.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=488"}],"version-history":[{"count":0,"href":"https:\/\/sharebits.link\/index.php?rest_route=\/wp\/v2\/posts\/488\/revisions"}],"wp:attachment":[{"href":"https:\/\/sharebits.link\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sharebits.link\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sharebits.link\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}