{"id":67,"date":"2014-07-22T23:07:55","date_gmt":"2014-07-22T15:07:55","guid":{"rendered":"http:\/\/www.codeeel.com\/?p=67"},"modified":"2014-07-22T23:07:55","modified_gmt":"2014-07-22T15:07:55","slug":"mysql%e6%89%93%e5%bc%80general-log%e7%9a%84%e5%8a%9e%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.codeeel.com\/?p=67","title":{"rendered":"mysql\u6253\u5f00general log\u7684\u529e\u6cd5"},"content":{"rendered":"

mysql\u6253\u5f00general log\u7684\u529e\u6cd5<\/p>\n

 <\/p>\n

mysql\u6253\u5f00general log\u4e4b\u540e\uff0c\u6240\u6709\u7684\u67e5\u8be2\u8bed\u53e5\u90fd\u53ef\u4ee5\u5728general log<\/p>\n

\u6587\u4ef6\u4e2d\u4ee5\u53ef\u8bfb\u7684\u65b9\u5f0f\u5f97\u5230\uff0c\u4f46\u662f\u8fd9\u6837general log\u6587\u4ef6\u4f1a\u975e\u5e38\u5927\uff0c\u6240\u4ee5\u9ed8\u8ba4<\/p>\n

\u90fd\u662f\u5173\u95ed\u7684\u3002\u6709\u7684\u65f6\u5019\u4e3a\u4e86\u67e5\u9519\u7b49\u539f\u56e0\uff0c\u8fd8\u662f\u9700\u8981\u6682\u65f6\u6253\u5f00general log\u7684\u3002<\/p>\n

 <\/p>\n

mysql@localhost.(none)>show global variables like “%genera%”;<\/p>\n

+——————+——————————+<\/p>\n

| Variable_name | Value |<\/p>\n

+——————+——————————+<\/p>\n

| general_log | OFF |<\/p>\n

| general_log_file | \/data1\/mysql9999\/etch171.log |<\/p>\n

+——————+——————————+<\/p>\n

2 rows in set (0.00 sec)<\/p>\n

 <\/p>\n

mysql@localhost.(none)>set global general_log=on;<\/p>\n

Query OK, 0 rows affected (0.02 sec)<\/p>\n

 <\/p>\n

mysql@localhost.(none)>set global general_log=off;<\/p>\n

Query OK, 0 rows affected (0.00 sec)<\/p>\n

 <\/p>\n

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

mysql\u6253\u5f00general log\u7684\u529e\u6cd5   mysql\u6253\u5f00general log\u4e4b\u540e\uff0c\u6240\u6709\u7684\u67e5\u8be2\u8bed\u53e5\u90fd\u53ef\u4ee5\u5728general log \u6587\u4ef6\u4e2d\u4ee5\u53ef\u8bfb\u7684\u65b9\u5f0f\u5f97\u5230\uff0c\u4f46\u662f\u8fd9\u6837general log\u6587\u4ef6\u4f1a\u975e\u5e38\u5927\uff0c\u6240\u4ee5\u9ed8\u8ba4 \u90fd\u662f\u5173\u95ed\u7684\u3002\u6709\u7684\u65f6\u5019\u4e3a\u4e86\u67e5\u9519\u7b49\u539f\u56e0\uff0c\u8fd8\u662f\u9700\u8981\u6682\u65f6\u6253\u5f00general log\u7684\u3002   m<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[19,17],"tags":[44,45,30],"_links":{"self":[{"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":1,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":68,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions\/68"}],"wp:attachment":[{"href":"https:\/\/www.codeeel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codeeel.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}