DDS接入
LTS支持文档数据库服务(DDS)日志接入,具体接入方法请参见日志配置管理。
DDS慢日志结构化模板日志详情
- DDS慢日志示例日志
表1 结构化模板示例 模板名称
示例日志
DDS慢日志
{"log_type": "slow_log","log_time": "2022-08-20T10:04:03.204000Z","namespace": "data0820.table","database": "data0820","collection": "table","operate_type": "insert","docs_scanned": 0,"docs_returned": 0,"n_deleted": 0,"n_matched": 0,"n_modified": 0,"n_inserted": 10,"cost_time": 555,"lock_time": 0,"whole_message": "{\"op\": \"insert\", \"ns\": \"data0820.usrtable\", \"command\": \"{N}\", \"ninserted\": 1, \"keysInserted\": 1, \"numYield\": 0, \"locks\": {\"Global\": {\"acquireCount\": {\"r\": 5, \"w\": 5}}, \"Database\": {\"acquireCount\": {\"w\": 4, \"W\": 1}}, \"Collection\": {\"acquireCount\": {\"w\": 2}}, \"oplog\": {\"acquireCount\": {\"w\": 2}}}, \"responseLength\": 230, \"protocol\": \"op_msg\", \"millis\": 555, \"ts\": {\"$date\": 1660989843204}, \"client\": \"192.168.0.64\", \"appName\": \"MongoDB Shell\", \"allUsers\": [{\"user\": \"rwuser\", \"db\": \"admin\"}], \"user\": \"rwuser@admin\"}","instance_id": "5b67dc63ba824145aae1f12ff51e58b8in02","node_id": "686a791e690e4db3af591ec4b6f72916no02","client_ip": "190.12.11.11","username": "user中文","keys_examined": 0}
- 结构化字段及字段说明
表2 结构化字段 字段
示例
描述
类型
log_type
slow_log
日志类型
string
log_time
2022-08-20T10:04:03.204000Z
慢日志产生时间
string
namespace
data0820.table
命名空间
string
database
data0820
库名称
string
collection
table
表名称
string
operate_type
insert
操作类型
string
docs_scanned
0
数据库扫描行数
long
docs_returned
0
查询返回结果行数
long
n_deleted
0
删除行数
long
n_matched
0
更新匹配行数
long
n_modified
0
实际更新行数
long
n_inserted
10
插入行数
long
cost_time
555
操作花费的时间
long
lock_time
0
wait_lock的时间
long
whole_message
{\"op\": \"insert\", \"ns\": \"data0820.usrtable\", \"command\": \"{N}\", \"ninserted\": 1, \"keysInserted\": 1, \"numYield\": 0, \"locks\": {\"Global\": {\"acquireCount\": {\"r\": 5, \"w\": 5}}, \"Database\": {\"acquireCount\": {\"w\": 4, \"W\": 1}}, \"Collection\": {\"acquireCount\": {\"w\": 2}}, \"oplog\": {\"acquireCount\": {\"w\": 2}}}, \"responseLength\": 230, \"protocol\": \"op_msg\", \"millis\": 555, \"ts\": {\"$date\": 1660989843204}, \"client\": \"192.168.0.64\", \"appName\": \"MongoDB Shell\", \"allUsers\": [{\"user\": \"rwuser\", \"db\": \"admin\"}], \"user\": \"rwuser@admin\"}
原始日志信息
string
instance_id
5b67dc63ba824145aae1f12ff51e58b8in02
实例ID
string
node_id
686a791e690e4db3af591ec4b6f72916no02
节点ID
string
DDS错误日志结构化模板日志详情
- DDS错误日志示例日志
表3 结构化模板示例 模板名称
示例日志
DDS错误日志
{"log_type": "error_log","severity": "Error","log_time": "2022-08-22T09:33:15.142+0000","raw_message": "E QUERY [ClusterDisasterBackupChangeJob] Get global setting disasterBackup failed.","instance_id": "5b67dc63ba824145aae1f12ff51e58b8in02","node_id": "686a791e690e4db3af591ec4b6f72916no02"}
- 结构化字段及字段说明
表4 结构化字段 字段
示例
描述
类型
log_type
error_log
日志类型
string
severity
Error
日志级别
string
log_time
2022-08-22T09:33:15.142+0000
日志产生时间
string
raw_message
E QUERY [ClusterDisasterBackupChangeJob] Get global setting disasterBackup failed.
日志内容
string
instance_id
5b67dc63ba824145aae1f12ff51e58b8in02
实例Id
string
node_id
686a791e690e4db3af591ec4b6f72916no02
节点Id
string
DDS审计日志结构化模板日志详情
- DDS审计日志示例
表5 结构化模板示例 模板名称
示例日志
DDS审计日志
{"topic":"auditLog","instanceid":"9fbf813bc27e4a3ab54bddf783a4f774in01","nodeid":"bf4cb0413d0b4221be94b08471708586no01","db":"test","coll":"testCollection","optype":"update","time":"2022-08-05T08:24:15.536+0000","user_ip":"10.4.23.205","user_port":"47668","user":"rw_testuser","param":{"command":"update","ns":"test.testCollection","op":[{"q":{"vin":"LDP31B965NG036174"},"u":{"$set":{"timestamp":{"$numberLong":"1659687855535"},"deviceTime":{"$numberLong":"1659687855340"},"longitude":"119.35516805555555","latitude":"26.057936388888891","location":"119.35516805555555,26.057936388888891","height":"10.097286797128618","direction":"12","speed":14,"accuracy":"0","h3Address7":"8741b5300ffffff"}},"upsert":true}],"args":{"update":"testCollection","ordered":true,"$db":"test","$clusterTime":{"clusterTime":{"$timestamp":{"t":1659687855,"i":1685}},"signature":{"hash":{"$binary":"CP5bfEf+gBJZdAxCKtF9HiSeqQY=","$type":"00"},"keyId":{"$numberLong":"7102408879899674942"}}},"lsid":{"id":{"$binary":"PXVVrbuvRuGkypCbu/oXXQ==","$type":"04"}}}}}
- 结构化字段及字段说明
表6 结构化字段 字段
示例
描述
类型
topic
auditLog
消息主题
string
instanceid
9fbf813bc27e4a3ab54bddf783a4f774in01
实例ID
string
nodeid
bf4cb0413d0b4221be94b08471708586no01
节点ID
string
db
test
数据库名
string
coll
testCollection
开启分片的集合名
string
optype
update
操作类型
string
time
2022-08-05T08:24:15.536+0000
审计日志时间
string
user_ip
10.4.23.205
客户端IP
string
user_port
47668
客户端端口
string
user
rw_testuser
数据库用户账户
string
param
{\"command\":\"update\",\"ns\":\"test.testCollection\",\"op\":[{\"q\":{\"vin\":\"LDP31B965NG036174\"},\"u\":{\"$set\":{\"timestamp\":{\"$numberLong\":\"1659687855535\"},\"deviceTime\":{\"$numberLong\":\"1659687855340\"},\"longitude\":\"119.35516805555555\",\"latitude\":\"26.057936388888891\",\"location\":\"119.35516805555555,26.057936388888891\",\"height\":\"10.097286797128618\",\"direction\":\"12\",\"speed\":14,\"accuracy\":\"0\",\"h3Address7\":\"8741b5300ffffff\"}},\"upsert\":true}],\"args\":{\"update\":\"testCollection\",\"ordered\":true,\"$db\":\"test\",\"$clusterTime\":{\"clusterTime\":{\"$timestamp\":{\"t\":1659687855,\"i\":1685}},\"signature\":{\"hash\":{\"$binary\":\"CP5bfEf+gBJZdAxCKtF9HiSeqQY=\",\"$type\":\"00\"},\"keyId\":{\"$numberLong\":\"7102408879899674942\"}}},\"lsid\":{\"id\":{\"$binary\":\"PXVVrbuvRuGkypCbu/oXXQ==\",\"$type\":\"04\"}}}}
数据库操作详情和参数
string