Skip to content

Collector Configuration Manual for "Tencent Cloud-CDB Slow Query Logs"

Before reading this, please first read:

Before using this collector, you must install the 'Integration Core Package' and its corresponding third-party dependency packages.

This script's code execution depends on CDB instance object collection. If custom object collection for CDB is not configured, the slow log script will not be able to collect slow log data.

1. Configuration Structure

The configuration structure of this collector is as follows:

Field Type Required Description
regions list Required List of regions to collect data from
regions[#] str Required Region ID. Example: 'ap-shanghai'
Full list in the appendix

2. Configuration Example

Specify Region

Collect CDB slow query log data from Shanghai region.

Python
1
2
3
collector_configs = {
    'regions': ['ap-shanghai'],
}

3. Data Reporting Format

After data synchronization, you can view the data in the 'LOGs' section of TrueWatch.

An example of the reported data is as follows:

JSON
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
{
  "measurement": "tencentcloud_cdb_slow_log",
  "tags": {
    "name"          : "cdb-llxxxxx",
    "Database"      : "test",
    "UserHost"      : "9.xxx.xxx.122",
    "UserName"      : "root",
    "InstanceId"    : "cdb-lxxxxtk8",
    "DeviceType"    : "UNIVERSAL",
    "EngineVersion" : "8.0",
    "InstanceName"  : "cdbxxxxx",
    "InstanceType"  : "1",
    "PayType"       : "1",
    "ProjectId"     : "0",
    "ProtectMode"   : "0",
    "Region"        : "ap-shanghai",
    "RegionId"      : "ap-shanghai",
    "Status"        : "1",
    "Vip"           : "172.xx.xxx.15",
    "WanStatus"     : "0",
    "Zone"          : "ap-shanghai-3",
    "account_name"  : "Script development Tencent account",
    "cloud_provider": "tencentcloud"
  },
  "fields": {
      "QueryTime"   : 3.000195,
      "SqlText"     : "select sleep(3)",
      "Timestamp"   : 1652933796,
      "LockTime"    : 0,
      "RowsExamined": 1,
      "RowsSent"    : 1,
      "SqlTemplate" : "select sleep(?);",
      "Md5"         : "26A15F1AE530F28F",
      "message"     : "{JSON serialized data of instance}"
  }
}

Descriptions of some parameters are as follows:

Field Type Description
QueryTime float SQL execution duration (seconds)
Timestamp integer SQL execution time
Md5 str MD5 of SQL statement
LockTime float Lock duration (seconds)
RowsExamined integer Number of rows scanned
RowsSent integer Number of rows in result set

Fields in tags and fields may change with subsequent updates.

The value of tags.name is the instance ID, used as a unique identifier, and fields.message is a JSON serialized string.

X. Appendix

TencentCloud-CDB "Regions"

Please refer to the official Tencent documentation:

TencentCloud-CDB "Slow Log Information Documentation"

Please refer to the official Tencent documentation: