Skip to main content

Monitoring DM database

Collect and monitor the general performance metrics of the DM database. DM8+ is supported.

Configuration parameters

Parameter nameParameter help description
Monitor HostMonitored peer IPV4, IPV6 or domain name. Note ⚠️ without protocol headers (eg: https://, http://).
Monitor NameIdentifies the name of this monitor. The name needs to be unique.
PortThe port provided by the database externally, the default is 5236.
Query TimeoutSet the timeout when the SQL query does not respond to data, in ms milliseconds, the default is 3000 milliseconds.
database namedatabase instance name, optional.
usernamedatabase connection username, optional
passworddatabase connection password, optional
URLDatabase connection URL, optional
Collection IntervalMonitor periodical collection data interval, in seconds, the minimum interval that can be set is 30 seconds
Whether to detectWhether to detect and check the availability of monitoring before adding monitoring, and then continue to add and modify operations if the detection is successful
Description RemarksMore remarks that identify and describe this monitoring, users can remark information here

Collect metrics

Metric collection: basic

Metric NameMetric UnitMetric Help Description
PORT_NUMNoneDatabase exposed service port
CTL_PATHNoneControl File Path
MAX_SESSIONSNoneMaximum database connections

Metric collection: status

Metric NameMetric UnitMetric Help Description
status$NoneOpen/Close status of DM database

Metric collection: thread

Metric NameMetric UnitMetric Help Description
dm_sql_thdNoneThread for writing dmsql dmserver
dm_io_thdNoneIO threads, controlled by IO_THR_GROUPS parameter, default is 2 threads
dm_quit_thdNoneThread used to perform a graceful shutdown of the database