{"id":788,"date":"2020-02-24T21:52:26","date_gmt":"2020-02-24T12:52:26","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=788"},"modified":"2020-12-31T23:51:59","modified_gmt":"2020-12-31T14:51:59","slug":"mysql-%ec%9d%bc%ec%a0%95-%ea%b8%b0%ea%b0%84%eb%8f%99%ec%95%88-%ec%82%ac%ec%9a%a9%ed%95%98%ec%a7%80-%ec%95%8a%ec%9d%80-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a6%ac%ec%8a%a4%ed%8a%b8-%ea%b0%80%ec%a0%b8","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=788","title":{"rendered":"MySQL \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8 \uac00\uc838\uc624\uae30"},"content":{"rendered":"\n<p>DB\ub97c \uc6b4\uc601\ud558\ub2e4 \ubcf4\uba74 \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \ud14c\uc774\ube14\ub4e4\uc774 \uc313\uc5ec\uac00\uace0 \ub098\uc911\uc5d0\ub294 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ud14c\uc774\ube14\ub4e4\ub3c4 \ub9ce\uc774 \uc0dd\uae30\uae30 \ub9c8\ub828\uc774\ub2e4. (\uad00\ub9ac\ub97c \uc81c\ub300\ub85c \uc548 \ud588\ub2e4\ub294 \uc99d\uac70&#8230;?! _-_)<br><br>\uc554\ud2bc \uadf8\ub7f4 \uacbd\uc6b0 \ubb34\ud131\ub300\uace0 \ud14c\uc774\ube14\uc744 \uc815\ub9ac\ud560 \uc21c \uc5c6\uc73c\ub2c8 \uc77c\uc815\ud55c \uae30\uc900\uc744 \uac00\uc9c0\uace0 \uc815\ub9ac\ud558\uac8c \ub41c\ub2e4.<\/p>\n\n\n\n<p>\uc77c\uc815 \uae30\uac04 \uc774\ub0b4\uc5d0 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub2e4\uba74 \uc815\ub9ac\ud558\ub294\uac8c \ub354 \uc218\uc6d4\ud574 \uc9c0\uc9c0 \uc54a\uc744\uae4c?<\/p>\n\n\n\n<p>\ub2e4\uc74c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc77c\uc815 \uae30\uac04 \ub0b4\uc5d0 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8\ub97c \uac00\uc838\uc62c \uc218 \uc788\ub2e4.<br>DB\uba85\uc744 \uc790\uc2e0\uc758 DB\uba85\uc73c\ub85c \ubcc0\uacbd\ud558\uace0 \uc2e4\ud589\ud558\uba74 30\uc77c \uc774\ub0b4\uc5d0 \ud55c\ubc88\ub3c4 \uc5c5\ub370\uc774\ud2b8 \ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8\ub97c \uc5bb\uc744 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<p>\ubc18\ub300\ub85c 30\uc77c \uc774\ub0b4\uc5d0 \uc5c5\ub370\uc774\ud2b8 \ub41c \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8\ub97c \uc5bb\uc73c\ub824\uba74?<br>\uc544\ub798 \ucffc\ub9ac\ubb38\uc758 not in \uc744 in\uc73c\ub85c\ub9cc \ubcc0\uacbd\ud574 \uc8fc\uba74 \ub41c\ub2e4.<\/p>\n\n\n\n<p class=\"has-very-light-gray-background-color has-background\">select table_name, count(*) as cnt<br>from information_schema.columns<br>where TABLE_SCHEMA = &#8216;DB\uba85&#8217;<br>  and table_name <strong>not in<\/strong> (select table_name<br>                     from information_schema.tables<br>                     where table_schema = &#8216;DB\uba85&#8217;<br>                       and engine is not null<br>                       and (update_time &gt; (now() &#8211; interval 30 day)))<br>group by TABLE_NAME<br>order by cnt desc;<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\ub97c \uc6b4\uc601\ud558\ub2e4 \ubcf4\uba74 \uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \ud14c\uc774\ube14\ub4e4\uc774 \uc313\uc5ec\uac00\uace0 \ub098\uc911\uc5d0\ub294 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ud14c\uc774\ube14\ub4e4\ub3c4 \ub9ce\uc774 \uc0dd\uae30\uae30 \ub9c8\ub828\uc774\ub2e4. (\uad00\ub9ac\ub97c \uc81c\ub300\ub85c \uc548 \ud588\ub2e4\ub294 \uc99d\uac70&#8230;?! _-_) \uc554\ud2bc \uadf8\ub7f4 \uacbd\uc6b0 \ubb34\ud131\ub300\uace0 \ud14c\uc774\ube14\uc744 \uc815\ub9ac\ud560 \uc21c \uc5c6\uc73c\ub2c8 \uc77c\uc815\ud55c \uae30\uc900\uc744 \uac00\uc9c0\uace0 \uc815\ub9ac\ud558\uac8c \ub41c\ub2e4. \uc77c\uc815 \uae30\uac04 \uc774\ub0b4\uc5d0 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc740 \ud14c\uc774\ube14 \ubaa9\ub85d\uc744 \uac00\uc838\uc62c \uc218 \uc788\ub2e4\uba74 \uc815\ub9ac\ud558\ub294\uac8c \ub354 \uc218\uc6d4\ud574 \uc9c0\uc9c0 \uc54a\uc744\uae4c? \ub2e4\uc74c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uba74 \uc77c\uc815 \uae30\uac04 \ub0b4\uc5d0 &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,19],"tags":[],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/788"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=788"}],"version-history":[{"count":3,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/788\/revisions"}],"predecessor-version":[{"id":1758,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/788\/revisions\/1758"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=788"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=788"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=788"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}