{"id":1808,"date":"2013-04-19T13:02:51","date_gmt":"2013-04-19T05:02:51","guid":{"rendered":"http:\/\/www.slyar.com\/blog\/?p=1808"},"modified":"2022-07-03T15:55:39","modified_gmt":"2022-07-03T22:55:39","slug":"mysql-err-logs-disk-full","status":"publish","type":"post","link":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html","title":{"rendered":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7)"},"content":{"rendered":"<p>\u6587\u7ae0\u4f5c\u8005\uff1a<span style=\"color: #0000ff;\">\u59dc\u5357(Slyar) <\/span>\u6587\u7ae0\u6765\u6e90\uff1aSlyar Home (<a title=\"Slyar\" href=\"http:\/\/www.slyar.com\" target=\"_blank\" rel=\"noopener\">www.slyar.com<\/a>) \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff0c\u8c22\u8c22\u5408\u4f5c\u3002<\/p>\n<p>\u4eca\u5929\u6536\u5230\u76d1\u63a7\u90ae\u4ef6\u8bf4\u535a\u5ba2\u8bbf\u95ee\u5931\u8d25\u3002\u6253\u5f00\u9875\u9762\u4e00\u770b\uff0c\u7855\u5927\u7684502 Bad Gateway\uff0cping\u4e86\u4e00\u4e0bVPS\u53d1\u73b0\u662f\u901a\u7684\uff0cSSH\u8fde\u63a5\u4e0a\u53bb\u770b\u4e86\u4e0bNginx\u65e5\u5fd7\u53d1\u73b0\u6ca1\u95ee\u9898\uff0c\u91cd\u542flnmp\u7684\u65f6\u5019\u53d1\u73b0Mysql\u8d77\u4e0d\u6765\uff0c\u95ee\u9898\u6e90\u5934\u57fa\u672c\u627e\u5230\u3002<\/p>\n<pre class=\"lang:sh decode:true \" >tail \/usr\/local\/mysql\/var\/slyar.err<\/pre>\n<p>\u770b\u4e86\u4e00\u4e0bMysql\u7684\u9519\u8bef\u65e5\u5fd7\uff0c\u610f\u5916\u72b6\u51b5\u51fa\u73b0\u3002\u3002\u3002<\/p>\n<p>Disk is full writing '.\/mysql-bin.~rec~' (Errcode: 28). Waiting for someone to free space... (Expect up to 60 secs delay for server to continue after freeing disk space)<\/p>\n<p>\u795e\u5947\u7684\u60c5\u51b5\uff0c\u5c45\u7136\u662f\u56e0\u4e3a\u78c1\u76d8\u6ee1\u4e86\u65e0\u6cd5\u5199\u5165\u65e5\u5fd7\u5bfc\u81f4Mysql\u8d77\u4e0d\u6765<\/p>\n<pre class=\"lang:sh decode:true \" >root@slyar# df \/\r\nFilesystem 1K-blocks Used Available Use% Mounted on\r\n\/dev\/sda1 3016688 2877540 0 100% \/<\/pre>\n<p>\u679c\u7136\u554a\uff0c\/var\u76ee\u5f55\u7206\u4e86<\/p>\n<pre class=\"lang:sh decode:true \" >root@slyar:\/usr\/local\/mysql\/var# ll --block-size=MB\r\ntotal 504MB\r\n-rw-rw---- 1 mysql mysql 26MB Jul 23 2012 mysql-bin.000011\r\n-rw-rw---- 1 mysql mysql 5MB Jul 26 2012 mysql-bin.000012\r\n-rw-rw---- 1 mysql mysql 27MB Aug 8 2012 mysql-bin.000013\r\n-rw-rw---- 1 mysql mysql 43MB Aug 23 2012 mysql-bin.000014\r\n-rw-rw---- 1 mysql mysql 270MB Feb 9 17:05 mysql-bin.000020\r\n-rw-rw---- 1 mysql mysql 115MB Apr 19 12:27 mysql-bin.000021\r\n-rw-rw---- 1 mysql mysql 1MB Feb 10 12:07 mysql-bin.index\r\n-rw-rw---- 1 mysql mysql 0MB Apr 19 12:34 mysql-bin.~rec~<\/pre>\n<p>\u8fd9\u4e9b\u6587\u4ef6\u662fMySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7(Binary Log)\uff0c\u4e3b\u8981\u7528\u4e8e\u8bb0\u5f55MySQL\u6240\u6709\u7684\u64cd\u4f5c\uff0c\u5f53\u7136\u66f4\u4e3b\u8981\u662f\u573a\u666f\u662f\u7528\u4e8e\u4e3b\u4ece\u670d\u52a1\u5668\u3002\u4e3b\u670d\u52a1\u5668\u7528\u4e8c\u8fdb\u5236\u64cd\u4f5c\u8bb0\u5f55\u6240\u6709\u9700\u8981\u4f20\u9012\u7ed9\u4ece\u5c5e\u670d\u52a1\u5668\u7684SQL\u8bed\u53e5\uff0c\u5bf9\u4e8e\u6211\u6765\u8bf4\u53ea\u6709\u4e00\u4e2a\u4e3b\u670d\u52a1\u5668\uff0c\u6240\u4ee5\u6211\u4e0d\u9700\u8981\u8fd9\u4e2a\u4e8c\u8fdb\u5236\u65e5\u5386\uff0c\u5220<\/p>\n<p>\u4e00\u53e5\u8bdd\u6e05\u7a7a\u6240\u6709\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7<\/p>\n<pre class=\"lang:mysql decode:true \" >mysql&gt;reset master; <\/pre>\n<p>\u6307\u5b9a\u5220\u9664\u67d0\u4e2a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6<\/p>\n<pre class=\"lang:default decode:true \" >mysql&gt;purge binary logs to 'binlog.000001';<\/pre>\n<p>\u66f4\u591a\u547d\u4ee4\u7528help\u67e5\u770b\u5427<\/p>\n<p>\u4e3a\u4e86\u9632\u6b62\u518d\u6b21\u51fa\u73b0\u6b64\u7c7b\u72b6\u51b5\uff0c\u76f4\u63a5\u5173\u95edMysql\u7684log-bin\u65e5\u5fd7\u529f\u80fd<\/p>\n<pre class=\"lang:vim decode:true \" >vim \/etc\/my.cnf<\/pre>\n<p>\u6ce8\u89c6\u6389\u4e0b\u97622\u884c\u5373\u53ef\uff1a<\/p>\n<pre class=\"lang:vim decode:true \" >log-bin=mysql-bin\r\nbinlog_format=mixed<\/pre>\n<p>\u6700\u540e\u91cd\u542fmysql\u670d\u52a1\u5668<\/p>\n<pre class=\"lang:sh decode:true \" >service mysql restart<\/pre>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"http:\/\/www.slyar.com\/blog\">Slyar Home<\/a> &raquo; <a href=\"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html\">\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7)<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u4f5c\u8005\uff1a\u59dc\u5357(Slyar) \u6587\u7ae0\u6765\u6e90\uff1aSlyar Home (www.slyar.com) \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff0c\u8c22\u8c22\u5408\u4f5c\u3002 \u4eca\u5929\u6536\u5230\u76d1\u63a7\u90ae\u4ef6\u8bf4\u535a\u5ba2\u8bbf\u95ee\u5931\u8d25\u3002\u6253\u5f00\u9875\u9762\u4e00\u770b\uff0c\u7855\u5927\u7684502 Bad Gateway\uff0cping\u4e86\u4e00\u4e0bVPS\u53d1\u73b0\u662f\u901a\u7684\uff0cSSH\u8fde\u63a5\u4e0a\u53bb\u770b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[285],"class_list":["post-1808","post","type-post","status-publish","format-standard","hentry","category-computer","tag-mysql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Slyar\"\/>\n\t<meta name=\"keywords\" content=\"slyar,mysql,502,\u9519\u8bef,\u65e0\u6cd5\u542f\u52a8,\u78c1\u76d8,\u7a7a\u95f4,\u5360\u6ee1,\u65e5\u5fd7,\u5173\u95ed,\u542f\u52a8,\u91cd\u542f,\u670d\u52a1\" \/>\n\t<link rel=\"canonical\" href=\"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_CN\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Slyar Home | \u8bb0\u5f55\u4e2a\u4eba\u751f\u6d3b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home\" \/>\n\t\t<meta property=\"og:description\" content=\"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002\" \/>\n\t\t<meta property=\"og:url\" content=\"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2013-04-19T05:02:51+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-07-03T22:55:39+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#article\",\"name\":\"\\u89e3\\u51b3\\u7531\\u4e8e\\u65e5\\u5fd7\\u5360\\u6ee1\\u7a7a\\u95f4\\u5bfc\\u81f4\\u7684MySQL\\u65e0\\u6cd5\\u542f\\u52a8\\u95ee\\u9898(MySQL \\u4e8c\\u8fdb\\u5236\\u65e5\\u5fd7) - Slyar Home\",\"headline\":\"\\u89e3\\u51b3\\u7531\\u4e8e\\u65e5\\u5fd7\\u5360\\u6ee1\\u7a7a\\u95f4\\u5bfc\\u81f4\\u7684MySQL\\u65e0\\u6cd5\\u542f\\u52a8\\u95ee\\u9898(MySQL \\u4e8c\\u8fdb\\u5236\\u65e5\\u5fd7)\",\"author\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/author\\\/slyar#author\"},\"publisher\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid\",\"width\":96,\"height\":96,\"caption\":\"Slyar\"},\"datePublished\":\"2013-04-19T13:02:51-07:00\",\"dateModified\":\"2022-07-03T15:55:39-07:00\",\"inLanguage\":\"zh-CN\",\"commentCount\":6,\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#webpage\"},\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#webpage\"},\"articleSection\":\"\\u7cfb\\u7edf\\u6280\\u5de7, MySQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/category\\\/computer#listItem\",\"name\":\"\\u7cfb\\u7edf\\u6280\\u5de7\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/category\\\/computer#listItem\",\"position\":2,\"name\":\"\\u7cfb\\u7edf\\u6280\\u5de7\",\"item\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/category\\\/computer\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#listItem\",\"name\":\"\\u89e3\\u51b3\\u7531\\u4e8e\\u65e5\\u5fd7\\u5360\\u6ee1\\u7a7a\\u95f4\\u5bfc\\u81f4\\u7684MySQL\\u65e0\\u6cd5\\u542f\\u52a8\\u95ee\\u9898(MySQL \\u4e8c\\u8fdb\\u5236\\u65e5\\u5fd7)\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#listItem\",\"position\":3,\"name\":\"\\u89e3\\u51b3\\u7531\\u4e8e\\u65e5\\u5fd7\\u5360\\u6ee1\\u7a7a\\u95f4\\u5bfc\\u81f4\\u7684MySQL\\u65e0\\u6cd5\\u542f\\u52a8\\u95ee\\u9898(MySQL \\u4e8c\\u8fdb\\u5236\\u65e5\\u5fd7)\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/category\\\/computer#listItem\",\"name\":\"\\u7cfb\\u7edf\\u6280\\u5de7\"}}]},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#person\",\"name\":\"Slyar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid\",\"width\":96,\"height\":96,\"caption\":\"Slyar\"}},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/author\\\/slyar#author\",\"url\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/author\\\/slyar\",\"name\":\"Slyar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid\",\"width\":96,\"height\":96,\"caption\":\"Slyar\"}},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#webpage\",\"url\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html\",\"name\":\"\\u89e3\\u51b3\\u7531\\u4e8e\\u65e5\\u5fd7\\u5360\\u6ee1\\u7a7a\\u95f4\\u5bfc\\u81f4\\u7684MySQL\\u65e0\\u6cd5\\u542f\\u52a8\\u95ee\\u9898(MySQL \\u4e8c\\u8fdb\\u5236\\u65e5\\u5fd7) - Slyar Home\",\"description\":\"\\u670d\\u52a1\\u5668\\u51fa\\u73b0502 Bad Gateway\\u9519\\u8bef\\u65e0\\u6cd5\\u8bbf\\u95ee\\uff0c\\u7ecf\\u67e5\\u662fMysql\\u7684\\u65e5\\u5fd7\\u6587\\u4ef6\\u5360\\u6ee1\\u78c1\\u76d8\\u7a7a\\u95f4\\u5bfc\\u81f4\\uff0c\\u5220\\u9664\\u65e5\\u5fd7\\u6587\\u4ef6\\u5e76\\u7981\\u7528\\u65e5\\u5fd7\\u8bb0\\u5f55\\u529f\\u80fd\\uff0c\\u670d\\u52a1\\u5668\\u6062\\u590d\\u3002\",\"inLanguage\":\"zh-CN\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/mysql-err-logs-disk-full.html#breadcrumblist\"},\"author\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/author\\\/slyar#author\"},\"creator\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/author\\\/slyar#author\"},\"datePublished\":\"2013-04-19T13:02:51-07:00\",\"dateModified\":\"2022-07-03T15:55:39-07:00\"},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#website\",\"url\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/\",\"name\":\"Slyar Home\",\"description\":\"\\u8bb0\\u5f55\\u4e2a\\u4eba\\u751f\\u6d3b\",\"inLanguage\":\"zh-CN\",\"publisher\":{\"@id\":\"http:\\\/\\\/www.slyar.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home","description":"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002","canonical_url":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html","robots":"max-image-preview:large","keywords":"slyar,mysql,502,\u9519\u8bef,\u65e0\u6cd5\u542f\u52a8,\u78c1\u76d8,\u7a7a\u95f4,\u5360\u6ee1,\u65e5\u5fd7,\u5173\u95ed,\u542f\u52a8,\u91cd\u542f,\u670d\u52a1","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#article","name":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home","headline":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7)","author":{"@id":"http:\/\/www.slyar.com\/blog\/author\/slyar#author"},"publisher":{"@id":"http:\/\/www.slyar.com\/blog\/#person"},"image":{"@type":"ImageObject","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid","width":96,"height":96,"caption":"Slyar"},"datePublished":"2013-04-19T13:02:51-07:00","dateModified":"2022-07-03T15:55:39-07:00","inLanguage":"zh-CN","commentCount":6,"mainEntityOfPage":{"@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#webpage"},"isPartOf":{"@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#webpage"},"articleSection":"\u7cfb\u7edf\u6280\u5de7, MySQL"},{"@type":"BreadcrumbList","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/#listItem","position":1,"name":"Home","item":"http:\/\/www.slyar.com\/blog\/","nextItem":{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/category\/computer#listItem","name":"\u7cfb\u7edf\u6280\u5de7"}},{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/category\/computer#listItem","position":2,"name":"\u7cfb\u7edf\u6280\u5de7","item":"http:\/\/www.slyar.com\/blog\/category\/computer","nextItem":{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#listItem","name":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7)"},"previousItem":{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#listItem","position":3,"name":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7)","previousItem":{"@type":"ListItem","@id":"http:\/\/www.slyar.com\/blog\/category\/computer#listItem","name":"\u7cfb\u7edf\u6280\u5de7"}}]},{"@type":"Person","@id":"http:\/\/www.slyar.com\/blog\/#person","name":"Slyar","image":{"@type":"ImageObject","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid","width":96,"height":96,"caption":"Slyar"}},{"@type":"Person","@id":"http:\/\/www.slyar.com\/blog\/author\/slyar#author","url":"http:\/\/www.slyar.com\/blog\/author\/slyar","name":"Slyar","image":{"@type":"ImageObject","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/fa995532c4fa6a1a16430db283689338da430a677b2ff974e0cad68e3bba05c4?s=96&d=monsterid","width":96,"height":96,"caption":"Slyar"}},{"@type":"WebPage","@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#webpage","url":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html","name":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home","description":"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002","inLanguage":"zh-CN","isPartOf":{"@id":"http:\/\/www.slyar.com\/blog\/#website"},"breadcrumb":{"@id":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html#breadcrumblist"},"author":{"@id":"http:\/\/www.slyar.com\/blog\/author\/slyar#author"},"creator":{"@id":"http:\/\/www.slyar.com\/blog\/author\/slyar#author"},"datePublished":"2013-04-19T13:02:51-07:00","dateModified":"2022-07-03T15:55:39-07:00"},{"@type":"WebSite","@id":"http:\/\/www.slyar.com\/blog\/#website","url":"http:\/\/www.slyar.com\/blog\/","name":"Slyar Home","description":"\u8bb0\u5f55\u4e2a\u4eba\u751f\u6d3b","inLanguage":"zh-CN","publisher":{"@id":"http:\/\/www.slyar.com\/blog\/#person"}}]},"og:locale":"zh_CN","og:site_name":"Slyar Home | \u8bb0\u5f55\u4e2a\u4eba\u751f\u6d3b","og:type":"article","og:title":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home","og:description":"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002","og:url":"http:\/\/www.slyar.com\/blog\/mysql-err-logs-disk-full.html","article:published_time":"2013-04-19T05:02:51+00:00","article:modified_time":"2022-07-03T22:55:39+00:00","twitter:card":"summary","twitter:title":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - Slyar Home","twitter:description":"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002"},"aioseo_meta_data":{"post_id":"1808","title":"\u89e3\u51b3\u7531\u4e8e\u65e5\u5fd7\u5360\u6ee1\u7a7a\u95f4\u5bfc\u81f4\u7684MySQL\u65e0\u6cd5\u542f\u52a8\u95ee\u9898(MySQL \u4e8c\u8fdb\u5236\u65e5\u5fd7) - #site_title","description":"\u670d\u52a1\u5668\u51fa\u73b0502 Bad Gateway\u9519\u8bef\u65e0\u6cd5\u8bbf\u95ee\uff0c\u7ecf\u67e5\u662fMysql\u7684\u65e5\u5fd7\u6587\u4ef6\u5360\u6ee1\u78c1\u76d8\u7a7a\u95f4\u5bfc\u81f4\uff0c\u5220\u9664\u65e5\u5fd7\u6587\u4ef6\u5e76\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55\u529f\u80fd\uff0c\u670d\u52a1\u5668\u6062\u590d\u3002","keywords":[{"label":"slyar","value":"slyar"},{"label":"mysql","value":"mysql"},{"label":"502","value":"502"},{"label":"\u9519\u8bef","value":"\u9519\u8bef"},{"label":"\u65e0\u6cd5\u542f\u52a8","value":"\u65e0\u6cd5\u542f\u52a8"},{"label":"\u78c1\u76d8","value":"\u78c1\u76d8"},{"label":"\u7a7a\u95f4","value":"\u7a7a\u95f4"},{"label":"\u5360\u6ee1","value":"\u5360\u6ee1"},{"label":"\u65e5\u5fd7","value":"\u65e5\u5fd7"},{"label":"\u5173\u95ed","value":"\u5173\u95ed"},{"label":"\u542f\u52a8","value":"\u542f\u52a8"},{"label":"\u91cd\u542f","value":"\u91cd\u542f"},{"label":"\u670d\u52a1","value":"\u670d\u52a1"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-02-10 02:49:55","updated":"2022-10-18 19:04:37","seo_analyzer_scan_date":null,"focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"_links":{"self":[{"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/posts\/1808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/comments?post=1808"}],"version-history":[{"count":2,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/posts\/1808\/revisions"}],"predecessor-version":[{"id":8465,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/posts\/1808\/revisions\/8465"}],"wp:attachment":[{"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/media?parent=1808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/categories?post=1808"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.slyar.com\/blog\/wp-json\/wp\/v2\/tags?post=1808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}