为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:centos7
【CPU】:16
【问题描述】*:dmsql中本来按照配置只想记录慢sql的,但是日志记录好多没用的信息,导致日志变大,影响慢sql筛选和排查。
日志配置如下:
#日志配置
BUF_TOTAL_SIZE = 10240 #SQLs Log Buffer Total Size(K)(1024~1024000)
BUF_SIZE = 1024 #SQLs Log Buffer Size(K)(50~409600)
BUF_KEEP_CNT = 6 #SQLs Log buffer keeped count(1~100)
[SLOG_ALL]
FILE_PATH = …/log
PART_STOR = 0
SWITCH_MODE = 2
SWITCH_LIMIT = 100000
ASYNC_FLUSH = 0
FILE_NUM = 200
ITEMS = 0
SQL_TRACE_MASK = 3:5:23:24:25
MIN_EXEC_TIME = 3000
USER_MODE = 0
USERS =
1.
2021-07-09 10:47:44.951 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10998], page_lsn[0], n_pages[9098]
2021-07-09 10:47:44.989 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10997], page_lsn[0], n_pages[9099]
2021-07-09 10:47:45.026 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10996], page_lsn[0], n_pages[9100]
2021-07-09 10:47:45.067 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10995], page_lsn[0], n_pages[9101]
2021-07-09 10:47:45.105 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10994], page_lsn[0], n_pages[9102]
2021-07-09 10:47:45.141 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10993], page_lsn[0], n_pages[9103]
2021-07-09 10:47:45.176 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 10992], page_lsn[0], n_pages[9104]
2021-07-09 10:47:45.214 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11023], page_lsn[0], n_pages[9105]
2021-07-09 10:47:45.253 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11022], page_lsn[0], n_pages[9106]
2021-07-09 10:47:45.290 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11021], page_lsn[0], n_pages[9107]
2021-07-09 10:47:45.325 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11020], page_lsn[0], n_pages[9108]
2021-07-09 10:47:45.361 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11019], page_lsn[0], n_pages[9109]
2021-07-09 10:47:45.397 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11018], page_lsn[0], n_pages[9110]
2021-07-09 10:47:45.432 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11017], page_lsn[0], n_pages[9111]
2021-07-09 10:47:45.469 (EP[0] sess:0x7f0a48011218 thrd:2953 user:SYSDBA trxid:65139 stmt:NULL appname:manager.exe) trx[65139] alloc pseg page[0, 11016], page_lsn[0], n_pages[9112]
2.
2021-07-09 10:57:30.432 (EP[0] sess:0x7f0a64011218 thrd:7137 user:SYSDBA trxid:0 stmt:0x7f0a64034a10 appname: ip:::ffff: ) [ORA]: SELECT 1
2021-07-09 10:57:30.432 (EP[0] sess:0x7f0a64011218 thrd:7137 user:SYSDBA trxid:65527 stmt:NULL appname: ) TRX: START
2021-07-09 10:57:30.432 (EP[0] sess:0x7f0a64011218 thrd:7137 user:SYSDBA trxid:65527 stmt:NULL appname: ) TRX: COMMIT
建议