{"id":19914,"date":"2018-02-27T11:10:00","date_gmt":"2018-02-27T02:10:00","guid":{"rendered":"http:\/\/w3devlabs.net\/wp\/?p=19914"},"modified":"2018-02-26T21:10:35","modified_gmt":"2018-02-26T12:10:35","slug":"mysql-%ed%85%8c%ec%9d%b4%eb%b8%94-%ed%81%ac%ea%b8%b0-%ed%99%95%ec%9d%b8%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/w3devlabs.net\/wp\/?p=19914","title":{"rendered":"MySQL \ud14c\uc774\ube14 \ud06c\uae30 \ud655\uc778\ud558\uae30"},"content":{"rendered":"

<\/p>\n

MySQL \ud14c\uc774\ube14 \ud06c\uae30 \ud655\uc778\ud558\uae30<\/font><\/span><\/p>\n



<\/p>\n

MySQL\uc5d0\uc11c \ud14c\uc774\ube14 \ud06c\uae30\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \ud14c\uc774\ube14 \ud06c\uae30\ub97c \ud655\uc778\ud574\uc57c\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \ud558\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

MySQL \uc744 \uc124\uce58\ud558\uba74 \uae30\ubcf8\uc73c\ub85c \uc0dd\uae30\ub294 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\ub9ac\uc2a4\ud2b8\uc640 \ud14c\uc774\ube14\ud06c\uae30 \uc778\ub371\uc2a4 \ud06c\uae30\ub97c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

SELECT TABLE_NAME,<\/font><\/span><\/p>\n

       TABLE_ROWS,<\/font><\/span><\/p>\n

       round(DATA_LENGTH\/(1024*1024),2) as ‘TABLE SIZE(MB)’,<\/font><\/span><\/p>\n

       round(INDEX_LENGTH\/(1024*1024),2) as ‘INDEX SIZE(MB)’<\/font><\/span><\/p>\n

  FROM INFORMATION_SCHEMA.TABLES<\/font><\/span><\/p>\n

WHERE TABLE_SCHEMA = ‘mysql’ — \ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85\uc744 \uc785\ub825<\/font><\/span><\/p>\n

GROUP BY TABLE_NAME <\/font><\/span><\/p>\n

ORDER BY DATA_LENGTH DESC <\/font><\/span><\/p>\n



<\/p>\n

\uc704\uc758 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 \uc544\ub798\uc640 \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uc744\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/font><\/span><\/p>\n


<\/p>\n

<\/span><\/p>\n


<\/p>\n

\uc791\uc5c5\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud06c\uae30\ubc0f \ub370\uc774\ud130\uc218\ub97c \ud655\uc778\ud558\ub294\ub370 \uc0ac\uc6a9\ud574\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4. <\/font><\/span><\/p>\n





<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL \ud14c\uc774\ube14 \ud06c\uae30 \ud655\uc778\ud558\uae30 MySQL\uc5d0\uc11c \ud14c\uc774\ube14 \ud06c\uae30\ub97c \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \ud558\ub2e4\ubcf4\uba74 \ud14c\uc774\ube14 \ud06c\uae30\ub97c \ud655\uc778\ud574\uc57c\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f0\uacbd\uc6b0 \uc5b4\ub5bb\uac8c \ud558\ub294\uc9c0 \ud655\uc778\ud574 \ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. MySQL \uc744 \uc124\uce58\ud558\uba74 \uae30\ubcf8\uc73c\ub85c \uc0dd\uae30\ub294 mysql \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\ub9ac\uc2a4\ud2b8\uc640 \ud14c\uc774\ube14\ud06c\uae30 \uc778\ub371\uc2a4 \ud06c\uae30\ub97c \uc54c\uc544\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. SELECT TABLE_NAME,        TABLE_ROWS,        round(DATA_LENGTH\/(1024*1024),2) as ‘TABLE SIZE(MB)’,        round(INDEX_LENGTH\/(1024*1024),2) as ‘INDEX SIZE(MB)’   FROM INFORMATION_SCHEMA.TABLES … <\/p>\n

\ub354 \ubcf4\uae30 “MySQL \ud14c\uc774\ube14 \ud06c\uae30 \ud655\uc778\ud558\uae30”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[5418],"tags":[5417,5291,23676],"class_list":["post-19914","post","type-post","status-publish","format-standard","hentry","category-5418","tag-mysql","tag-5291","tag-23676","entry"],"_links":{"self":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19914","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19914"}],"version-history":[{"count":1,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19914\/revisions"}],"predecessor-version":[{"id":19915,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=\/wp\/v2\/posts\/19914\/revisions\/19915"}],"wp:attachment":[{"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19914"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/w3devlabs.net\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}