{"id":1483,"date":"2026-05-13T23:23:43","date_gmt":"2026-05-13T14:23:43","guid":{"rendered":"http:\/\/www.igoni.kr\/?p=1483"},"modified":"2026-05-13T23:23:43","modified_gmt":"2026-05-13T14:23:43","slug":"mysql-innodb%ec%bb%b4%ed%8c%8c%ec%9d%bc","status":"publish","type":"post","link":"http:\/\/www.igoni.kr\/?p=1483","title":{"rendered":"Mysql innodb\ucef4\ud30c\uc77c"},"content":{"rendered":"<p id=\"bkmrk-mysql-4%EB%B2%84%EC%A0%84%EC%9D%80-innodb%EA%B0%80-%EA%B8%B0\">\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc9c0\uae08\uc740 \uc798 \uc0ac\uc6a9\ud558\ub294 \ubc84\uc804\uc740 \uc544\ub2c8\uc9c0\ub9cc, \uc544\uce74\uc774\ube59\uc744 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<p>Mysql 4\ubc84\uc804\uc740 innodb\uac00 \uae30\ubcf8\ud3ec\ud568\uc774\uc9c0\ub9cc, 5.1\ubc84\uc804\uc740 \ucef4\ud30c\uc77c\uc2dc \uc635\uc158\uc744 \ub123\uc5b4\uc57c \ud568.<\/p>\n<pre id=\"bkmrk-%24%3E-.%2Fconfigure---pre\"><code class=\"language-Python\">$&gt; .\/configure --prefix=\/usr\/local\/mysql \\\r\n--with-extra-charsets=all \\\r\n--with-readline \\\r\n--with-plugins=max \\\r\n--with-charset=utf8 \\\r\n--with-innodb \u00a0(\ud639\uc740 --with-plugins=innobase)<\/code><\/pre>\n<table style=\"border-collapse: collapse; width: 100%;\" border=\"1\">\n<colgroup>\n<col style=\"width: 99.881%;\" \/><\/colgroup>\n<tbody>\n<tr>\n<td><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1485\" src=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/23e99161-387e-4763-a0cc-fd8d543cb0dd.png\" alt=\"\" width=\"900\" height=\"672\" srcset=\"http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/23e99161-387e-4763-a0cc-fd8d543cb0dd.png 900w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/23e99161-387e-4763-a0cc-fd8d543cb0dd-300x224.png 300w, http:\/\/www.igoni.kr\/wp-content\/uploads\/2026\/05\/23e99161-387e-4763-a0cc-fd8d543cb0dd-768x573.png 768w\" sizes=\"auto, (max-width: 900px) 100vw, 900px\" \/><\/td>\n<\/tr>\n<tr>\n<td>perplexity\uc5d0\uc11c \uc0dd\uc131\ud55c AI\uc774\ubbf8\uc9c0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p id=\"bkmrk-%EC%84%A4%EC%B9%98-%EB%81%9D%EB%82%98%EA%B3%A0-innodb-%ED%8F%AC%ED%95%A8-%EC%97%AC%EB%B6%80-\">\uc124\uce58 \ub05d\ub098\uace0 innodb \ud3ec\ud568 \uc5ec\ubd80 \ud655\uc778\uc740 mysql \uc811\uc18d\ud574\uc11c \ucffc\ub9ac \ub0a0\ub9ac\uba74 \ub428<\/p>\n<pre id=\"bkmrk-mysql%3E-show-variable\"><code class=\"language-SQL\">mysql&gt; show variables like 'have_innodb';\r\n+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| Variable_name | Value |\r\n+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n| have_innodb | YES |\r\n+\u2014\u2014\u2014\u2014\u2014+\u2014\u2014-+\r\n1 row in set (0.00 sec)\r\n\r\nshow engines;\r\nmysql&gt; show engines;\r\n+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014+\u2014\u2014\u2014\u2014+\r\n| Engine | Support | Comment | Transactions | XA | Savepoints |\r\n+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014+\u2014\u2014\u2014\u2014+\r\n| ndbcluster | NO | Clustered, fault-tolerant tables | NULL | NULL | NULL |\r\n| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |\r\n| BLACKHOLE | YES | \/dev\/null storage engine (anything you write to it disappears) | NO | NO | NO |\r\n| CSV | YES | CSV storage engine | NO | NO | NO |\r\n| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |\r\n| FEDERATED | NO | Federated MySQL storage engine | NULL | NULL | NULL |\r\n| ARCHIVE | YES | Archive storage engine | NO | NO | NO |\r\n| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |\r\n| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |\r\n+\u2014\u2014\u2014\u2014+\u2014\u2014\u2014+\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014-+\u2014\u2014\u2014\u2014\u2013+\u2014\u2014+\u2014\u2014\u2014\u2014+\r\n9 rows in set (0.00 sec)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc548\ub155\ud558\uc138\uc694, \uace0\ub2c8\uc785\ub2c8\ub2e4. \uc9c0\uae08\uc740 \uc798 \uc0ac\uc6a9\ud558\ub294 \ubc84\uc804\uc740 \uc544\ub2c8\uc9c0\ub9cc, \uc544\uce74\uc774\ube59\uc744 \uc704\ud574 \uc5c5\ub370\uc774\ud2b8 \ud588\uc2b5\ub2c8\ub2e4. Mysql 4\ubc84\uc804\uc740 innodb\uac00 \uae30\ubcf8\ud3ec\ud568\uc774\uc9c0\ub9cc, 5.1\ubc84\uc804\uc740&hellip;<\/p>\n","protected":false},"author":1,"featured_media":1485,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux-"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1483"}],"version-history":[{"count":1,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1483\/revisions"}],"predecessor-version":[{"id":1487,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/posts\/1483\/revisions\/1487"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=\/wp\/v2\/media\/1485"}],"wp:attachment":[{"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1483"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igoni.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}