{"id":2796,"date":"2018-07-05T15:40:53","date_gmt":"2018-07-05T07:40:53","guid":{"rendered":"http:\/\/blg.sofasay.com\/?p=2796"},"modified":"2018-07-05T15:49:38","modified_gmt":"2018-07-05T07:49:38","slug":"%e6%9f%a5%e7%9c%8b%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c%e6%97%a5%e5%bf%97","status":"publish","type":"post","link":"http:\/\/blog.sofasay.com\/?p=2796","title":{"rendered":"\u67e5\u770b\u6570\u636e\u5e93\u64cd\u4f5c\u65e5\u5fd7"},"content":{"rendered":"

\u628a\u6240\u6709\u5bf9\u6570\u636e\u5e93\u7684\u64cd\u4f5c\/SQL(DDL,DML,Query)\u5168\u90fd\u8bb0\u5f55\u5230\u6587\u4ef6\u6216\u8005\u8868\u4e2d\uff0c\u7528\u4e8e\u8c03\u8bd5\u6216\u67e5\u9519\u3002<\/p>\n

Mysql<\/h5>\n

\u8f6c\u81ea\uff1a Link<\/a><\/p>\n

\u9996\u5148\u8fdb\u5165mysql\u8f93\u5165\u6307\u4ee4<\/p>\n

show variables like ‘gen%’;<\/p>\n

<\/pre>\n<\/blockquote>\n
\u53ef\u4ee5\u770b\u5230\u8f93\u51fa<\/p>\n
+——————+————————————-+<\/p>\n
<\/pre>\n
| Variable_name | Value |<\/p>\n
+——————+————————————-+<\/p>\n
| general_log | OFF |<\/p>\n
| general_log_file | \/usr\/local\/mysql\/data\/localhost.log |<\/p>\n
+——————+————————————-+<\/p>\n
<\/pre>\n
\u53ef\u4ee5\u770b\u5230general_log\u662f\u5f00\u542f\u8fd8\u662f\u73af\u6bd4\u72b6\u6001\uff0c\u4ee5\u53ca\u8fd9\u4e2a\u5e10\u53f7\u7684general_log\u6587\u4ef6\u5728\u54ea\uff0c\u8bbe\u7f6e\u5f00\u542f<\/p>\n
set global general_log=ON;<\/p>\n
commit;\/\/\u5982\u679c\u5173\u95ed\u4e86\u81ea\u52a8\u63d0\u4ea4\uff0c\u8bb0\u5f97commit\u4e00\u6b21\u7ed3\u675f\u4e8b\u52a1<\/p>\n
<\/pre>\n<\/blockquote>\n
\u7136\u540e\u5c31\u53ef\u4ee5\u53bbgeneral_log_file\u7684\u8def\u5f84\u67e5\u770b\u64cd\u4f5c\u8bb0\u5f55\u4e86<\/p>\n
<\/h4>\n
\u91c7\u7528\u6570\u636e\u5e93\u5185\u90e8\u67e5\u770b<\/h4>\n
\u51fa\u4e86\u53ef\u4ee5\u7528\u65e5\u5fd7\u6587\u4ef6\u7684\u5f62\u5f0f\u67e5\u770b\u6570\u636e\u5e93\u64cd\u4f5c\u8bb0\u5f55\u4e4b\u5916\uff0c\u4e5f\u53ef\u4ee5\u628a\u65e5\u5fd7\u4f5c\u4e3a\u4e00\u4e2a\u8868\u5355\uff0c\u5728\u6570\u636e\u5e93\u5185\u90e8\u67e5\u770b<\/p>\n
show variables like ‘%log_output%’;<\/p>\n
<\/pre>\n<\/blockquote>\n
\u53ef\u4ee5\u770b\u5230\u8f93\u51fa\uff0c\u7136\u540e\u5c06\u5176\u6539\u4e3a\u8868\u5355<\/p>\n
+---------------+-------+<\/pre>\n
| Variable_name | Value |<\/pre>\n
+---------------+-------+<\/pre>\n
| log_output    | FILE  |<\/pre>\n
+---------------+-------+<\/pre>\n
set global log_output=’TABLE’;<\/p><\/blockquote>\n
<\/pre>\n
\u4e4b\u540e\u5c31\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u4e24\u53e5\u8bdd\u67e5\u770b\u6570\u636e\u5e93\u64cd\u4f5c\u8bb0\u5f55<\/p>\n
select * from mysql.general_log; <=====\u67e5\u770b\u64cd\u4f5c\u8bb0\u5f55<\/p>\n
truncate table mysql.general_log; <=====\u6e05\u7a7a\u64cd\u4f5c\u8bb0\u5f55\u8868\u5355<\/p>\n
<\/pre>\n<\/blockquote>\n
 <\/p>\n
Postgresql<\/h5>\n
\u8f93\u51fa\u65e5\u5fd7\u5230\u6587\u4ef6\uff0c\u4fee\u6539$PGDATA\/postgresql.conf\u00a0\u00a0 \u53ef\u80fd$PGDATA=\/var\/lib\/pgsql\/9.4\/data<\/p>\n
log_destination = ‘stderr’<\/p>\n
logging_collector = on<\/p>\n
log_directory = ‘pg_log’<\/p>\n
log_filename = ‘postgresql-%a.log’<\/p>\n
#log_filename = ‘postgresql-%Y-%m-%d_%H%M%S.log’<\/p>\n
log_statement = ‘mod’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # none, ddl, mod, all<\/p>\n
\u65e5\u5fd7\u6587\u4ef6\u53ea\u8bb0\u5f55\u6570\u636e\u66f4\u65b0\u7684\u64cd\u4f5c,\u6587\u4ef6\u540d\u5982\u4e0b<\/p>\n
-rw——-. 1 postgres postgres\u00a0 129 Jun 29 17:00 postgresql-Fri.log<\/p>\n
 <\/p>\n
 <\/p>\n
\u5982\u4f55\u67e5\u770b<\/h5>\n
Linux\u4e0b:<\/p>\n