{"id":8968,"date":"2026-04-14T15:36:00","date_gmt":"2026-04-14T06:36:00","guid":{"rendered":"https:\/\/hasu0707.duckdns.org\/blog\/?p=8968"},"modified":"2026-04-14T15:36:01","modified_gmt":"2026-04-14T06:36:01","slug":"mariadb-general-log-%ec%b4%88%ea%b8%b0%ed%99%94","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=8968","title":{"rendered":"[MariaDB] general log \ucd08\uae30\ud654"},"content":{"rendered":"\n

MariaDB\uc5d0\uc11c general log \ud30c\uc77c\uc774 \ube44\ub300\ud574\uc84c\uc744 \ub54c \ucd08\uae30\ud654(\uc0ad\uc81c\/\ub9ac\uc14b)<\/strong> \ud558\ub294 \ubc29\ubc95\uc740 \uc124\uc815 \ubc29\uc2dd\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. \ud575\uc2ec\uc740 \ub85c\uadf8\uac00 \ud30c\uc77c\ub85c \uae30\ub85d\ub418\ub294\uc9c0, \ud14c\uc774\ube14\ub85c \uae30\ub85d\ub418\ub294\uc9c0<\/strong>\ub97c \uba3c\uc800 \ud655\uc778\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n

\n

1. \ud604\uc7ac general log \uc124\uc815 \ud655\uc778<\/h1>\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
 <\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
\n
\n
SHOW VARIABLES LIKE<\/span> 'general_log%'<\/span>;
SHOW VARIABLES LIKE<\/span> 'log_output'<\/span>;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
 <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
  • general_log = ON<\/code> → \ud65c\uc131\ud654 \uc0c1\ud0dc<\/li>\n
  • log_output = FILE<\/code> → \ud30c\uc77c \uc800\uc7a5<\/li>\n
  • log_output = TABLE<\/code> → mysql.general_log \ud14c\uc774\ube14 \uc800\uc7a5<\/li>\n<\/ul>\n
    \n

    2. FILE \ubc29\uc2dd\uc77c \uacbd\uc6b0 (\uc77c\ubc18\uc801)<\/h1>\n

    \u2714 \ubc29\ubc95 1: \uc548\uc804\ud558\uac8c \ub85c\uadf8 \ucd08\uae30\ud654 (\uad8c\uc7a5)<\/h2>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    SET<\/span> GLOBAL<\/span> general_log =<\/span> OFF;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    OS\uc5d0\uc11c \ub85c\uadf8 \ud30c\uc77c \uc0ad\uc81c \ub610\ub294 \ube44\uc6b0\uae30:<\/p>\n

    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    # \ud30c\uc77c \ub0b4\uc6a9\ub9cc \ube44\uc6b0\uae30 (\uad8c\uc7a5)<\/span>
    > \/var\/lib\/mysql\/hostname.log

    # \ub610\ub294 \uc0ad\uc81c<\/span>
    rm<\/span> -f<\/span> \/var\/lib\/mysql\/hostname.log<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    \ub2e4\uc2dc \ud65c\uc131\ud654:<\/p>\n

    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    SET<\/span> GLOBAL<\/span> general_log =<\/span> ON<\/span>;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n

    \u2714 \ubc29\ubc95 2: mysqladmin \uc0ac\uc6a9<\/h2>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    mysqladmin flush-logs<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    → \ub85c\uadf8 \ud30c\uc77c\uc744 \uc0c8\ub85c \uc0dd\uc131 (rotate \uac1c\ub150)<\/p>\n

    \n

    \u2714 \ubc29\ubc95 3: \uc124\uc815 \ubcc0\uacbd (\ub85c\uadf8 \ud30c\uc77c \uacbd\ub85c \ud655\uc778)<\/h2>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    SHOW VARIABLES LIKE<\/span> 'general_log_file'<\/span>;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n

    3. TABLE \ubc29\uc2dd\uc77c \uacbd\uc6b0<\/h1>\n

    general log\uac00 \ud14c\uc774\ube14\uc5d0 \uc313\uc774\ub294 \uacbd\uc6b0 (mysql.general_log<\/code>)<\/p>\n

    \u2714 \ucd08\uae30\ud654<\/h2>\n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
    \n
     <\/div>\n<\/div>\n<\/div>\n
    \n
    \n
    \n
    \n
    \n
    SET<\/span> GLOBAL<\/span> general_log =<\/span> OFF;

    TRUNCATE TABLE<\/span> mysql.general_log;

    SET<\/span> GLOBAL<\/span> general_log =<\/span> ON<\/span>;<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n
     <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    \n

    4. \ucd94\uac00 \uad8c\uc7a5 \uc0ac\ud56d (\uc911\uc694)<\/h1>\n

    \ud83d\udd25 general log\ub294 \ud56d\uc0c1 \ucf1c\ub450\uba74 \uc548\ub428<\/h3>\n
      \n
    • \ubaa8\ub4e0 \ucffc\ub9ac\ub97c \uae30\ub85d → \uc131\ub2a5 \uc800\ud558 + \ub514\uc2a4\ud06c \ud3ed\ubc1c<\/li>\n
    • \uc6b4\uc601 \ud658\uacbd\uc5d0\uc11c\ub294 \ud544\uc694 \uc2dc\uc5d0\ub9cc ON<\/li>\n<\/ul>\n
      \n

      \ud83d\udd27 \ub85c\uadf8 \ud06c\uae30 \uad00\ub9ac \uc790\ub3d9\ud654<\/h3>\n

      logrotate \uc124\uc815 \uc608\uc2dc<\/h4>\n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
      \n
       <\/div>\n<\/div>\n<\/div>\n
      \n
      \n
      \n
      \n
      \n
      \/var\/lib\/mysql\/*.log {
      daily
      rotate 7<\/span>
      compress
      missingok
      notifempty
      create 640<\/span> mysql mysql
      postrotate
      mysqladmin flush-logs
      endscript
      }<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      \n
       <\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
      \n

      5. \ud55c \uc904 \uc694\uc57d<\/h1>\n
        \n
      • FILE → OFF → \ud30c\uc77c \uc0ad\uc81c\/\ube44\uc6b0\uae30 → ON<\/code><\/li>\n
      • TABLE → OFF → TRUNCATE → ON<\/code><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        MariaDB\uc5d0\uc11c general log \ud30c\uc77c\uc774 \ube44\ub300\ud574\uc84c\uc744 \ub54c \ucd08\uae30\ud654(\uc0ad\uc81c\/\ub9ac\uc14b) \ud558\ub294 \ubc29\ubc95\uc740 \uc124\uc815 \ubc29\uc2dd\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. \ud575\uc2ec\uc740 \ub85c\uadf8\uac00 \ud30c\uc77c\ub85c \uae30\ub85d\ub418\ub294\uc9c0, \ud14c\uc774\ube14\ub85c \uae30\ub85d\ub418\ub294\uc9c0\ub97c \uba3c\uc800 \ud655\uc778\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. 1. \ud604\uc7ac general log \uc124\uc815 \ud655\uc778   SHOW VARIABLES LIKE ‘general_log%’;SHOW VARIABLES LIKE ‘log_output’;   general_log = ON → \ud65c\uc131\ud654 \uc0c1\ud0dc log_output = FILE → \ud30c\uc77c \uc800\uc7a5 log_output = TABLE → mysql.general_log \ud14c\uc774\ube14 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-8968","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8968","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8968"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/8968\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8968"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8968"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}