{"id":1203,"date":"2020-09-02T22:14:27","date_gmt":"2020-09-02T14:14:27","guid":{"rendered":"https:\/\/www.siediyer.cn\/?p=1203"},"modified":"2020-09-02T22:14:27","modified_gmt":"2020-09-02T14:14:27","slug":"mysql%e4%bf%ae%e6%94%b9general-log%e6%97%a5%e5%bf%97","status":"publish","type":"post","link":"https:\/\/www.siediyer.cn\/?p=1203","title":{"rendered":"MySQL\u4fee\u6539general-log\u65e5\u5fd7"},"content":{"rendered":"<h3>MySQL\u67e5\u770bSQL\u6267\u884c\u8bb0\u5f55<\/h3>\n<p>MySQL\u67e5\u770bSQL\u6267\u884c\u8bb0\u5f55\uff0c\u4e3b\u8981\u6709\u4e24\u79cd\u65b9\u5f0f\uff0c\u8fd9\u91cc\u5206\u522b\u4ecb\u7ecd\u4e00\u4e0b\u3002<\/p>\n<ul>\n<li>\u65b9\u6cd51\uff1a\u67e5\u770b<code>general-log<\/code>\u65e5\u5fd7<\/li>\n<li>\u65b9\u6cd52\uff1a\u67e5\u770b<code>bin-log<\/code>\u65e5\u5fd7<\/li>\n<\/ul>\n<h4><a id=\"1generallog_5\"><\/a>1.\u67e5\u770b<code>general-log<\/code>\u65e5\u5fd7<\/h4>\n<h5><a id=\"11__6\"><\/a>1.1 \u67e5\u770b\u76f8\u5173\u53d8\u91cf<\/h5>\n<pre class=\"lang:default decode:true \">mysql&gt; show variables like 'general%';\r\n+------------------+--------------------------------------------------------+\r\n| Variable_name    | Value                                                  |\r\n+------------------+--------------------------------------------------------+\r\n| general_log      | OFF                                                    |\r\n| general_log_file | D:\/Program Files\/MySQL\/MySQL Server 5.7\/logs\/mysql.log |\r\n+------------------+--------------------------------------------------------+\r\n2 rows in set, 1 warning (0.03 sec)<\/pre>\n<p>\u53ef\u4ee5\u770b\u5230\u5728\u8be5\u76ee\u5f55\u4e0b\uff0c\u662f\u6ca1\u6709mysql.log\u8fd9\u4e2a\u6587\u4ef6\u7684\uff0c\u539f\u56e0\u662f\uff0cmysql\u5e76\u6ca1\u6709\u9ed8\u8ba4\u5f00\u542f<code>general-log<\/code>\u8fd9\u4e2a\u8bbe\u7f6e\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1205\" src=\"https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173512802.png\" width=\"966\" height=\"246\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" srcset=\"https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173512802.png 966w, https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173512802-300x76.png 300w, https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173512802-768x196.png 768w\" sizes=\"auto, (max-width: 966px) 100vw, 966px\" \/><\/p>\n<h5><a id=\"12__19\"><\/a>1.2 \u8bbe\u7f6e\u76f8\u5173\u53d8\u91cf<\/h5>\n<p>\u6267\u884cSQL\u8bed\u53e5\uff1a<code>set global general_log = ON;<\/code>\uff0c\u4f46\u662f\u5982\u679c\u9700\u8981\u6c38\u4e45\u751f\u6548\uff0c\u8fd8\u662f\u5f97\u4fee\u6539<code>my.cnf\/my.ini<\/code>\u6587\u4ef6\uff08[mysqld]\u540e\u4e2d\u4fee\u6539\uff1a<code>general_log = 1<\/code>\uff09\u5982\u4e0b\uff1a<\/p>\n<pre class=\"lang:default decode:true \">#general-log=0 default value\r\ngeneral-log=1<\/pre>\n<h5>1.3 \u91cd\u542fmysql<\/h5>\n<h5><a id=\"14__27\"><\/a>1.4 \u518d\u6b21\u68c0\u9a8c<\/h5>\n<pre class=\"lang:default decode:true \">mysql&gt; show variables like 'general%';\r\n+------------------+--------------------------------------------------------+\r\n| Variable_name    | Value                                                  |\r\n+------------------+--------------------------------------------------------+\r\n| general_log      | ON                                                     |\r\n| general_log_file | D:\/Program Files\/MySQL\/MySQL Server 5.7\/logs\/mysql.log |\r\n+------------------+--------------------------------------------------------+\r\n2 rows in set, 1 warning (0.00 sec)<\/pre>\n<h5>1.5 \u6267\u884c\u64cd\u4f5c<\/h5>\n<pre class=\"lang:default decode:true \">mysql&gt; use insidemysql\r\nDatabase changed\r\nmysql&gt; show tables;\r\n+-----------------------+\r\n| Tables_in_insidemysql |\r\n+-----------------------+\r\n| buy_log               |\r\n| fact_sales_lawson     |\r\n| matrix                |\r\n| student               |\r\n| student_temp          |\r\n| t                     |\r\n| t2                    |\r\n| t3                    |\r\n+-----------------------+\r\n8 rows in set (0.00 sec)\r\n\r\nmysql&gt; select * from t;\r\n+------+\r\n| i    |\r\n+------+\r\n|    1 |\r\n+------+\r\n1 row in set (0.02 sec)<\/pre>\n<p>\u67e5\u770b\u76f8\u5e94\u7684general-log\u6587\u4ef6\uff1a<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1206\" src=\"https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173852278.png\" width=\"841\" height=\"279\" alt=\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\" srcset=\"https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173852278.png 841w, https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173852278-300x100.png 300w, https:\/\/qiniu.shijitianchen.com\/2020\/09\/20181111173852278-768x255.png 768w\" sizes=\"auto, (max-width: 841px) 100vw, 841px\" \/>\u53d1\u73b0\uff0c\u521a\u624d\u6267\u884c\u7684\u76f8\u5173mysql\u7684\u64cd\u4f5c\uff0c\u5747\u5df2\u8bb0\u5f55\u5230\u4e86mysql.log\u4e2d\u3002<\/p>\n<h4><a id=\"2_69\"><\/a>\u65b9\u6cd52<\/h4>\n<p>\u67e5\u770b<code>bin-log<\/code>\u00a0\u65e5\u5fd7\uff0c\u5173\u4e8e<code>bin-log<\/code>\u00a0\u65e5\u5fd7\uff0c\u7b14\u8005\u4e4b\u524d\u5c31\u5df2\u7ecf\u505a\u8fc7\u4ecb\u7ecd\uff0c\u8be6\u89c1\u94fe\u63a5\uff1a<a href=\"https:\/\/blog.csdn.net\/liu16659\/article\/details\/83755136\">https:\/\/blog.csdn.net\/liu16659\/article\/details\/83755136<\/a><\/p>\n<div id=\"gtx-trans\" style=\"position: absolute; left: 537px; top: 2195.94px;\">\n<div class=\"gtx-trans-icon\"><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL\u67e5\u770bSQL\u6267\u884c\u8bb0\u5f55 MySQL\u67e5\u770bSQL\u6267\u884c\u8bb0\u5f55\uff0c\u4e3b\u8981\u6709\u4e24\u79cd\u65b9\u5f0f\uff0c\u8fd9\u91cc\u5206\u522b\u4ecb\u7ecd\u4e00\u4e0b\u3002 \u65b9\u6cd51\uff1a\u67e5\u770bg [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1205,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1203","post","type-post","status-publish","format-standard","hentry","category-linux"],"_links":{"self":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1203"}],"version-history":[{"count":1,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1203\/revisions"}],"predecessor-version":[{"id":1207,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/posts\/1203\/revisions\/1207"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=\/wp\/v2\/media\/1205"}],"wp:attachment":[{"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.siediyer.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}