一、配置慢sql追踪的日志记录
1. 修改dm.ini,开启sql日志
SVR_LOG_NAME = SLOG_ALL
SVR_LOG = 1
2. 与dm.ini同一目录下,创建sqllog.ini,并重启数据库服务。自此所有操作sql日志将记录在/dmdata/dmlog目录下
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 = /dmdata/dmlog
PART_STOR = 0
SWITCH_MODE = 2
SWITCH_LIMIT = 256
ASYNC_FLUSH = 1
FILE_NUM = 1024
ITEMS = 0
SQL_TRACE_MASK = 1
MIN_EXEC_TIME = 1
USER_MODE = 2
USERS = ***
3. 捕获应用系统运行一段时间后,从sql日志中过滤出大于1秒的查询sql,写入到/tmp/slow.log
cd /dmdata/dmlog
more *.log|grep 'SEL'|grep -E