{"id":683,"date":"2015-04-13T21:34:46","date_gmt":"2015-04-14T06:34:46","guid":{"rendered":"http:\/\/blog.box.kr\/?p=683"},"modified":"2015-04-13T21:34:46","modified_gmt":"2015-04-14T06:34:46","slug":"mariadb-utf8mb4-%eb%9e%80","status":"publish","type":"post","link":"https:\/\/blog.box.kr\/?p=683","title":{"rendered":"[MariaDB] utf8mb4 \ub780?"},"content":{"rendered":"<h4><a href=\"http:\/\/blog.lael.be\/post\/917\">http:\/\/blog.lael.be\/post\/917<\/a><\/h4>\n<h4><\/h4>\n<h4>4\ubc14\uc774\ud2b8 UTF-8 \ubb38\uc790\uc5f4<\/h4>\n<p>MySQL\uc5d0\uc11c \ubd80\ub7b4\ubd80\ub7b4 \uc6d0\ub798\uc758 \uc124\uacc4\ub300\ub85c \uac00\ubcc0-4\ubc14\uc774\ud2b8 UTF-8 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \uc790\ub8cc\ud615\uc744 \ucd94\uac00\ud588\ub2e4.<\/p>\n<p>2010\ub144 3\uc6d4 24\uc77c\uc5d0 utf8mb4 \ub77c\ub294 charset\uc744 \ucd94\uac00\ud558\uc600\ub2e4. (MYSQL 5.5.3 \uc5d0 \ucd94\uac00\ub428)<\/p>\n<p>(\uad00\ub828 :\u00a0<a href=\"https:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.5\/en\/news-5-5-3.html\" target=\"_blank\">https:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.5\/en\/news-5-5-3.html<\/a> )<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-963\" src=\"https:\/\/i0.wp.com\/blog.lael.be\/wp-content\/uploads\/2015\/03\/\uc2a4\ud06c\ub9b0\uc0f7-2015-03-07-\uc624\ud6c4-6.51.19.png?resize=623%2C148\" alt=\"\uc2a4\ud06c\ub9b0\uc0f7 2015-03-07 \uc624\ud6c4 6.51.19\" width=\"623\" height=\"148\" data-recalc-dims=\"1\" \/><\/p>\n<p>&gt; \ubd80\uc5f0\uc124\uba85 : utf8 \uc744 \ud328\uce58\ud558\uc9c0 \uc54a\uace0 \uc2e0\uaddc charset\uc73c\ub85c \ucd94\uac00\ud55c \uc774\uc720\ub294, \uc774\ubbf8 \uad6c\ucd95\ub41c \uc2dc\uc2a4\ud15c\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n<p>\uc989, \uc774\ubbf8 3\uce78\uc744 \uc800\uc7a5\uacf5\uac04\uc73c\ub85c \uc7a1\uc544\ub450\uc5c8\uae30 \ub54c\ubb38\uc5d0 4\uce78\uc758 \ubb38\uc790\ub97c \uc800\uc7a5\ud560 \uc218 \uc5c6\uc74c.<\/p>\n<p>&nbsp;<\/p>\n<p>\ub354 \uc790\uc138\ud55c \uc774\ub860\uc744 \uc6d0\ud558\uba74 Wikipedia \uc758 Plane \ud56d\ubaa9\uc744 \uc77d\uc5b4\ubcf4\uae38 \ubc14\ub780\ub2e4.<\/p>\n<p>(\uc5b4\ub824\uc6c0. \uadf8\ub0e5 \uc4f0\uc73d \uc77d\uc5b4\ubcf4\uc138\uc694.\u00a0<a href=\"http:\/\/en.wikipedia.org\/wiki\/Plane_(Unicode)\" target=\"_blank\">http:\/\/en.wikipedia.org\/wiki\/Plane_(Unicode)<\/a> )<\/p>\n<p>&nbsp;<\/p>\n<p>Byte Test \u00a0\ub294 \ub77c\uc5d8\uc774\uac00 \ub9cc\ub4e0\u00a0<a href=\"http:\/\/datalink.lael.be\/qdic.kr\/PHP-utf8_length.php\" target=\"_blank\">http:\/\/datalink.lael.be\/qdic.kr\/PHP-utf8_length.php<\/a> \ub97c \uc774\uc6a9\ud574\ubcf4\uc138\uc694.<\/p>\n<p>UTF-8 4\ubc14\uc774\ud2b8\uc758 \ubb38\uc790 \ubcf5\uc0ac\ud558\uae30 : \u00a0http:\/\/www.i18nguy.com\/unicode\/supplementary-test.html<\/p>\n<p>\ud604\uc7ac \ub77c\uc5d8\uc774\uc758 \ube14\ub85c\uadf8\ub3c4 utf8 \ub85c \uc124\uc815\ub418\uc5b4\uc788\uae30 \ub54c\ubb38\uc5d0 \ubcf8\ubb38\uc5d0 4byte \ubb38\uc790\ub97c \uc785\ub825\ud560 \uc218 \uc5c6\uc5c8\ub2e4. \uc704\uc758 \ud398\uc774\uc9c0\uc5d0\uc11c \ubcf5\uc0ac\ud6c4 \ud14c\uc2a4\ud2b8 \ud574 \ubcf4\uc790.<\/p>\n<p>&nbsp;<\/p>\n<p>\uadf8\ub9ac\uace0 \uc911\uc694\ud55c \uac83!!! Emoji \ubb38\uc790\uc5f4\uc774 \ubaa8\ub450 4 Byte \uc774\ub2e4!!<\/p>\n<p>\uc694\uc998 \uc2a4\ub9c8\ud2b8\ud3f0\uc5d0\uc11c \uc774\ubbf8 \uc788\ub294 \ubb38\uc790\uc774\uace0, \ub77c\uc5d8\uc774\uc758 \uacbd\uc6b0 \uc6b4\uc601\uccb4\uc81c\ub85c Mac OS X \ub97c \uc0ac\uc6a9\ud558\ub294\ub370,<\/p>\n<p>Mac \uc5d0\uc11c \ucee4\uba58\ub4dc+\ucee8\ud2b8\ub864+\uc2a4\ud398\uc774\uc2a4\ub97c \uc785\ub825\ud558\uba74 \ub098\uc624\ub294 \ud0a4\ubcf4\ub4dc\uc774\ub2e4.<\/p>\n<p>\u2013 \ucc38\uace0 \uc774\ubbf8\uc9c0 \u2014<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-965\" src=\"https:\/\/i0.wp.com\/blog.lael.be\/wp-content\/uploads\/2015\/03\/\uc2a4\ud06c\ub9b0\uc0f7-2015-03-07-\uc624\ud6c4-7.05.17.png?resize=480%2C300\" alt=\"\uc2a4\ud06c\ub9b0\uc0f7 2015-03-07 \uc624\ud6c4 7.05.17\" width=\"480\" height=\"300\" data-recalc-dims=\"1\" \/><\/p>\n<p>\u2013 \ucc38\uace0 \uc774\ubbf8\uc9c0 \u2013<\/p>\n<p>&nbsp;<\/p>\n<p>\uc989 \uc774\ub7ec\ud55c SMP (Supplementary Multilingual Plane) \ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud574\uc11c<\/p>\n<p>\ub2f9\uc2e0\uc758 DBMS \uac00 utf8mb4 \ub97c \uc9c0\uc6d0\ud55c\ub2e4\uba74 \ubc18\ub4dc\uc2dc \uc774\uac83\uc73c\ub85c \uc9c0\uc815\ud558\uae38 \ubc14\ub780\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>Collation \ub3c4 \uc124\uba85\ud574\uc57c \ud558\ub294\ub370 \uc774\uac83 \ub610\ud55c \uc124\uba85\uc774 \uae38\uc5b4\uc11c \uacb0\ub860\ub9cc \ub9d0\ud574\uc8fc\uace0\uc790 \ud55c\ub2e4.<\/p>\n<p>1) MySQL 5.5.3 \uc774\uc804 = utf8 charset \uc5d0, utf8_general_ci\u00a0collation\uc0ac\uc6a9.<\/p>\n<p>2) MySQL \uc774 \ucd5c\uc2e0\uc77c \ub54c = utf8mb4\u00a0charset \uc5d0, utf8mb4_unicode_ci\u00a0collation \uc0ac\uc6a9.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>http:\/\/blog.lael.be\/post\/917 4\ubc14\uc774\ud2b8 UTF-8 \ubb38\uc790\uc5f4 MySQL\uc5d0\uc11c \ubd80\ub7b4\ubd80\ub7b4 \uc6d0\ub798\uc758 \uc124\uacc4\ub300\ub85c \uac00\ubcc0-4\ubc14\uc774\ud2b8 UTF-8 \ubb38\uc790\uc5f4\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \uc790\ub8cc\ud615\uc744 \ucd94\uac00\ud588\ub2e4. 2010\ub144 3\uc6d4 24\uc77c\uc5d0 utf8mb4 \ub77c\ub294 charset\uc744 \ucd94\uac00\ud558\uc600\ub2e4. (MYSQL 5.5.3 \uc5d0 \ucd94\uac00\ub428) (\uad00\ub828 :\u00a0https:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.5\/en\/news-5-5-3.html ) &gt; \ubd80\uc5f0\uc124\uba85 : utf8 \uc744 \ud328\uce58\ud558\uc9c0 \uc54a\uace0 \uc2e0\uaddc charset\uc73c\ub85c \ucd94\uac00\ud55c \uc774\uc720\ub294, \uc774\ubbf8 \uad6c\ucd95\ub41c \uc2dc\uc2a4\ud15c\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uae30 \ub54c\ubb38\uc774\ub2e4. \uc989, \uc774\ubbf8 3\uce78\uc744 \uc800\uc7a5\uacf5\uac04\uc73c\ub85c \uc7a1\uc544\ub450\uc5c8\uae30 \ub54c\ubb38\uc5d0 4\uce78\uc758 \ubb38\uc790\ub97c \uc800\uc7a5\ud560 \uc218 \uc5c6\uc74c. &nbsp; \ub354 \uc790\uc138\ud55c \uc774\ub860\uc744 \uc6d0\ud558\uba74 Wikipedia \uc758 Plane \ud56d\ubaa9\uc744 \uc77d\uc5b4\ubcf4\uae38 \ubc14\ub780\ub2e4. (\uc5b4\ub824\uc6c0. \uadf8\ub0e5 \uc4f0\uc73d \uc77d\uc5b4\ubcf4\uc138\uc694.\u00a0http:\/\/en.wikipedia.org\/wiki\/Plane_(Unicode) ) &nbsp; Byte Test \u00a0\ub294 \ub77c\uc5d8\uc774\uac00 \ub9cc\ub4e0\u00a0http:\/\/datalink.lael.be\/qdic.kr\/PHP-utf8_length.php \ub97c \uc774\uc6a9\ud574\ubcf4\uc138\uc694. UTF-8 4\ubc14\uc774\ud2b8\uc758 \ubb38\uc790 \ubcf5\uc0ac\ud558\uae30 : \u00a0http:\/\/www.i18nguy.com\/unicode\/supplementary-test.html \ud604\uc7ac \ub77c\uc5d8\uc774\uc758 \ube14\ub85c\uadf8\ub3c4 utf8 \ub85c \uc124\uc815\ub418\uc5b4\uc788\uae30 \ub54c\ubb38\uc5d0 \ubcf8\ubb38\uc5d0 4byte \ubb38\uc790\ub97c \uc785\ub825\ud560 \uc218 \uc5c6\uc5c8\ub2e4. \uc704\uc758 \ud398\uc774\uc9c0\uc5d0\uc11c \ubcf5\uc0ac\ud6c4 \ud14c\uc2a4\ud2b8 \ud574 \ubcf4\uc790. &nbsp; \uadf8\ub9ac\uace0 \uc911\uc694\ud55c \uac83!!! Emoji \ubb38\uc790\uc5f4\uc774 \ubaa8\ub450 4 Byte \uc774\ub2e4!! \uc694\uc998 \uc2a4\ub9c8\ud2b8\ud3f0\uc5d0\uc11c \uc774\ubbf8 \uc788\ub294 \ubb38\uc790\uc774\uace0, \ub77c\uc5d8\uc774\uc758 \uacbd\uc6b0 \uc6b4\uc601\uccb4\uc81c\ub85c Mac OS X \ub97c \uc0ac\uc6a9\ud558\ub294\ub370, Mac \uc5d0\uc11c \ucee4\uba58\ub4dc+\ucee8\ud2b8\ub864+\uc2a4\ud398\uc774\uc2a4\ub97c \uc785\ub825\ud558\uba74 \ub098\uc624\ub294 \ud0a4\ubcf4\ub4dc\uc774\ub2e4. \u2013 \ucc38\uace0 \uc774\ubbf8\uc9c0 \u2014 \u2013 \ucc38\uace0 \uc774\ubbf8\uc9c0 \u2013 &nbsp; \uc989 \uc774\ub7ec\ud55c SMP (Supplementary Multilingual Plane) \ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud574\uc11c \ub2f9\uc2e0\uc758 DBMS \uac00 utf8mb4 \ub97c \uc9c0\uc6d0\ud55c\ub2e4\uba74 \ubc18\ub4dc\uc2dc \uc774\uac83\uc73c\ub85c \uc9c0\uc815\ud558\uae38 \ubc14\ub780\ub2e4. &nbsp; Collation \ub3c4 \uc124\uba85\ud574\uc57c \ud558\ub294\ub370 \uc774\uac83 \ub610\ud55c \uc124\uba85\uc774 \uae38\uc5b4\uc11c \uacb0\ub860\ub9cc \ub9d0\ud574\uc8fc\uace0\uc790 \ud55c\ub2e4. 1) MySQL 5.5.3 \uc774\uc804 = utf8 charset \uc5d0, utf8_general_ci\u00a0collation\uc0ac\uc6a9. 2) MySQL \uc774 \ucd5c\uc2e0\uc77c \ub54c = utf8mb4\u00a0charset \uc5d0, utf8mb4_unicode_ci\u00a0collation \uc0ac\uc6a9.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"ngg_post_thumbnail":0,"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[5],"tags":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5q9Zn-b1","jetpack-related-posts":[{"id":649,"url":"https:\/\/blog.box.kr\/?p=649","url_meta":{"origin":683,"position":0},"title":"[\ud38c]Tomcat7 tomcat-jdbc \uc124\uc815 &#8211; Broken pipe \uc5d0\ub7ec \ud68c\ud53c","date":"2015-04-05","format":false,"excerpt":"tomcat-jdbc\ub85c MySQL\uc5d0 \uc5f0\uacb0\ud55c \uacbd\uc6b0 \"java.net.SocketException: Broken pipe\" \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0\ub97c \uac00\ub054 \ubcfc \uc218 \uc788\ub2e4. \ub300\ubd80\ubd84\uc758 \uacbd\uc6b0 connection idle time\uc774 MySQL\uc5d0 \uc124\uc815\ub41c wait_timeout\uc744 \uc9c0\ub098\uc11c DB\uc5d0\uc11c \uc5f0\uacb0\uc744 \ub04a\uc740 \uac83\uc774\ub2e4. \uc774\ub97c \ubc29\uc9c0\ud558\ub824\uba74 connection\uc774 \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 close\ub418\ub3c4\ub85d \uc124\uc815\ud558\uac70\ub098 connection \ub300\uc5ec\uc2dc\uc5d0 connection\uc744 \uccb4\ud06c\ud558\ub3c4\ub85d \ud558\uba74 \ub41c\ub2e4. \uc124\uc815 1 - \uc77c\uc815 \uae30\uac04\ub3d9\uc548 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc73c\uba74 connection\uc744\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":687,"url":"https:\/\/blog.box.kr\/?p=687","url_meta":{"origin":683,"position":1},"title":"[\ud38c]MariaDB \uc124\uc815 \ud30c\uc77c my.cnf","date":"2015-04-13","format":false,"excerpt":"http:\/\/www.programkr.com\/blog\/MUDM5ADMwYT2.html \u00a0 \u00a0 # MariaDB database server configuration file. # # You can copy this file to one of: # - \"\/etc\/mysql\/my.cnf\" to set global options, # - \"~\/.my.cnf\" to set user-specific options. # # One can use all long options that the program supports. # Run program with --help\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":653,"url":"https:\/\/blog.box.kr\/?p=653","url_meta":{"origin":683,"position":2},"title":"[\ud38c]Too many connection \ubb38\uc81c \ud574\uacb0","date":"2015-04-05","format":false,"excerpt":"http:\/\/netholic.tistory.com\/116 \u00a0 \u00a0 \uc774\ubc88\ud574 \ucd08\ubd80\ud130 \uc2dc\uc791\ub41c too many connection \ubb38\uc81c\uac00 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529 mysql \uc744 \ubed7\uac8c \ub9cc\ub4e4\uc5c8\ub2e4. \ub418\ub294\ub300\ub85c... \uc544\ubb34\uac83\ub3c4 \ubaa8\ub978\ucc44\ub85c \ub9cc\ub4e0 \uc6b4\uc601\ud234\uc774 \uadf8 \uc6d0\uc778... \ucffc\ub9ac\ub3c4 10\ucd08 \uc774\uc0c1 \uac78\ub9ac\ub294 \uac83\ub3c4 \uc874\uc7ac\ud588\uace0..\uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uc548\uac78\ub824\uc788\uace0.. \uadf8\ub798\uc11c \uc2ac\ub85c\uc6b0 \ucffc\ub9ac\ub97c \uc7a1\uace0 \uc778\ub371\uc2a4\ub3c4 \uc81c\ub300\ub85c \uac78\uc5b4\uc11c...\uadf8\ub7f0 \ucffc\ub9ac\ubb38\uc81c\ub97c \uc5c6\uc570\uc73c\ub85c\uc11c \ucee4\ub125\uc158 \ubb38\uc81c\ub294 \uc5c6\uc5b4\uc9c8 \uc904 \uc54c\uc558\ub2e4. \uadf8\ub7f0\ub370 \uc5ec\uc804\ud788 \ud558\ub8e8\uc5d0 \ud55c\ubc88\uc529...\uc11c\ubc84\ub97c \ub0b4\ub838\ub2e4\u2026","rel":"","context":"In &quot;\uae30\uc220\uc790\ub8cc&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":148,"url":"https:\/\/blog.box.kr\/?p=148","url_meta":{"origin":683,"position":3},"title":"\ud55c WAS \uc11c\ubc84\uc5d0\uc11c UTF-8 \uacfc EUC-KR \ub458\ub2e4 \uc9c0\uc6d0\ud558\uae30..","date":"2014-07-03","format":false,"excerpt":"\ud55c \uc6f9\uc11c\ubc84\uc5d0 UTF-8\uacfc EUC-KR \uc744 \uac19\uc774 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 TIP\uc774 \uc788\uae34 \ud569\ub2c8\ub2e4...\uc2e4\uc81c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\ub098, \ud14c\uc2a4\ud2b8\ub294 \uaf2d \ud574\ubcf4\uc138\uc694..\u00a0\uc0ac\uc6a9\ud658\uacbd\uc740 \ub9ac\ub205\uc2a4(CENTOS)+APACH+TOMCAT+SPRING2.5\u00a0web.xml \uc5d0\uc11c \ud544\ud130\ub97c \ucd94\uac00\ud574\uc8fc\ub294\ub370\uc694 UTF-8\uc6a9\uacfc EUC-KR \ub458\ub2e4 \ud544\ud130\ub97c \ucd94\uac00\ud574\uc90d\ub2c8\ub2e4.\u00a0<filter>\u00a0<display-name>encodingFilter<\/display-name><filter-name>encodingFilter<\/filter-name>\u00a0<filter-class>org.springframework.web.filter.CharacterEncodingFilter<\/filter-class>\u00a0<init-param><param-name>encoding<\/param-name><param-value>UTF-8<\/param-value>\u00a0<\/init-param>\u00a0<\/filter>\u00a0<filter>\u00a0<display-name>euc_kr_encodingFilter<\/display-name><filter-name>euc_kr_encodingFilter<\/filter-name>\u00a0<filter-class>org.springframework.web.filter.CharacterEncodingFilter<\/filter-class>\u00a0<init-param><param-name>encoding<\/param-name><param-value>EUC-KR<\/param-value><\/init-param>\u00a0<\/filter>\u00a0 <filter-mapping> <filter-name>encodingFilter<\/filter-name> <url-pattern>*.do<\/url-pattern> <\/filter-mapping> <filter-mapping> <filter-name>euc_kr_encodingFilter<\/filter-name> <url-pattern>*.do2<\/url-pattern> <\/filter-mapping> <servlet> <servlet-name>dispatcher<\/servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet<\/servlet-class> <load-on-startup>2<\/load-on-startup> <\/servlet> <servlet-mapping> <servlet-name>dispatcher<\/servlet-name> <url-pattern>*.do<\/url-pattern> <\/servlet-mapping> <servlet-mapping> <servlet-name>dispatcher<\/servlet-name> <url-pattern>*.do2<\/url-pattern> <\/servlet-mapping> \u00a0 \u00a0 \uadf8\ub9ac\uace0\u2026","rel":"","context":"In &quot;WAS, Servet Containers&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":803,"url":"https:\/\/blog.box.kr\/?p=803","url_meta":{"origin":683,"position":4},"title":"[scrap]mysqldump \uc635\uc158 \ubc0f \uc0ac\uc6a9\ubc95","date":"2015-05-18","format":false,"excerpt":"http:\/\/egloos.zum.com\/simonshin\/v\/2247509 \u00a0 1. mysqldump \uc635\uc158 \uc911 binary log \uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4 \uac19\uc774 dump \ud558\uae30 \/usr\/local\/mysql\/bin\/mysqldump -uroot -p --master-data=2\u00a0 > \/data\/\u2026\/backup.sql \uc774 \uba85\ub839\uc5b4 \uc911\uc5d0\uc11c \"--master-data=2\" \uc635\uc158\uc744 \uc8fc\uac8c \ub418\uba74 \ub364\ud504 \uc2dc\uc810\uc758 binary log\uc758 \ud3ec\uc9c0\uc158 \uc815\ubcf4\uac00 \uac19\uc774 Dump \ub418\uac8c \ub41c\ub2e4. Dump\ub41c \ud30c\uc77c\uc744 \uc5d0\ub514\ud130\ub85c \uc5f4\uc5b4\ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc774 \ub098\uc628\ub2e4. 2. Table Lock \uac78\uae30 FLUSH\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1284,"url":"https:\/\/blog.box.kr\/?p=1284","url_meta":{"origin":683,"position":5},"title":"MySql \uad00\ub9ac","date":"2021-12-30","format":false,"excerpt":"Table\uc5d0 \uc0dd\uc131\ub418\uc5b4 \uc788\ub294 Indexes \uc758 \uc6a9\ub7c9 \ud655\uc778 select database_name, table_name, index_name, round((stat_value*@@innodb_page_size)\/1024\/1024, 2) SizeMB, round(((100\/(SELECT INDEX_LENGTH FROM INFORMATION_SCHEMA.TABLES t WHERE t.TABLE_NAME = iis.table_name and t.TABLE_SCHEMA = iis.database_name))*(stat_value*@@innodb_page_size)), 2) `Percentage` from mysql.innodb_index_stats iis where stat_name='size' and table_name = 'TargetTable' and database_name = 'targetDB' show table status from database_name; -- databases\uc5d0 \uc788\ub294\u2026","rel":"","context":"In &quot;DB\uad00\ub828&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/683"}],"collection":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=683"}],"version-history":[{"count":0,"href":"https:\/\/blog.box.kr\/index.php?rest_route=\/wp\/v2\/posts\/683\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.box.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}