DM跟踪日志设置.pdf
免费下载
‘dmsql_ _ _ ’ DM log
SQL
1
SVR_LOG = 1
1
sp_set_para_value(1,'SVR_LOG',1);
2
3
--
4
SQL> sp_set_para_value(1,'SVR_LOG',1);
5
DMSQL executed successfully
6
used time: 51.920(ms). Execute id is 7100.
7
BUF_TOTAL_SIZE = 10240 #SQLs Log Buffer Total Size(K)
(1024~1024
000)
1
BUF_SIZE = 1024 #SQLs Log Buffer Size(K)(50~409600)
2
BUF_KEEP_CNT = 6 #SQLs Log buffer keeped count(1~100)
3
4
[SLOG_ALL]
5
FILE_PATH = ../log
6
PART_STOR = 0
7
SWITCH_MODE = 2
8
SWITCH_LIMIT = 128
9
ASYNC_FLUSH = 1
10
FILE_NUM = 5
11
ITEMS = 0
12
SQL_TRACE_MASK = 1
13
MIN_EXEC_TIME = 0
14
USER_MODE = 0
15
USERS =
16
17
[SLOG_ERROR]
18
SQL_TRACE_MASK = 23
19
FILE_PATH = ../log
20
21
[SLOG_DDL]
22
SQL_TRACE_MASK = 3:24
23
24
[SLOG_LONG_SQL]
25
SQL_TRACE_MASK = 2:3:25
26
MIN_EXEC_TIME = 60000
27
28
SP_REFRESH_SVR_LOG_CONFIG();
1
dmsql_DMSERVER_20231012_162607.log
1
-- 10ms
1
grep "[0-9][0-9](ms)" dmsql_DMSERVER_20231012_162607.log
2
of 7
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论