{"id":1329,"date":"2020-04-21T17:33:12","date_gmt":"2020-04-21T08:33:12","guid":{"rendered":"http:\/\/sarang.inmu.net\/?p=1329"},"modified":"2020-04-21T17:33:15","modified_gmt":"2020-04-21T08:33:15","slug":"mysql-database-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%9d%84-%eb%aa%a8%ec%a1%b0%eb%a6%ac-%ed%95%9c-%eb%b2%88%ec%97%90-%ec%82%ad%ec%a0%9c","status":"publish","type":"post","link":"https:\/\/sarang.inmu.net\/?p=1329","title":{"rendered":"mysql database \ud14c\uc774\ube14\uc744 \ubaa8\uc870\ub9ac \ud55c \ubc88\uc5d0 \uc0ad\uc81c"},"content":{"rendered":"\n

mysql\uc774\ub098 mariadb\ub97c \uc0ac\uc6a9\ud558\ub2e4\uac00 DB\ub294 \ub0a8\uaca8 \ub450\uace0 \uc548\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\ub9cc \uc0ad\uc81c\ud574\uc57c \ub420 \ub54c\uac00 \uc788\ub2e4. \ud14c\uc774\ube14\uc774 \uba87 \uac1c \uc548\ub418\uba74 drop table ‘\ud14c\uc774\ube14\uc774\ub984’; \uba87 \ubc88 \ud558\uba74 \ub418\uc9c0\ub9cc \ud14c\uc774\ube14\uc758 \uac2f\uc218\uac00 \ub9ce\uc744 \ub54c\ub294 \uadc0\ucc2e\ub2e4. \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc790.<\/p>\n\n\n\n

\n

SET @tables = NULL;
SELECT GROUP_CONCAT(table_schema, ‘.’, table_name) INTO @tables FROM information_schema.tables WHERE table_schema = ‘MY_DATABASE<\/strong>‘;
SET @tables = CONCAT(‘DROP TABLE ‘, @tables);
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

mysql\uc774\ub098 mariadb\ub97c \uc0ac\uc6a9\ud558\ub2e4\uac00 DB\ub294 \ub0a8\uaca8 \ub450\uace0 \uc548\uc5d0 \uc788\ub294 \ud14c\uc774\ube14\ub9cc \uc0ad\uc81c\ud574\uc57c \ub420 \ub54c\uac00 \uc788\ub2e4. \ud14c\uc774\ube14\uc774 \uba87 \uac1c \uc548\ub418\uba74 drop table ‘\ud14c\uc774\ube14\uc774\ub984’; \uba87 \ubc88 \ud558\uba74 \ub418\uc9c0\ub9cc \ud14c\uc774\ube14\uc758 \uac2f\uc218\uac00 \ub9ce\uc744 \ub54c\ub294 \uadc0\ucc2e\ub2e4. \uc544\ub798\uc758 \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud558\uc790.<\/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,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[5],"tags":[35,34],"class_list":["post-1329","post","type-post","status-publish","format-standard","hentry","category-5","tag-mariadb","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1185,"url":"https:\/\/sarang.inmu.net\/?p=1185","url_meta":{"origin":1329,"position":0},"title":"mysql timestamp","author":"sarang","date":"2019\ub144 07\uc6d4 02\uc77c","format":false,"excerpt":"mysql\uc5d0\uc11c reg_date \uac12\uc744 timestamp \ub85c \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uac04\ub2e8 \uc124\uba85","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":724,"url":"https:\/\/sarang.inmu.net\/?p=724","url_meta":{"origin":1329,"position":1},"title":"\uc9c0\uae08 \uc774 \uc21c\uac04\uc73c\ub85c\ubd80\ud130 \ub531 \uc77c\uc8fc\uc77c \uc804\uc744 mysql\uc5d0\uc11c \ud45c\ud604\ud574\ubcf4\uc790\uc790","author":"sarang","date":"2017\ub144 01\uc6d4 02\uc77c","format":false,"excerpt":"\uc5f0\uc0b0\uc774 \uc790\uafb8 \ud5f7\uae54\ub9b0\ub2e4. < \uc778\uac00? \uc544\ub2c8\uba74 > \uc778\uac00 #SELECT count(*) from myTable WHERE reg_date < (unix_timestamp() - (86400 * 7)); \uc704\uc5d0\uc11c \uc911\uc694\ud55c \uac83\uc740 where \uc774\ud558 \ubcfc\ub4dc\uccb4\uc774\ub2e4. reg_date\ub294 php\uc5d0\uc11c time()\ud568\uc218\ub098 mysql\uc5d0\uc11c unix_timestamp() \ud568\uc218\ub85c \uc800\uc7a5\ud55c \uac12\ub4e4\uc774\ub2e4. \uc704\uc758 \uc5f0\uc0b0\uc740 \uc9c0\uae08\uc73c\ub85c \ubd80\ud130 1\uc8fc\uc77c \uc774\uc804\uc5d0 \uc785\ub825\ub41c row \uac2f\uc218\ub97c \uc54c\ub824 \uc900\ub2e4. \uc55e\uc758 select\ub97c delete\ub85c \ubc14\uafb8\uba74 \uc9c0\uae08\uc73c\ub85c\ubd80\ud130\u2026","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":205,"url":"https:\/\/sarang.inmu.net\/?p=205","url_meta":{"origin":1329,"position":2},"title":"mariadb \uc124\uce58\uc640 \uac04\ub2e8 \uc124\uc815","author":"sarang","date":"2016\ub144 04\uc6d4 12\uc77c","format":false,"excerpt":"mariadb \ub97c \uacf5\ubd80\ud558\ub824\uace0 VM\uc5d0 \uae54\ub9b0 \ub9ac\ub205\uc2a4 \ucd5c\uc2e0\ubc84\uc804\uc744 \uc124\uce58\ud588\ub2e4. \ub9ac\ub205\uc2a4\ub294 centos 5\uc774\uace0 \uc124\uce58\ub41c mariadb\ub294 10.1.13 \ubc84\uc804\uc774\ub2e4. \uc774\ubb38\uc11c\uac00 \uc791\uc131\ub418\uace0 \uc788\ub294 \uc2dc\uc810\uc5d0\uc11c\ub294 \ucd5c\uc2e0\ubc84\uc804\uc774\ub2e4. yum\uc124\uce58\ub97c \ud558\uc600\uc73c\uba70 \/etc\/yum.repo.d\/ \ub514\ub809\ud1a0\ub9ac\uc5d0 mariadb.repo \ud30c\uc77c\uc744 vi\ub85c \ub9cc\ub4e4\uace0 \uadf8 \uacf3\uc5d0 \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \ub123\uc5c8\ub2e4. [mariadb] name = MariaDB baseurl = http:\/\/yum.mariadb.org\/10.1.13\/centos5-amd64 gpgkey = https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB gpgcheck = 1 \uc124\uce58\ud560 \ub54c \uc8fc\uc758 \uc0ac\ud56d\uc740\u2026","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1145,"url":"https:\/\/sarang.inmu.net\/?p=1145","url_meta":{"origin":1329,"position":3},"title":"mysql \ub9ac\ud50c\ub9ac\ucf00\uc774\uc158 \uc124\uc815 \ud6c4","author":"sarang","date":"2019\ub144 03\uc6d4 10\uc77c","format":false,"excerpt":"\uc0ac\uc2e4\uc740 mariadb\ub97c \uc4f0\uace0 \uc788\ub2e4. replication \uc5d0 \ub300\ud574\uc11c\ub294 \uad6c\uae00\ub9c1\uc744 \ud558\uba74 \uc5b4\ub835\uc9c0 \uc54a\uac8c \uc124\uc815\ud558\ub294 \ubc29\ubc95\uc774 \ub098\uc640 \uc788\ub2e4. master \uc640 slave \uac1c\ub150\uc73c\ub85c \uc27d\uac8c \ub9d0\ud574 \uc704\uc5d0\uc11c \uc544\ub798\ub85c \ud750\ub974\ub294 \uac1c\ub150\uc73c\ub85c \uc11c\ubc84\ub97c \ubcf5\uc81c\ud55c\ub2e4. \ub098\ub294 slave\ub97c \ubc31\uc5c5 \uc6a9\ub3c4\ub85c \uc0ac\uc6a9\ud55c\ub2e4. \ubc29\ubb38\uc790\uac00 \ud558\ub8e8\uc5d0 \uace0\uc791 \uba87 \ubc31 \uc548\ub418\ub294 \uc18c\uaddc\ubaa8 \uc0ac\uc774\ud2b8\uc5d0\uc11c db \uc11c\ubc84\ub97c \uba87 \uac1c\uc529 \ub3cc\ub9b4 \uc774\uc720\uac00 \uc5c6\uae30 \ub54c\ubb38\uc778\ub370 \uc911\uc694\ud55c \uac83\uc740\u2026","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1098,"url":"https:\/\/sarang.inmu.net\/?p=1098","url_meta":{"origin":1329,"position":4},"title":"firewall-cmd \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec \ud2b9\uc815 IP\ucc28\ub2e8","author":"sarang","date":"2019\ub144 01\uc6d4 15\uc77c","format":false,"excerpt":"\uac00\ub054 \uc11c\ubc84\ub97c \ud5e4\ud0b9\ud558\ub824\ub294 \uc0ac\ub78c\ub4e4\uc774 \uc788\ub2e4. \ub204\uad70\uac00\uac00 \ub9c8\uc74c \uba39\uace0 \ub0b4\uac00 \uad00\ub9ac\ud558\ub294 \uc11c\ubc84\ub97c \ud5e4\ud0b9\ud558\ub824\uace0 \ud55c\ub2e4\uba74 \ub098\uac19\uc740 \ucd08\ubcf4\ub294 \ub9c9\uc744 \ubc29\ubc95\uc774 \uc5c6\ub2e4. \uadf8\ub7ec\ub098 \uc774 \uc11c\ubc84\uc5d0 \ubb34\uc5b4 \uadf8\ub9ac \uc911\uc694\ud55c\uac8c \uc788\ub2e4\uace0 \ub9c8\uc74c \uba39\uace0 \uace0\uae09 \uae30\uc220\uc744 \uc774\uc6a9\ud574\uc11c \uc11c\ubc84\ub97c \ud5e4\ud0b9\ud558\uaca0\ub294\uac00? \uadf8\ub7ec\ub098 \uac00\ub054 \ucd08\ubcf4\uc801\uc778 \uc218\uc900\uc758 \ud5e4\ud0b9\uc73c\ub85c \uc11c\ubc84\ub97c \ud0c8\ucde8\ud558\ub824\ub294 \uc0ac\ub78c\ub4e4\uc774 \uc788\ub2e4. \uc2dc\uac04 \ub0a0\ub54c \ud130\ubbf8\ub110\uc5d0\uc11c netstat -a \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\uc2dc\ucf1c \ubcf4\uace0 \uadf8\uc5d0\u2026","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1140,"url":"https:\/\/sarang.inmu.net\/?p=1140","url_meta":{"origin":1329,"position":5},"title":"\ud2b9\uc815\uc544\uc774\ud53c \ub300\uc5ed\uc5d0\uc11c \ud2b9\uc815 \ud3ec\ud2b8\ub9cc \uc811\uc18d \ud558\ub2a5\ud558\ub3c4\ub85d \uc124\uc815\ud558\uae30","author":"sarang","date":"2019\ub144 03\uc6d4 10\uc77c","format":false,"excerpt":"\uc11c\ubc84\ub97c \ub2e4\uc2dc \uc124\uce58 \ud588\ub2e4. \ub85c\uadf8\ub97c \ubcf4\ub2c8 1\ucd08\uc5d0 \ud55c \ubc88\uc529 mysql\uacfc pop3\ub85c \uc811\uc18d\uc2dc\ub3c4\ub97c \ud558\uace0 \uc788\ub2e4. \ucc38\uc73c\ub85c \uc5f4\uc2ec\ud788 \uc77c\ud558\ub294 \ucef4\ud4e8\ud130\ub4e4\uc774\ub2e4. \uc774 \uacf3\uc5d0 \ubb50 \ubcfc\uac8c \uc788\ub2e4\uace0 \uadf8\ub9ac \uc5f4\uc2ec\ud788 \uc811\uc18d \uc2dc\ub3c4\ub97c\ud558\uace0 \uc788\uc744\uae4c. \ud2b9\ud788 mysql\uc740 root\uacc4\uc815\uc744 \ud0c8\ucde8\ud558\ub824\uace0 \ub04a\uc784 \uc5c6\uc774 \uc628\uac16 \uacf3\uc5d0\uc11c \uc811\uc18d\uc744 \uc2dc\ub3c4\ud558\uace0 \uc788\ub2e4. \uc77c\uc77c\ud788 \uc544\uc774\ud53c\ub97c \uc7a1\uc544\uc11c \uc811\uc18d\uc744 \ub9c9\uae30\uc5d0\ub294 \ubb34\ub9ac\uac00 \uc788\uc5b4 \ubcf4\uc778\ub2e4. \ud604\uc7ac \ub85c\uceec\uc5d0\uc11c\ub294 master\uc11c\ubc84\ub85c\u2026","rel":"","context":""\ucef4\ud4e8\ud130"\uc5d0\uc11c","block_context":{"text":"\ucef4\ud4e8\ud130","link":"https:\/\/sarang.inmu.net\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_shortlink":"https:\/\/wp.me\/p7qW60-lr","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1329"}],"version-history":[{"count":2,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1329\/revisions"}],"predecessor-version":[{"id":1332,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=\/wp\/v2\/posts\/1329\/revisions\/1332"}],"wp:attachment":[{"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sarang.inmu.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}