diff options
Diffstat (limited to 'templates/db')
31 files changed, 2327 insertions, 155 deletions
diff --git a/templates/db/cassandra_jmx/template_db_cassandra_jmx.yaml b/templates/db/cassandra_jmx/template_db_cassandra_jmx.yaml index 5f01d7c9646..81a0bb20a13 100644 --- a/templates/db/cassandra_jmx/template_db_cassandra_jmx.yaml +++ b/templates/db/cassandra_jmx/template_db_cassandra_jmx.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:54:01Z' - groups: + date: '2022-06-07T19:33:03Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases diff --git a/templates/db/clickhouse_http/README.md b/templates/db/clickhouse_http/README.md index 0bd9c75055b..db8acdb6601 100644 --- a/templates/db/clickhouse_http/README.md +++ b/templates/db/clickhouse_http/README.md @@ -167,7 +167,7 @@ There are no template links in this template. |ClickHouse: Port {$CLICKHOUSE.PORT} is unavailable |<p>-</p> |`last(/ClickHouse by HTTP/net.tcp.service[{$CLICKHOUSE.SCHEME},"{HOST.CONN}","{$CLICKHOUSE.PORT}"])=0` |AVERAGE |<p>Manual close: YES</p> | |ClickHouse: Service is down |<p>-</p> |`last(/ClickHouse by HTTP/clickhouse.ping)=0 or last(/ClickHouse by HTTP/net.tcp.service[{$CLICKHOUSE.SCHEME},"{HOST.CONN}","{$CLICKHOUSE.PORT}"]) = 0` |AVERAGE |<p>Manual close: YES</p><p>**Depends on**:</p><p>- ClickHouse: Port {$CLICKHOUSE.PORT} is unavailable</p> | |ClickHouse: Version has changed |<p>ClickHouse version has changed. Ack to close.</p> |`last(/ClickHouse by HTTP/clickhouse.version,#1)<>last(/ClickHouse by HTTP/clickhouse.version,#2) and length(last(/ClickHouse by HTTP/clickhouse.version))>0` |INFO |<p>Manual close: YES</p> | -|ClickHouse: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/ClickHouse by HTTP/clickhouse.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|ClickHouse: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/ClickHouse by HTTP/clickhouse.uptime)<10m` |INFO |<p>Manual close: YES</p> | |ClickHouse: Failed to fetch info data |<p>Zabbix has not received data for items for the last 30 minutes</p> |`nodata(/ClickHouse by HTTP/clickhouse.uptime,30m)=1` |WARNING |<p>Manual close: YES</p><p>**Depends on**:</p><p>- ClickHouse: Service is down</p> | |ClickHouse: Too many throttled insert queries |<p>Clickhouse have INSERT queries that are throttled due to high number of active data parts for partition in a MergeTree, please decrease INSERT frequency</p> |`min(/ClickHouse by HTTP/clickhouse.insert.delay,5m)>{$CLICKHOUSE.DELAYED.INSERTS.MAX.WARN}` |WARNING |<p>Manual close: YES</p> | |ClickHouse: Too many MergeTree parts |<p>Descease INSERT queries frequency.</p><p>Clickhouse MergeTree table engine split each INSERT query to partitions (PARTITION BY expression)</p><p>and add one or more PARTS per INSERT inside each partition,</p><p>after that background merge process run, and when you have too much unmerged parts inside partition,</p><p>SELECT queries performance can significate degrade, so clickhouse try delay insert, or abort it.</p> |`min(/ClickHouse by HTTP/clickhouse.max.part.count.for.partition,5m)>{$CLICKHOUSE.PARTS.PER.PARTITION.WARN} * 0.9` |WARNING |<p>Manual close: YES</p> | diff --git a/templates/db/clickhouse_http/template_db_clickhouse_http.yaml b/templates/db/clickhouse_http/template_db_clickhouse_http.yaml index 95bfdd9146f..713bf9421d2 100644 --- a/templates/db/clickhouse_http/template_db_clickhouse_http.yaml +++ b/templates/db/clickhouse_http/template_db_clickhouse_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:54:13Z' - groups: + date: '2022-06-07T19:33:11Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1202,7 +1202,7 @@ zabbix_export: name: 'ClickHouse: has been restarted' event_name: 'ClickHouse: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/cockroachdb_http/template_db_cockroachdb_http.yaml b/templates/db/cockroachdb_http/template_db_cockroachdb_http.yaml index a2691d2e8c1..496f1746f3b 100644 --- a/templates/db/cockroachdb_http/template_db_cockroachdb_http.yaml +++ b/templates/db/cockroachdb_http/template_db_cockroachdb_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-14T13:17:29Z' - groups: + date: '2022-06-07T19:33:12Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -2555,8 +2555,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.cpu.util host: 'CockroachDB by HTTP' + key: cockroachdb.cpu.util - type: GRAPH_CLASSIC 'y': '5' @@ -2571,8 +2571,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Memory usage' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Memory usage' - type: GRAPH_PROTOTYPE 'y': '10' @@ -2595,8 +2595,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'CockroachDB: Storage [{#STORE}]: Capacity' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Storage [{#STORE}]: Capacity' - type: GRAPH_CLASSIC 'y': '15' @@ -2611,8 +2611,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Disk: r/w, rate' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Disk: r/w, rate' - type: GRAPH_CLASSIC 'y': '20' @@ -2627,8 +2627,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Disk: r/w IOPS, rate' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Disk: r/w IOPS, rate' - type: GRAPH_CLASSIC 'y': '25' @@ -2643,8 +2643,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.disk.iops.in_progress.rate host: 'CockroachDB by HTTP' + key: cockroachdb.disk.iops.in_progress.rate - type: GRAPH_CLASSIC 'y': '30' @@ -2659,8 +2659,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Network traffic' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Network traffic' - uuid: 41dce007bcf54762ad321ac944a8b63e name: Replication @@ -2688,8 +2688,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'CockroachDB: Storage [{#STORE}]: Ranges' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Storage [{#STORE}]: Ranges' - type: GRAPH_PROTOTYPE 'y': '5' @@ -2712,8 +2712,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.replication.[{#STORE},lease_holders]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.replication.[{#STORE},lease_holders]' - type: GRAPH_PROTOTYPE 'y': '10' @@ -2736,8 +2736,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.rebalancing.queries.average.[{#STORE},rate]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.rebalancing.queries.average.[{#STORE},rate]' - type: GRAPH_PROTOTYPE 'y': '15' @@ -2760,8 +2760,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'CockroachDB: Storage [{#STORE}]: Replica quiescence' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Storage [{#STORE}]: Replica quiescence' - uuid: 0d9a3feb76ad403dac7379dbe04298f0 name: Runtime @@ -2781,8 +2781,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.live_count host: 'CockroachDB by HTTP' + key: cockroachdb.live_count - type: GRAPH_CLASSIC 'y': '5' @@ -2797,8 +2797,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Memory usage' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Memory usage' - type: GRAPH_CLASSIC 'y': '10' @@ -2813,8 +2813,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.go.goroutines.count host: 'CockroachDB by HTTP' + key: cockroachdb.go.goroutines.count - type: GRAPH_CLASSIC 'y': '15' @@ -2829,8 +2829,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.gc.runs.rate host: 'CockroachDB by HTTP' + key: cockroachdb.gc.runs.rate - type: GRAPH_CLASSIC 'y': '20' @@ -2845,8 +2845,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.gc.pause_time host: 'CockroachDB by HTTP' + key: cockroachdb.gc.pause_time - type: GRAPH_CLASSIC 'y': '25' @@ -2861,8 +2861,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: CPU Time' host: 'CockroachDB by HTTP' + name: 'CockroachDB: CPU Time' - type: GRAPH_CLASSIC 'y': '30' @@ -2877,8 +2877,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.clock.offset host: 'CockroachDB by HTTP' + key: cockroachdb.clock.offset - uuid: ac89b176f2c34fc1b885ee1ed43df590 name: 'Slow requests' @@ -2906,8 +2906,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.slow_requests.[{#STORE},raft_proposals]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.slow_requests.[{#STORE},raft_proposals]' - type: GRAPH_CLASSIC 'y': '5' @@ -2922,8 +2922,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.slow_requests.rpc host: 'CockroachDB by HTTP' + key: cockroachdb.slow_requests.rpc - type: GRAPH_PROTOTYPE 'y': '10' @@ -2946,8 +2946,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.slow_requests.[{#STORE},lease_acquisitions]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.slow_requests.[{#STORE},lease_acquisitions]' - type: GRAPH_PROTOTYPE 'y': '15' @@ -2970,8 +2970,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.slow_requests.[{#STORE},latch_acquisitions]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.slow_requests.[{#STORE},latch_acquisitions]' - uuid: b1086a92f1b54c45be99efd996b33457 name: SQL @@ -2991,8 +2991,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.sessions host: 'CockroachDB by HTTP' + key: cockroachdb.sql.sessions - type: GRAPH_CLASSIC x: '12' @@ -3007,8 +3007,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.transactions.open host: 'CockroachDB by HTTP' + key: cockroachdb.sql.transactions.open - type: GRAPH_CLASSIC 'y': '5' @@ -3023,8 +3023,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.statements.active host: 'CockroachDB by HTTP' + key: cockroachdb.sql.statements.active - type: GRAPH_CLASSIC x: '12' @@ -3040,8 +3040,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: SQL: Traffic' host: 'CockroachDB by HTTP' + name: 'CockroachDB: SQL: Traffic' - type: GRAPH_CLASSIC 'y': '10' @@ -3056,8 +3056,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: SQL statements' host: 'CockroachDB by HTTP' + name: 'CockroachDB: SQL statements' - type: GRAPH_CLASSIC x: '12' @@ -3073,8 +3073,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.statements.errors.rate host: 'CockroachDB by HTTP' + key: cockroachdb.sql.statements.errors.rate - type: GRAPH_CLASSIC 'y': '15' @@ -3089,8 +3089,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.statements.contention.rate host: 'CockroachDB by HTTP' + key: cockroachdb.sql.statements.contention.rate - type: GRAPH_CLASSIC x: '12' @@ -3106,8 +3106,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.statements.flows.active.rate host: 'CockroachDB by HTTP' + key: cockroachdb.sql.statements.flows.active.rate - type: GRAPH_CLASSIC 'y': '20' @@ -3122,8 +3122,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: SQL transactions' host: 'CockroachDB by HTTP' + name: 'CockroachDB: SQL transactions' - type: GRAPH_CLASSIC 'y': '25' @@ -3138,8 +3138,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.memory.sql host: 'CockroachDB by HTTP' + key: cockroachdb.memory.sql - type: GRAPH_CLASSIC x: '12' @@ -3155,8 +3155,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.schema_changes.rate host: 'CockroachDB by HTTP' + key: cockroachdb.sql.schema_changes.rate - type: GRAPH_CLASSIC 'y': '30' @@ -3171,8 +3171,8 @@ zabbix_export: type: ITEM name: itemid value: - key: cockroachdb.sql.statements.denials.rate host: 'CockroachDB by HTTP' + key: cockroachdb.sql.statements.denials.rate - uuid: aa41ca45023c4d0eb126596f89f20f98 name: Storage @@ -3200,8 +3200,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'CockroachDB: Storage [{#STORE}]: Capacity' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Storage [{#STORE}]: Capacity' - type: GRAPH_PROTOTYPE x: '12' @@ -3224,8 +3224,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'CockroachDB: Storage [{#STORE}]: Bytes' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Storage [{#STORE}]: Bytes' - type: GRAPH_PROTOTYPE 'y': '5' @@ -3248,8 +3248,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.rocksdb.[{#STORE},read_amp]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.rocksdb.[{#STORE},read_amp]' - type: GRAPH_PROTOTYPE x: '12' @@ -3273,8 +3273,8 @@ zabbix_export: type: ITEM_PROTOTYPE name: itemid value: - key: 'cockroachdb.rocksdb.[{#STORE},sstables]' host: 'CockroachDB by HTTP' + key: 'cockroachdb.rocksdb.[{#STORE},sstables]' - type: GRAPH_CLASSIC 'y': '10' @@ -3289,8 +3289,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: File descriptors' host: 'CockroachDB by HTTP' + name: 'CockroachDB: File descriptors' - type: GRAPH_CLASSIC x: '12' @@ -3306,8 +3306,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'CockroachDB: Time series' host: 'CockroachDB by HTTP' + name: 'CockroachDB: Time series' valuemaps: - uuid: 2e7ddaadebce4b1089dcf01a91d01293 diff --git a/templates/db/gridgain_jmx/README.md b/templates/db/gridgain_jmx/README.md index 167b124c5f2..59b46efcac4 100644 --- a/templates/db/gridgain_jmx/README.md +++ b/templates/db/gridgain_jmx/README.md @@ -143,7 +143,7 @@ There are no template links in this template. |Name|Description|Expression|Severity|Dependencies and additional info| |----|-----------|----|----|----| -|GridGain [{#JMXIGNITEINSTANCENAME}]: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/GridGain by JMX/jmx["{#JMXOBJ}",UpTime])<10m` |INFO |<p>Manual close: YES</p> | +|GridGain [{#JMXIGNITEINSTANCENAME}]: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/GridGain by JMX/jmx["{#JMXOBJ}",UpTime])<10m` |INFO |<p>Manual close: YES</p> | |GridGain [{#JMXIGNITEINSTANCENAME}]: Failed to fetch info data |<p>Zabbix has not received data for items for the last 10 minutes.</p> |`nodata(/GridGain by JMX/jmx["{#JMXOBJ}",UpTime],10m)=1` |WARNING |<p>Manual close: YES</p> | |GridGain [{#JMXIGNITEINSTANCENAME}]: Version has changed |<p>GridGain [{#JMXIGNITEINSTANCENAME}] version has changed. Ack to close.</p> |`last(/GridGain by JMX/jmx["{#JMXOBJ}",FullVersion],#1)<>last(/GridGain by JMX/jmx["{#JMXOBJ}",FullVersion],#2) and length(last(/GridGain by JMX/jmx["{#JMXOBJ}",FullVersion]))>0` |INFO |<p>Manual close: YES</p> | |GridGain [{#JMXIGNITEINSTANCENAME}]: Server node left the topology |<p>One or more server node left the topology. Ack to close.</p> |`change(/GridGain by JMX/jmx["{#JMXOBJ}",TotalServerNodes])<0` |WARNING |<p>Manual close: YES</p> | diff --git a/templates/db/gridgain_jmx/template_db_gridgain_jmx.yaml b/templates/db/gridgain_jmx/template_db_gridgain_jmx.yaml index ff3fe2c2740..3cb59358413 100644 --- a/templates/db/gridgain_jmx/template_db_gridgain_jmx.yaml +++ b/templates/db/gridgain_jmx/template_db_gridgain_jmx.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:54:28Z' - groups: + date: '2022-06-07T19:33:22Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -931,7 +931,7 @@ zabbix_export: name: 'GridGain [{#JMXIGNITEINSTANCENAME}]: has been restarted' event_name: 'GridGain [{#JMXIGNITEINSTANCENAME}]: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/ignite_jmx/README.md b/templates/db/ignite_jmx/README.md index 52532393c33..3b0c420c4de 100644 --- a/templates/db/ignite_jmx/README.md +++ b/templates/db/ignite_jmx/README.md @@ -142,7 +142,7 @@ There are no template links in this template. |Name|Description|Expression|Severity|Dependencies and additional info| |----|-----------|----|----|----| -|Ignite [{#JMXIGNITEINSTANCENAME}]: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/Ignite by JMX/jmx["{#JMXOBJ}",UpTime])<10m` |INFO |<p>Manual close: YES</p> | +|Ignite [{#JMXIGNITEINSTANCENAME}]: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/Ignite by JMX/jmx["{#JMXOBJ}",UpTime])<10m` |INFO |<p>Manual close: YES</p> | |Ignite [{#JMXIGNITEINSTANCENAME}]: Failed to fetch info data |<p>Zabbix has not received data for items for the last 10 minutes.</p> |`nodata(/Ignite by JMX/jmx["{#JMXOBJ}",UpTime],10m)=1` |WARNING |<p>Manual close: YES</p> | |Ignite [{#JMXIGNITEINSTANCENAME}]: Version has changed |<p>Ignite [{#JMXIGNITEINSTANCENAME}] version has changed. Ack to close.</p> |`last(/Ignite by JMX/jmx["{#JMXOBJ}",FullVersion],#1)<>last(/Ignite by JMX/jmx["{#JMXOBJ}",FullVersion],#2) and length(last(/Ignite by JMX/jmx["{#JMXOBJ}",FullVersion]))>0` |INFO |<p>Manual close: YES</p> | |Ignite [{#JMXIGNITEINSTANCENAME}]: Server node left the topology |<p>One or more server node left the topology. Ack to close.</p> |`change(/Ignite by JMX/jmx["{#JMXOBJ}",TotalServerNodes])<0` |WARNING |<p>Manual close: YES</p> | diff --git a/templates/db/ignite_jmx/template_db_ignite_jmx.yaml b/templates/db/ignite_jmx/template_db_ignite_jmx.yaml index 78bdadfc40e..6a4c1956648 100644 --- a/templates/db/ignite_jmx/template_db_ignite_jmx.yaml +++ b/templates/db/ignite_jmx/template_db_ignite_jmx.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:54:40Z' - groups: + date: '2022-06-07T19:33:32Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1036,7 +1036,7 @@ zabbix_export: name: 'Ignite [{#JMXIGNITEINSTANCENAME}]: has been restarted' event_name: 'Ignite [{#JMXIGNITEINSTANCENAME}]: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/influxdb_http/README.md b/templates/db/influxdb_http/README.md index acac1b11d3e..a0fcf6f3ed4 100644 --- a/templates/db/influxdb_http/README.md +++ b/templates/db/influxdb_http/README.md @@ -88,7 +88,7 @@ There are no template links in this template. |----|-----------|----|----|----| |InfluxDB: Health check was failed |<p>The InfluxDB instance is not available or unhealthy.</p> |`last(/InfluxDB by HTTP/influx.healthcheck)=0` |HIGH | | |InfluxDB: Version has changed |<p>InfluxDB version has changed. Ack to close.</p> |`last(/InfluxDB by HTTP/influxdb.version,#1)<>last(/InfluxDB by HTTP/influxdb.version,#2) and length(last(/InfluxDB by HTTP/influxdb.version))>0` |INFO |<p>Manual close: YES</p> | -|InfluxDB: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/InfluxDB by HTTP/influxdb.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|InfluxDB: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/InfluxDB by HTTP/influxdb.uptime)<10m` |INFO |<p>Manual close: YES</p> | |InfluxDB: Too many tasks failure runs |<p>"Number of failure runs completed across all tasks is too high."</p> |`min(/InfluxDB by HTTP/influxdb.task_executor_complete.failed.rate,5m)>{$INFLUXDB.TASK.RUN.FAIL.MAX.WARN}` |WARNING | | |InfluxDB: [{#ORG_NAME}]: Too many requests failures |<p>Too many query requests failed.</p> |`min(/InfluxDB by HTTP/influxdb.org.query_request.failed.rate["{#ORG_NAME}"],5m)>{$INFLUXDB.REQ.FAIL.MAX.WARN}` |WARNING | | diff --git a/templates/db/influxdb_http/template_db_influxdb_http.yaml b/templates/db/influxdb_http/template_db_influxdb_http.yaml index cab2fa0600d..7bba4becdee 100644 --- a/templates/db/influxdb_http/template_db_influxdb_http.yaml +++ b/templates/db/influxdb_http/template_db_influxdb_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:54:42Z' - groups: + date: '2022-06-07T19:33:34Z' + template_groups: - uuid: a571c0d144b14fd4a87a9d9b2aa9fcd6 name: Templates/Applications @@ -433,7 +433,7 @@ zabbix_export: name: 'InfluxDB: has been restarted' event_name: 'InfluxDB: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/mongodb/template_db_mongodb.yaml b/templates/db/mongodb/template_db_mongodb.yaml index 163dbe1b2a4..1e9bffead0f 100644 --- a/templates/db/mongodb/template_db_mongodb.yaml +++ b/templates/db/mongodb/template_db_mongodb.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-05-06T14:09:10Z' - groups: + date: '2022-06-07T19:36:23Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases diff --git a/templates/db/mongodb_cluster/template_db_mongodb_cluster.xml b/templates/db/mongodb_cluster/template_db_mongodb_cluster.xml new file mode 100644 index 00000000000..115d5734a0e --- /dev/null +++ b/templates/db/mongodb_cluster/template_db_mongodb_cluster.xml @@ -0,0 +1,2168 @@ +<?xml version="1.0" encoding="UTF-8"?> +<zabbix_export> + <version>6.2</version> + <date>2022-06-07T17:16:12Z</date> + <template_groups> + <template_group> + <uuid>748ad4d098d447d492bb935c907f652f</uuid> + <name>Templates/Databases</name> + </template_group> + </template_groups> + <host_groups> + <host_group> + <uuid>748ad4d098d447d492bb935c907f652f</uuid> + <name>Databases</name> + </host_group> + </host_groups> + <templates> + <template> + <uuid>d38b271797bd41f2ad8c79d83b9d8d9c</uuid> + <template>MongoDB cluster by Zabbix agent 2</template> + <name>MongoDB cluster by Zabbix agent 2</name> + <description>Get MongoDB metrics from plugin for the zabbix-agent2. + 1. Setup and configure zabbix-agent2 compiled with the MongoDB monitoring plugin. + 2. Set the {$MONGODB.CONNSTRING} such as <protocol(host:port)> or named session. + 3. Set the user name and password in host macros ({$MONGODB.USER}, {$MONGODB.PASSWORD}) if you want to override parameters from the Zabbix agent configuration file. + + All sharded Mongodb nodes (mongod) will be discovered with attached template "MongoDB node". + +You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback/420659-discussion-thread-for-official-zabbix-template-db-mongodb + +Template tooling version used: 0.41</description> + <groups> + <group> + <name>Templates/Databases</name> + </group> + </groups> + <items> + <item> + <uuid>78db5504896649198605e140abb942be</uuid> + <name>MongoDB cluster: Configserver heartbeat</name> + <type>DEPENDENT</type> + <key>mongodb.config_server_heartbeat</key> + <delay>0</delay> + <history>7d</history> + <units>s</units> + <description>Difference between the latest optime of the CSRS primary that the mongos has seen and cluster time.</description> + <preprocessing> + <step> + <type>JAVASCRIPT</type> + <parameters> + <parameter>data = JSON.parse(value); +return (data["$clusterTime"].clusterTime.T - data.sharding.lastSeenConfigServerOpTime.ts.T);</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>configserver</value> + </tag> + </tags> + </item> + <item> + <uuid>281e5a1a19dc402a992331252b27ee63</uuid> + <name>MongoDB cluster: Connection pool: available</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.available</key> + <delay>0</delay> + <history>7d</history> + <description>The total number of available outgoing connections from the current mongos instance to other members of the sharded cluster.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.totalAvailable</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>58522550e8bc4f479681d961ba789b92</uuid> + <name>MongoDB cluster: Connection pool: client connections</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.client</key> + <delay>0</delay> + <history>7d</history> + <description>The number of active and stored outgoing synchronous connections from the current mongos instance to other members of the sharded cluster.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.numClientConnections</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>9b9d601d2d5c4d8da5d97c2785d8e0fa</uuid> + <name>MongoDB cluster: Connection pool: created, rate</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.created.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The total number of outgoing connections created per second by the current mongos instance to other members of the sharded cluster.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.totalCreated</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>9394a15a25e342688335b7d83db25b2d</uuid> + <name>MongoDB cluster: Connection pool: in use</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.in_use</key> + <delay>0</delay> + <history>7d</history> + <description>Reports the total number of outgoing connections from the current mongos instance to other members of the sharded cluster set that are currently in use.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.totalInUse</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>22c66363ffae4ae2b436a26b8ecca3ab</uuid> + <name>MongoDB cluster: Connection pool: refreshing</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.refreshing</key> + <delay>0</delay> + <history>7d</history> + <description>Reports the total number of outgoing connections from the current mongos instance to other members of the sharded cluster that are currently being refreshed.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.totalRefreshing</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>55dbfe5d52c44954b9e5669a043f10b4</uuid> + <name>MongoDB cluster: Connection pool: scoped</name> + <type>DEPENDENT</type> + <key>mongodb.connection_pool.scoped</key> + <delay>0</delay> + <history>7d</history> + <description>Number of active and stored outgoing scoped synchronous connections from the current mongos instance to other members of the sharded cluster.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.numAScopedConnections</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>fccb23cdee01483cabe6ef14a532664b</uuid> + <name>MongoDB cluster: Connections, active</name> + <type>DEPENDENT</type> + <key>mongodb.connections.active</key> + <delay>0</delay> + <history>7d</history> + <description>"The number of active client connections to the server. +Active client connections refers to client connections that currently have operations in progress. +Available starting in 4.0.7, 0 for older versions."</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.connections.active</parameter> + </parameters> + <error_handler>CUSTOM_VALUE</error_handler> + <error_handler_params>0</error_handler_params> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>1f881cbd515d462eb5839fe4e1e21ee1</uuid> + <name>MongoDB cluster: Connections, available</name> + <type>DEPENDENT</type> + <key>mongodb.connections.available</key> + <delay>0</delay> + <history>7d</history> + <description>"The number of unused incoming connections available."</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.connections.available</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>eae86b6f98db49099259a466b78d1c59</uuid> + <event_name>MongoDB cluster: Available connections less then {$MONGODB.CONNS.AVAILABLE.MIN.WARN}</event_name> + <expression>max(/MongoDB cluster by Zabbix agent 2/mongodb.connections.available,5m)<{$MONGODB.CONNS.AVAILABLE.MIN.WARN}</expression> + <name>MongoDB cluster: Available connections is low</name> + <priority>WARNING</priority> + <description>"Too few available connections. +Consider this value in combination with the value of connections current to understand the connection load on the database"</description> + <tags> + <tag> + <tag>scope</tag> + <value>capacity</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + <item> + <uuid>087d1a405b7a456692a52b0d20c43eb3</uuid> + <name>MongoDB cluster: Connections, current</name> + <type>DEPENDENT</type> + <key>mongodb.connections.current</key> + <delay>0</delay> + <history>7d</history> + <description>"The number of incoming connections from clients to the database server. +This number includes the current shell session"</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.connections.current</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>18ed07f0efb54f55970483d15613d320</uuid> + <name>MongoDB cluster: New connections, rate</name> + <type>DEPENDENT</type> + <key>mongodb.connections.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>"Rate of all incoming connections created to the server."</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.connections.totalCreated</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + </tags> + </item> + <item> + <uuid>f34fcc3866b446748b7a8d11311edd82</uuid> + <name>MongoDB cluster: Get mongodb.connpool.stats</name> + <key>mongodb.connpool.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <history>0</history> + <trends>0</trends> + <value_type>TEXT</value_type> + <description>Returns current info about connpool.stats.</description> + <tags> + <tag> + <tag>component</tag> + <value>connections</value> + </tag> + <tag> + <tag>component</tag> + <value>raw</value> + </tag> + </tags> + </item> + <item> + <uuid>22ca0c06006b49009f25fcd829f1b5bf</uuid> + <name>MongoDB cluster: Cursor: open pinned</name> + <type>DEPENDENT</type> + <key>mongodb.cursor.open.pinned</key> + <delay>0</delay> + <history>7d</history> + <description>Number of pinned open cursors.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.metrics.cursor.open.pinned</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>cursors</value> + </tag> + </tags> + </item> + <item> + <uuid>45bfa997dab9498e8e3851de750e21a2</uuid> + <name>MongoDB cluster: Cursor: open total</name> + <type>DEPENDENT</type> + <key>mongodb.cursor.open.total</key> + <delay>0</delay> + <history>7d</history> + <description>Number of cursors that MongoDB is maintaining for clients.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.metrics.cursor.open.total</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>cursors</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>67db1f543818476ca0b07e2cc1709452</uuid> + <event_name>MongoDB cluster: Too many cursors opened by MongoDB for clients (over {$MONGODB.CURSOR.OPEN.MAX.WARN} in 5m)</event_name> + <expression>min(/MongoDB cluster by Zabbix agent 2/mongodb.cursor.open.total,5m)>{$MONGODB.CURSOR.OPEN.MAX.WARN}</expression> + <name>MongoDB cluster: Too many cursors opened by MongoDB for clients</name> + <priority>WARNING</priority> + <tags> + <tag> + <tag>scope</tag> + <value>capacity</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + <item> + <uuid>5d3a3c724a6a45fb99a0af5330bf9cf2</uuid> + <name>MongoDB cluster: Cursor: timed out, rate</name> + <type>DEPENDENT</type> + <key>mongodb.cursor.timed_out.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>Number of cursors that time out, per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.metrics.cursor.timedOut</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>cursors</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>5ea8cf9c955940a6a580cd6f4bb2cc78</uuid> + <event_name>MongoDB cluster: Too many cursors are timing out (over {$MONGODB.CURSOR.TIMEOUT.MAX.WARN} per second in 5m)</event_name> + <expression>min(/MongoDB cluster by Zabbix agent 2/mongodb.cursor.timed_out.rate,5m)>{$MONGODB.CURSOR.TIMEOUT.MAX.WARN}</expression> + <name>MongoDB cluster: Too many cursors are timing out</name> + <priority>WARNING</priority> + <tags> + <tag> + <tag>scope</tag> + <value>performance</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + <item> + <uuid>110685e463e141ca800b2638e3532d51</uuid> + <name>MongoDB cluster: Jumbo chunks</name> + <key>mongodb.jumbo_chunks.count["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <history>7d</history> + <description>Total number of 'jumbo' chunks in the mongo cluster.</description> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + </tags> + </item> + <item> + <uuid>fa28a98992e74cdf8c54b4faa01de89a</uuid> + <name>MongoDB cluster: Last seen configserver</name> + <type>DEPENDENT</type> + <key>mongodb.last_seen_config_server</key> + <delay>0</delay> + <history>7d</history> + <units>unixtime</units> + <description>The latest optime of the CSRS primary that the mongos has seen.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.sharding.lastSeenConfigServerOpTime.ts.T</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>configserver</value> + </tag> + </tags> + </item> + <item> + <uuid>df2423ff36e24357809c7a7211144898</uuid> + <name>MongoDB cluster: Architecture</name> + <type>DEPENDENT</type> + <key>mongodb.mem.bits</key> + <delay>0</delay> + <history>7d</history> + <units>bit</units> + <description>A number, either 64 or 32, that indicates whether the MongoDB instance is compiled for 64-bit or 32-bit architecture.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.mem.bits</parameter> + </parameters> + </step> + <step> + <type>DISCARD_UNCHANGED_HEARTBEAT</type> + <parameters> + <parameter>3h</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + </tags> + </item> + <item> + <uuid>f6a06e0d7cf84cc1a40d8d2dcde7b01a</uuid> + <name>MongoDB cluster: Memory: resident</name> + <type>DEPENDENT</type> + <key>mongodb.mem.resident</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Amount of memory currently used by the database process.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.mem.resident</parameter> + </parameters> + </step> + <step> + <type>MULTIPLIER</type> + <parameters> + <parameter>1048576</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>memory</value> + </tag> + </tags> + </item> + <item> + <uuid>2c5548ae9c614efb81e58a2e4ec3d3e4</uuid> + <name>MongoDB cluster: Memory: virtual</name> + <type>DEPENDENT</type> + <key>mongodb.mem.virtual</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Amount of virtual memory used by the mongos process.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.mem.virtual</parameter> + </parameters> + </step> + <step> + <type>MULTIPLIER</type> + <parameters> + <parameter>1048576</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>memory</value> + </tag> + </tags> + </item> + <item> + <uuid>16925e0ca40747d1818e512962d31a83</uuid> + <name>MongoDB cluster: Cursor: open no timeout</name> + <type>DEPENDENT</type> + <key>mongodb.metrics.cursor.open.no_timeout</key> + <delay>0</delay> + <history>7d</history> + <description>Number of open cursors with the option DBQuery.Option.noTimeout set to prevent timeout after a period of inactivity.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.metrics.cursor.open.noTimeout</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>cursors</value> + </tag> + </tags> + </item> + <item> + <uuid>59481dcb9b5a487985297e2f41f72dd1</uuid> + <name>MongoDB cluster: Bytes in, rate</name> + <type>DEPENDENT</type> + <key>mongodb.network.bytes_in.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The total number of bytes that the server has received over network connections initiated by clients or other mongod/mongos instances per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.network.bytesIn</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>network</value> + </tag> + </tags> + </item> + <item> + <uuid>13cba18ba344440bba4371585fd8e4c0</uuid> + <name>MongoDB cluster: Bytes out, rate</name> + <type>DEPENDENT</type> + <key>mongodb.network.bytes_out.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <units>Bps</units> + <description>The total number of bytes that the server has sent over network connections initiated by clients or other mongod/mongos instances per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.network.bytesOut</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>network</value> + </tag> + </tags> + </item> + <item> + <uuid>eb821875b59c4bf8bc98f9afec146e88</uuid> + <name>MongoDB cluster: Requests, rate</name> + <type>DEPENDENT</type> + <key>mongodb.network.numRequests.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <units>!Rps</units> + <description>Number of distinct requests that the server has received per second</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.network.numRequests</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>network</value> + </tag> + </tags> + </item> + <item> + <uuid>b98fb6d98b9a4282ba0b2d9770722035</uuid> + <name>MongoDB cluster: Operations: command</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.command.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>"The number of commands issued to the database per second. +Counts all commands except the write commands: insert, update, and delete."</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.command</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>f4e917e9cdd3439abbe6ea7b9a9034b7</uuid> + <name>MongoDB cluster: Operations: delete</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.delete.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The number of delete operations the mongos instance per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.delete</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>165d5a180ed541ba9a19916134962368</uuid> + <name>MongoDB cluster: Operations: getmore, rate</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.getmore.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>"The number of “getmore” operations the mongos per second. This counter can be high even if the query count is low. +Secondary nodes send getMore operations as part of the replication process."</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.getmore</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>021a00004efe434a9b2f316c0d25c175</uuid> + <name>MongoDB cluster: Operations: insert, rate</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.insert.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The number of insert operations received the mongos instance per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.insert</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>0866b3b6bc1748a98e8bfd9308152304</uuid> + <name>MongoDB cluster: Operations: query, rate</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.query.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The number of queries received the mongos instance per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.query</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>329e6d41de1c47dba8f3f9d287c93eda</uuid> + <name>MongoDB cluster: Operations: update, rate</name> + <type>DEPENDENT</type> + <key>mongodb.opcounters.update.rate</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>The number of update operations the mongos instance per second.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.opcounters.update</parameter> + </parameters> + </step> + <step> + <type>CHANGE_PER_SECOND</type> + <parameters> + <parameter/> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>operations</value> + </tag> + </tags> + </item> + <item> + <uuid>ff979eb9ba4a4420a753913df5431219</uuid> + <name>MongoDB cluster: Ping</name> + <key>mongodb.ping["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <delay>30s</delay> + <history>7d</history> + <description>Test if a connection is alive or not.</description> + <valuemap> + <name>Service state</name> + </valuemap> + <preprocessing> + <step> + <type>DISCARD_UNCHANGED_HEARTBEAT</type> + <parameters> + <parameter>30m</parameter> + </parameters> + </step> + </preprocessing> + <tags> + <tag> + <tag>component</tag> + <value>health</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>cd74289970204ca281c5bc7d5c695e95</uuid> + <expression>last(/MongoDB cluster by Zabbix agent 2/mongodb.ping["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"])=0</expression> + <name>MongoDB cluster: Connection to mongos proxy is unavailable</name> + <priority>HIGH</priority> + <description>Connection to mongos proxy instance is currently unavailable.</description> + <tags> + <tag> + <tag>scope</tag> + <value>availability</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + <item> + <uuid>b8c6dadff060447e9718b49fdc796d8d</uuid> + <name>MongoDB cluster: Get server status</name> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <history>0</history> + <trends>0</trends> + <value_type>TEXT</value_type> + <description>The mongos statistic</description> + <tags> + <tag> + <tag>component</tag> + <value>raw</value> + </tag> + </tags> + </item> + <item> + <uuid>e88da2ca6ccc4fdfa256fa51e050792d</uuid> + <name>MongoDB cluster: Uptime</name> + <type>DEPENDENT</type> + <key>mongodb.uptime</key> + <delay>0</delay> + <history>7d</history> + <units>s</units> + <description>Number of seconds since Mongos server start</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.uptime</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>ee70d6da232a4068b574c9c147c622c9</uuid> + <event_name>MongoDB cluster: Failed to fetch info data (or no data for 10m)</event_name> + <expression>nodata(/MongoDB cluster by Zabbix agent 2/mongodb.uptime,10m)=1</expression> + <name>MongoDB cluster: Failed to fetch info data</name> + <priority>WARNING</priority> + <description>Zabbix has not received data for items for the last 10 minutes</description> + <manual_close>YES</manual_close> + <dependencies> + <dependency> + <name>MongoDB cluster: Connection to mongos proxy is unavailable</name> + <expression>last(/MongoDB cluster by Zabbix agent 2/mongodb.ping["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"])=0</expression> + </dependency> + </dependencies> + <tags> + <tag> + <tag>scope</tag> + <value>notice</value> + </tag> + </tags> + </trigger> + <trigger> + <uuid>99ff438a7e3e4b0a8190b2ab9f41f076</uuid> + <event_name>MongoDB cluster: has been restarted (uptime < 10m)</event_name> + <expression>last(/MongoDB cluster by Zabbix agent 2/mongodb.uptime)<10m</expression> + <name>MongoDB cluster: has been restarted</name> + <priority>INFO</priority> + <description>Uptime is less than 10 minutes.</description> + <manual_close>YES</manual_close> + <tags> + <tag> + <tag>scope</tag> + <value>notice</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + <item> + <uuid>dda1722d6e6b4189978fd44ace0f8f86</uuid> + <name>MongoDB cluster: Mongos version</name> + <type>DEPENDENT</type> + <key>mongodb.version</key> + <delay>0</delay> + <history>7d</history> + <trends>0</trends> + <value_type>CHAR</value_type> + <description>Version of the Mongos server</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.version</parameter> + </parameters> + </step> + <step> + <type>DISCARD_UNCHANGED_HEARTBEAT</type> + <parameters> + <parameter>3h</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.server.status["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + </tags> + <triggers> + <trigger> + <uuid>921ee489887943838d69558f103ad646</uuid> + <event_name>MongoDB cluster: Version has changed (new version: {ITEM.VALUE})</event_name> + <expression>last(/MongoDB cluster by Zabbix agent 2/mongodb.version,#1)<>last(/MongoDB cluster by Zabbix agent 2/mongodb.version,#2) and length(last(/MongoDB cluster by Zabbix agent 2/mongodb.version))>0</expression> + <name>MongoDB cluster: Version has changed</name> + <priority>INFO</priority> + <description>MongoDB cluster version has changed. Ack to close.</description> + <manual_close>YES</manual_close> + <tags> + <tag> + <tag>scope</tag> + <value>notice</value> + </tag> + </tags> + </trigger> + </triggers> + </item> + </items> + <discovery_rules> + <discovery_rule> + <uuid>eb57a506cc5640a79e6df51179321ba0</uuid> + <name>Config servers discovery</name> + <key>mongodb.cfg.discovery["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <delay>30m</delay> + <description>Discovery shared cluster config servers.</description> + <item_prototypes/> + <host_prototypes> + <host_prototype> + <uuid>809db5d8d32a45898e8401f288a42fac</uuid> + <host>{#HOSTNAME}</host> + <name>{#HOSTNAME}</name> + <status>ENABLED</status> + <discover>DISCOVER</discover> + <group_links> + <group_link> + <group> + <name>Databases</name> + </group> + </group_link> + </group_links> + <group_prototypes> + <group_prototype> + <name>MongoDB sharded cluster/{#REPLICASET}</name> + </group_prototype> + </group_prototypes> + <templates> + <template> + <name>MongoDB node by Zabbix agent 2</name> + </template> + </templates> + <macros> + <macro> + <macro>{$MONGODB.CONNSTRING}</macro> + <value>{#MONGOD_URI}</value> + <description>Connection string in the URI format (password is not used).</description> + </macro> + </macros> + </host_prototype> + </host_prototypes> + </discovery_rule> + <discovery_rule> + <uuid>61a19fbf4f9f4c2f9ad215b08d41e544</uuid> + <name>Collection discovery</name> + <key>mongodb.collections.discovery["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <delay>30m</delay> + <filter> + <evaltype>AND</evaltype> + <conditions> + <condition> + <macro>{#DBNAME}</macro> + <value>{$MONGODB.LLD.FILTER.DB.MATCHES}</value> + <formulaid>A</formulaid> + </condition> + <condition> + <macro>{#DBNAME}</macro> + <value>{$MONGODB.LLD.FILTER.DB.NOT_MATCHES}</value> + <operator>NOT_MATCHES_REGEX</operator> + <formulaid>B</formulaid> + </condition> + <condition> + <macro>{#COLLECTION}</macro> + <value>{$MONGODB.LLD.FILTER.COLLECTION.MATCHES}</value> + <formulaid>C</formulaid> + </condition> + <condition> + <macro>{#COLLECTION}</macro> + <value>{$MONGODB.LLD.FILTER.COLLECTION.NOT_MATCHES}</value> + <operator>NOT_MATCHES_REGEX</operator> + <formulaid>D</formulaid> + </condition> + </conditions> + </filter> + <description>Collect collections metrics. +Note, depending on the number of DBs and collections this discovery operation may be expensive. Use filters with macros {$MONGODB.LLD.FILTER.DB.MATCHES}, {$MONGODB.LLD.FILTER.DB.NOT_MATCHES}, {$MONGODB.LLD.FILTER.COLLECTION.MATCHES}, {$MONGODB.LLD.FILTER.COLLECTION.NOT_MATCHES}.</description> + <item_prototypes> + <item_prototype> + <uuid>253af5ef7858482fbeaa0c06c033b47a</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Objects, avg size</name> + <type>DEPENDENT</type> + <key>mongodb.collection.avg_obj_size["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <units>B</units> + <description>The size of the average object in the collection in bytes.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.avgObjSize</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>objects</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>59465dc6e9384c7baf1a6239a6c66f0e</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Capped</name> + <type>DEPENDENT</type> + <key>mongodb.collection.capped["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <trends>0</trends> + <value_type>CHAR</value_type> + <description>Whether or not the collection is capped.</description> + <valuemap> + <name>MongoDB flag</name> + </valuemap> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.capped</parameter> + </parameters> + </step> + <step> + <type>BOOL_TO_DECIMAL</type> + <parameters/> + </step> + <step> + <type>DISCARD_UNCHANGED_HEARTBEAT</type> + <parameters> + <parameter>3h</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>03b8eb71502a4805902f7a5856e7c7b6</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Objects, count</name> + <type>DEPENDENT</type> + <key>mongodb.collection.count["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <description>Total number of objects in the collection.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.count</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>objects</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>294985df777b42e0a56a229366bbac5d</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Capped, max size</name> + <type>DEPENDENT</type> + <key>mongodb.collection.max_size["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Maximum size of a capped collection in bytes.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.maxSize</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>2a78fa441bef4523bd0fee4934fc7b55</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Capped, max number</name> + <type>DEPENDENT</type> + <key>mongodb.collection.max["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <description>Maximum number of documents in a capped collection.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.max</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>8da7cc960e8d42ccb3efe065fff5f0e9</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Indexes</name> + <type>DEPENDENT</type> + <key>mongodb.collection.nindexes["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <description>Total number of indices on the collection.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.nindexes</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>application</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>191a21d9a1b94b238009e31433dbaa38</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Size</name> + <type>DEPENDENT</type> + <key>mongodb.collection.size["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>The total size in bytes of the data in the collection plus the size of every indexes on the mongodb.collection.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.size</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>aa964be0bc5c4318bc92c3192c269d8e</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Get collection stats {#DBNAME}.{#COLLECTION}</name> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + <history>0</history> + <trends>0</trends> + <value_type>TEXT</value_type> + <description>Returns a variety of storage statistics for a given collection.</description> + <tags> + <tag> + <tag>component</tag> + <value>raw</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>ef82b9f814cd4917b3714e73d7ac87ac</uuid> + <name>MongoDB {#DBNAME}.{#COLLECTION}: Storage size</name> + <type>DEPENDENT</type> + <key>mongodb.collection.storage_size["{#DBNAME}","{#COLLECTION}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Total storage space allocated to this collection for document storage.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.storageSize</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.collection.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}","{#COLLECTION}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + <tag> + <tag>collection</tag> + <value>{#COLLECTION}</value> + </tag> + </tags> + </item_prototype> + </item_prototypes> + </discovery_rule> + <discovery_rule> + <uuid>25ece32c5f764461913f605ba3d7736a</uuid> + <name>Database discovery</name> + <key>mongodb.db.discovery["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <delay>30m</delay> + <filter> + <evaltype>AND</evaltype> + <conditions> + <condition> + <macro>{#DBNAME}</macro> + <value>{$MONGODB.LLD.FILTER.DB.MATCHES}</value> + <formulaid>A</formulaid> + </condition> + <condition> + <macro>{#DBNAME}</macro> + <value>{$MONGODB.LLD.FILTER.DB.NOT_MATCHES}</value> + <operator>NOT_MATCHES_REGEX</operator> + <formulaid>B</formulaid> + </condition> + </conditions> + </filter> + <description>Collect database metrics. +Note, depending on the number of DBs this discovery operation may be expensive. Use filters with macros {$MONGODB.LLD.FILTER.DB.MATCHES}, {$MONGODB.LLD.FILTER.DB.NOT_MATCHES}.</description> + <item_prototypes> + <item_prototype> + <uuid>6dea9a371b94402aad9f8c6d7fcc5761</uuid> + <name>MongoDB {#DBNAME}: Size, data</name> + <type>DEPENDENT</type> + <key>mongodb.db.data_size["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Total size of the data held in this database including the padding factor.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.dataSize</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>98c9e25c24b146aeaec4953913bb720a</uuid> + <name>MongoDB {#DBNAME}: Extents</name> + <type>DEPENDENT</type> + <key>mongodb.db.extents["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <description>Contains a count of the number of extents in the database across all collections.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.numExtents</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>collections</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>cfb3598af7f14911965d548ea815cb33</uuid> + <name>MongoDB {#DBNAME}: Size, file</name> + <type>DEPENDENT</type> + <key>mongodb.db.file_size["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Total size of the data held in this database including the padding factor (only available with the mmapv1 storage engine).</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.fileSize</parameter> + </parameters> + <error_handler>DISCARD_VALUE</error_handler> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>1716a51105f2415eb179a43022656e4a</uuid> + <name>MongoDB {#DBNAME}: Size, index</name> + <type>DEPENDENT</type> + <key>mongodb.db.index_size["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Total size of all indexes created on this database.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.indexSize</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>f28f2df7b1e64aea99b20ca8deda2a25</uuid> + <name>MongoDB {#DBNAME}: Objects, count</name> + <type>DEPENDENT</type> + <key>mongodb.db.objects["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <description>Number of objects (documents) in the database across all collections.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.objects</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>objects</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>ed3076f82f494b6e953a9a5a3199df06</uuid> + <name>MongoDB {#DBNAME}: Objects, avg size</name> + <type>DEPENDENT</type> + <key>mongodb.db.size["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <value_type>FLOAT</value_type> + <units>B</units> + <description>The average size of each document in bytes.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.avgObjSize</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>objects</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>7fbc424bca06451d9ed1fe689ea81bf9</uuid> + <name>MongoDB {#DBNAME}: Get db stats {#DBNAME}</name> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + <history>0</history> + <trends>0</trends> + <value_type>TEXT</value_type> + <description>Returns statistics reflecting the database system's state.</description> + <tags> + <tag> + <tag>component</tag> + <value>raw</value> + </tag> + <tag> + <tag>component</tag> + <value>database</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + <item_prototype> + <uuid>ae54fbae851b4b5a949611420fbc8ce0</uuid> + <name>MongoDB {#DBNAME}: Size, storage</name> + <type>DEPENDENT</type> + <key>mongodb.db.storage_size["{#DBNAME}"]</key> + <delay>0</delay> + <history>7d</history> + <units>B</units> + <description>Total amount of space allocated to collections in this database for document storage.</description> + <preprocessing> + <step> + <type>JSONPATH</type> + <parameters> + <parameter>$.storageSize</parameter> + </parameters> + </step> + </preprocessing> + <master_item> + <key>mongodb.db.stats["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}","{#DBNAME}"]</key> + </master_item> + <tags> + <tag> + <tag>component</tag> + <value>disk</value> + </tag> + <tag> + <tag>database</tag> + <value>{#DBNAME}</value> + </tag> + </tags> + </item_prototype> + </item_prototypes> + <graph_prototypes> + <graph_prototype> + <uuid>44e0e02d1e9a420b9dc917d8cf4bf983</uuid> + <name>MongoDB {#DBNAME}: Disk usage</name> + <graph_items> + <graph_item> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.db.index_size["{#DBNAME}"]</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.db.storage_size["{#DBNAME}"]</key> + </item> + </graph_item> + <graph_item> + <sortorder>2</sortorder> + <color>F63100</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.db.file_size["{#DBNAME}"]</key> + </item> + </graph_item> + <graph_item> + <sortorder>3</sortorder> + <color>A54F10</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.db.data_size["{#DBNAME}"]</key> + </item> + </graph_item> + </graph_items> + </graph_prototype> + </graph_prototypes> + </discovery_rule> + <discovery_rule> + <uuid>a8bcea1509974c0f9d0051591e92cd5a</uuid> + <name>Shards discovery</name> + <key>mongodb.sh.discovery["{$MONGODB.CONNSTRING}","{$MONGODB.USER}","{$MONGODB.PASSWORD}"]</key> + <delay>30m</delay> + <description>Discovery shared cluster hosts.</description> + <item_prototypes/> + <host_prototypes> + <host_prototype> + <uuid>3fcd3244b1234186bda9a35c8f61c850</uuid> + <host>{#HOSTNAME}</host> + <name>{#HOSTNAME}</name> + <status>ENABLED</status> + <discover>DISCOVER</discover> + <group_links> + <group_link> + <group> + <name>Databases</name> + </group> + </group_link> + </group_links> + <group_prototypes> + <group_prototype> + <name>MongoDB sharded cluster/{#ID}</name> + </group_prototype> + </group_prototypes> + <templates> + <template> + <name>MongoDB node by Zabbix agent 2</name> + </template> + </templates> + <macros> + <macro> + <macro>{$MONGODB.CONNSTRING}</macro> + <value>{#MONGOD_URI}</value> + <description>Connection string in the URI format (password is not used).</description> + </macro> + </macros> + </host_prototype> + </host_prototypes> + </discovery_rule> + </discovery_rules> + <tags> + <tag> + <tag>class</tag> + <value>database</value> + </tag> + <tag> + <tag>target</tag> + <value>mongodb-cluster</value> + </tag> + </tags> + <macros> + <macro> + <macro>{$MONGODB.CONNS.AVAILABLE.MIN.WARN}</macro> + <value>1000</value> + <description>Minimum number of available connections</description> + </macro> + <macro> + <macro>{$MONGODB.CONNSTRING}</macro> + <value>tcp://localhost:27017</value> + <description>Connection string in the URI format (password is not used). This param overwrites a value configured in the "Server" option of the configuration file (if it's set), otherwise, the plugin's default value is used: "tcp://localhost:27017"</description> + </macro> + <macro> + <macro>{$MONGODB.CURSOR.OPEN.MAX.WARN}</macro> + <value>10000</value> + <description>Maximum number of open cursors</description> + </macro> + <macro> + <macro>{$MONGODB.CURSOR.TIMEOUT.MAX.WARN}</macro> + <value>1</value> + <description>Maximum number of cursors timing out per second</description> + </macro> + <macro> + <macro>{$MONGODB.LLD.FILTER.COLLECTION.MATCHES}</macro> + <value>.*</value> + <description>Filter of discoverable collections</description> + </macro> + <macro> + <macro>{$MONGODB.LLD.FILTER.COLLECTION.NOT_MATCHES}</macro> + <value>CHANGE_IF_NEEDED</value> + <description>Filter to exclude discovered collections</description> + </macro> + <macro> + <macro>{$MONGODB.LLD.FILTER.DB.MATCHES}</macro> + <value>.*</value> + <description>Filter of discoverable databases</description> + </macro> + <macro> + <macro>{$MONGODB.LLD.FILTER.DB.NOT_MATCHES}</macro> + <value>(admin|config|local)</value> + <description>Filter to exclude discovered databases</description> + </macro> + <macro> + <macro>{$MONGODB.PASSWORD}</macro> + <description>MongoDB user password</description> + </macro> + <macro> + <macro>{$MONGODB.USER}</macro> + <description>MongoDB username</description> + </macro> + </macros> + <valuemaps> + <valuemap> + <uuid>2014769595e34d4bb18dbcf4d9eaf112</uuid> + <name>MongoDB flag</name> + <mappings> + <mapping> + <value>0</value> + <newvalue>False</newvalue> + </mapping> + <mapping> + <value>1</value> + <newvalue>True</newvalue> + </mapping> + </mappings> + </valuemap> + <valuemap> + <uuid>3cedce4712fa4a3eba63ccd7a790ecf6</uuid> + <name>Service state</name> + <mappings> + <mapping> + <value>0</value> + <newvalue>Down</newvalue> + </mapping> + <mapping> + <value>1</value> + <newvalue>Up</newvalue> + </mapping> + </mappings> + </valuemap> + </valuemaps> + </template> + </templates> + <graphs> + <graph> + <uuid>311d33ada96e4910a350e62abc6d5321</uuid> + <name>MongoDB cluster: Connection pool</name> + <graph_items> + <graph_item> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connection_pool.available</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connection_pool.refreshing</key> + </item> + </graph_item> + <graph_item> + <sortorder>2</sortorder> + <color>F63100</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connection_pool.in_use</key> + </item> + </graph_item> + <graph_item> + <sortorder>3</sortorder> + <color>A54F10</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connection_pool.scoped</key> + </item> + </graph_item> + <graph_item> + <sortorder>4</sortorder> + <color>FC6EA3</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connection_pool.client</key> + </item> + </graph_item> + </graph_items> + </graph> + <graph> + <uuid>71a5a2d563d64bceacd564fe25b4d49e</uuid> + <name>MongoDB cluster: Connections</name> + <graph_items> + <graph_item> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connections.available</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connections.active</key> + </item> + </graph_item> + <graph_item> + <sortorder>2</sortorder> + <color>F63100</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connections.current</key> + </item> + </graph_item> + <graph_item> + <sortorder>3</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>A54F10</color> + <yaxisside>RIGHT</yaxisside> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.connections.rate</key> + </item> + </graph_item> + </graph_items> + </graph> + <graph> + <uuid>b4277ddaf3c5486cacba0f9b7208c5b2</uuid> + <name>MongoDB cluster: Cursors</name> + <graph_items> + <graph_item> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.cursor.open.total</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.cursor.open.pinned</key> + </item> + </graph_item> + <graph_item> + <sortorder>2</sortorder> + <color>F63100</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.metrics.cursor.open.no_timeout</key> + </item> + </graph_item> + </graph_items> + </graph> + <graph> + <uuid>d612246739784b9b9403dee6024493ce</uuid> + <name>MongoDB cluster: Network</name> + <graph_items> + <graph_item> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.network.bytes_out.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.network.bytes_in.rate</key> + </item> + </graph_item> + </graph_items> + </graph> + <graph> + <uuid>4228deefccae4cd2959b183ba3e36295</uuid> + <name>MongoDB cluster: Operations rate</name> + <graph_items> + <graph_item> + <drawtype>BOLD_LINE</drawtype> + <color>1A7C11</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.query.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>1</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>2774A4</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.insert.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>2</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>F63100</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.getmore.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>3</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>A54F10</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.update.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>4</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>FC6EA3</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.delete.rate</key> + </item> + </graph_item> + <graph_item> + <sortorder>5</sortorder> + <drawtype>BOLD_LINE</drawtype> + <color>6C59DC</color> + <item> + <host>MongoDB cluster by Zabbix agent 2</host> + <key>mongodb.opcounters.command.rate</key> + </item> + </graph_item> + </graph_items> + </graph> + </graphs> +</zabbix_export> diff --git a/templates/db/mongodb_cluster/template_db_mongodb_cluster.yaml b/templates/db/mongodb_cluster/template_db_mongodb_cluster.yaml index bccdf2e192e..4d054b352b7 100644 --- a/templates/db/mongodb_cluster/template_db_mongodb_cluster.yaml +++ b/templates/db/mongodb_cluster/template_db_mongodb_cluster.yaml @@ -1,10 +1,14 @@ zabbix_export: version: '6.2' - date: '2022-05-06T14:17:41Z' - groups: + date: '2022-06-07T19:36:23Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases + host_groups: + - + uuid: 748ad4d098d447d492bb935c907f652f + name: Databases templates: - uuid: d38b271797bd41f2ad8c79d83b9d8d9c @@ -854,7 +858,7 @@ zabbix_export: group_links: - group: - name: Templates/Databases + name: Databases group_prototypes: - name: 'MongoDB sharded cluster/{#REPLICASET}' @@ -1378,7 +1382,7 @@ zabbix_export: group_links: - group: - name: Templates/Databases + name: Databases group_prototypes: - name: 'MongoDB sharded cluster/{#ID}' diff --git a/templates/db/mssql_odbc/template_db_mssql_odbc.yaml b/templates/db/mssql_odbc/template_db_mssql_odbc.yaml index d77d61794a6..2344880d056 100644 --- a/templates/db/mssql_odbc/template_db_mssql_odbc.yaml +++ b/templates/db/mssql_odbc/template_db_mssql_odbc.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-06-07T10:51:02Z' - groups: + date: '2022-06-07T19:36:28Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases diff --git a/templates/db/mysql_agent/template_db_mysql_agent.yaml b/templates/db/mysql_agent/template_db_mysql_agent.yaml index 6f273d9be98..c64f24a130d 100644 --- a/templates/db/mysql_agent/template_db_mysql_agent.yaml +++ b/templates/db/mysql_agent/template_db_mysql_agent.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:10Z' - groups: + date: '2022-06-07T19:36:29Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1734,8 +1734,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Operations' host: 'MySQL by Zabbix agent' + name: 'MySQL: Operations' - type: GRAPH_CLASSIC x: '12' @@ -1750,8 +1750,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Queries' host: 'MySQL by Zabbix agent' + name: 'MySQL: Queries' - type: GRAPH_CLASSIC 'y': '5' @@ -1766,8 +1766,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Connections' host: 'MySQL by Zabbix agent' + name: 'MySQL: Connections' - type: GRAPH_CLASSIC x: '12' @@ -1783,8 +1783,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Bandwidth' host: 'MySQL by Zabbix agent' + name: 'MySQL: Bandwidth' - type: GRAPH_CLASSIC 'y': '10' @@ -1799,8 +1799,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: InnoDB buffer pool' host: 'MySQL by Zabbix agent' + name: 'MySQL: InnoDB buffer pool' - type: GRAPH_CLASSIC x: '12' @@ -1816,8 +1816,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Threads' host: 'MySQL by Zabbix agent' + name: 'MySQL: Threads' valuemaps: - uuid: 4f2d7ca3c89246c6b691557447230031 diff --git a/templates/db/mysql_agent2/template_db_mysql_agent2.yaml b/templates/db/mysql_agent2/template_db_mysql_agent2.yaml index e176bd1ecd1..7e9c0fa85cd 100644 --- a/templates/db/mysql_agent2/template_db_mysql_agent2.yaml +++ b/templates/db/mysql_agent2/template_db_mysql_agent2.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:11Z' - groups: + date: '2022-06-07T19:36:29Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1722,8 +1722,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Operations' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: Operations' - type: GRAPH_CLASSIC x: '12' @@ -1738,8 +1738,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Queries' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: Queries' - type: GRAPH_CLASSIC 'y': '5' @@ -1754,8 +1754,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Connections' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: Connections' - type: GRAPH_CLASSIC x: '12' @@ -1771,8 +1771,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Bandwidth' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: Bandwidth' - type: GRAPH_CLASSIC 'y': '10' @@ -1787,8 +1787,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: InnoDB buffer pool' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: InnoDB buffer pool' - type: GRAPH_CLASSIC x: '12' @@ -1804,8 +1804,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Threads' host: 'MySQL by Zabbix agent 2' + name: 'MySQL: Threads' valuemaps: - uuid: f2e8233fcf0a4dd2b53a82ca48436a88 diff --git a/templates/db/mysql_odbc/template_db_mysql_odbc.yaml b/templates/db/mysql_odbc/template_db_mysql_odbc.yaml index 1ca6db31d2f..fa136fb1bb1 100644 --- a/templates/db/mysql_odbc/template_db_mysql_odbc.yaml +++ b/templates/db/mysql_odbc/template_db_mysql_odbc.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:12Z' - groups: + date: '2022-06-07T19:36:30Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1739,8 +1739,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Operations' host: 'MySQL by ODBC' + name: 'MySQL: Operations' - type: GRAPH_CLASSIC x: '12' @@ -1755,8 +1755,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Queries' host: 'MySQL by ODBC' + name: 'MySQL: Queries' - type: GRAPH_CLASSIC 'y': '5' @@ -1771,8 +1771,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Connections' host: 'MySQL by ODBC' + name: 'MySQL: Connections' - type: GRAPH_CLASSIC x: '12' @@ -1788,8 +1788,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Bandwidth' host: 'MySQL by ODBC' + name: 'MySQL: Bandwidth' - type: GRAPH_CLASSIC 'y': '10' @@ -1804,8 +1804,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: InnoDB buffer pool' host: 'MySQL by ODBC' + name: 'MySQL: InnoDB buffer pool' - type: GRAPH_CLASSIC x: '12' @@ -1821,8 +1821,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'MySQL: Threads' host: 'MySQL by ODBC' + name: 'MySQL: Threads' valuemaps: - uuid: 622c38d0af2a4b6ea7a640a5d1a22b93 diff --git a/templates/db/oracle_agent2/README.md b/templates/db/oracle_agent2/README.md index bd5b75e95b3..cb05c13a2cc 100644 --- a/templates/db/oracle_agent2/README.md +++ b/templates/db/oracle_agent2/README.md @@ -177,7 +177,7 @@ There are no template links in this template. |Oracle: Connection to database is unavailable |<p>Connection to Oracle Database is currently unavailable.</p> |`last(/Oracle by Zabbix agent 2/oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"])=0` |DISASTER | | |Oracle: Version has changed |<p>Oracle DB version has changed. Ack to close.</p> |`last(/Oracle by Zabbix agent 2/oracle.version,#1)<>last(/Oracle by Zabbix agent 2/oracle.version,#2) and length(last(/Oracle by Zabbix agent 2/oracle.version))>0` |INFO |<p>Manual close: YES</p> | |Oracle: Failed to fetch info data |<p>Zabbix has not received data for items for the last 5 minutes. The database might be unavailable for connecting.</p> |`nodata(/Oracle by Zabbix agent 2/oracle.uptime,30m)=1` |INFO | | -|Oracle: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/Oracle by Zabbix agent 2/oracle.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|Oracle: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/Oracle by Zabbix agent 2/oracle.uptime)<10m` |INFO |<p>Manual close: YES</p> | |Oracle: Instance name has changed |<p>Oracle DB Instance name has changed. Ack to close.</p> |`last(/Oracle by Zabbix agent 2/oracle.instance_name,#1)<>last(/Oracle by Zabbix agent 2/oracle.instance_name,#2) and length(last(/Oracle by Zabbix agent 2/oracle.instance_name))>0` |INFO |<p>Manual close: YES</p> | |Oracle: Instance hostname has changed |<p>Oracle DB Instance hostname has changed. Ack to close.</p> |`last(/Oracle by Zabbix agent 2/oracle.instance_hostname,#1)<>last(/Oracle by Zabbix agent 2/oracle.instance_hostname,#2) and length(last(/Oracle by Zabbix agent 2/oracle.instance_hostname))>0` |INFO |<p>Manual close: YES</p> | |Oracle: Shared pool free is too low |<p>The shared pool free memory percent has been less than {$ORACLE.SHARED.FREE.MIN.WARN}% in the last 5 minutes.</p> |`max(/Oracle by Zabbix agent 2/oracle.shared_pool_free,5m)<{$ORACLE.SHARED.FREE.MIN.WARN}` |WARNING | | diff --git a/templates/db/oracle_agent2/template_db_oracle_agent2.yaml b/templates/db/oracle_agent2/template_db_oracle_agent2.yaml index 0edfd1019be..22e94534971 100644 --- a/templates/db/oracle_agent2/template_db_oracle_agent2.yaml +++ b/templates/db/oracle_agent2/template_db_oracle_agent2.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:19Z' - groups: + date: '2022-06-07T19:36:34Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1579,7 +1579,7 @@ zabbix_export: name: 'Oracle: has been restarted' event_name: 'Oracle: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/oracle_odbc/README.md b/templates/db/oracle_odbc/README.md index e962b4322af..ef6a53c05a4 100644 --- a/templates/db/oracle_odbc/README.md +++ b/templates/db/oracle_odbc/README.md @@ -222,7 +222,7 @@ There are no template links in this template. |Oracle: Port {$ORACLE.PORT} is unavailable |<p>The TCP port of the Oracle Server service is currently unavailable.</p> |`max(/Oracle by ODBC/net.tcp.service[tcp,{HOST.CONN},{$ORACLE.PORT}],#3)=0 and max(/Oracle by ODBC/proc.num[,,,"tnslsnr LISTENER"],#3)>0` |DISASTER | | |Oracle: LISTENER process is not running |<p>-</p> |`max(/Oracle by ODBC/proc.num[,,,"tnslsnr LISTENER"],#3)=0` |DISASTER | | |Oracle: Version has changed |<p>Oracle DB version has changed. Ack to close.</p> |`last(/Oracle by ODBC/oracle.version,#1)<>last(/Oracle by ODBC/oracle.version,#2) and length(last(/Oracle by ODBC/oracle.version))>0` |INFO |<p>Manual close: YES</p> | -|Oracle: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/Oracle by ODBC/oracle.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|Oracle: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/Oracle by ODBC/oracle.uptime)<10m` |INFO |<p>Manual close: YES</p> | |Oracle: Failed to fetch info data |<p>Zabbix has not received data for items for the last 5 minutes. The database might be unavailable for connecting.</p> |`nodata(/Oracle by ODBC/oracle.uptime,5m)=1` |WARNING |<p>**Depends on**:</p><p>- Oracle: Port {$ORACLE.PORT} is unavailable</p> | |Oracle: Instance name has changed |<p>Oracle DB Instance name has changed. Ack to close.</p> |`last(/Oracle by ODBC/oracle.instance_name,#1)<>last(/Oracle by ODBC/oracle.instance_name,#2) and length(last(/Oracle by ODBC/oracle.instance_name))>0` |INFO |<p>Manual close: YES</p> | |Oracle: Instance hostname has changed |<p>Oracle DB Instance hostname has changed. Ack to close.</p> |`last(/Oracle by ODBC/oracle.instance_hostname,#1)<>last(/Oracle by ODBC/oracle.instance_hostname,#2) and length(last(/Oracle by ODBC/oracle.instance_hostname))>0` |INFO |<p>Manual close: YES</p> | diff --git a/templates/db/oracle_odbc/template_db_oracle_odbc.yaml b/templates/db/oracle_odbc/template_db_oracle_odbc.yaml index 29f8eb71b3d..5e8cbe1d006 100644 --- a/templates/db/oracle_odbc/template_db_oracle_odbc.yaml +++ b/templates/db/oracle_odbc/template_db_oracle_odbc.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:20Z' - groups: + date: '2022-06-07T19:36:35Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1737,7 +1737,7 @@ zabbix_export: name: 'Oracle: has been restarted' event_name: 'Oracle: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/postgresql/template_db_postgresql.yaml b/templates/db/postgresql/template_db_postgresql.yaml index 740a4a8a83b..6967ac859be 100644 --- a/templates/db/postgresql/template_db_postgresql.yaml +++ b/templates/db/postgresql/template_db_postgresql.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:25Z' - groups: + date: '2022-06-07T19:36:38Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -2001,8 +2001,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Tuples' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Tuples' - type: GRAPH_PROTOTYPE x: '12' @@ -2025,8 +2025,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Events' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Events' - type: GRAPH_PROTOTYPE 'y': '5' @@ -2049,8 +2049,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Block hit/read' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Block hit/read' - type: GRAPH_PROTOTYPE x: '12' @@ -2074,8 +2074,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Temp files' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Temp files' - type: GRAPH_PROTOTYPE 'y': '10' @@ -2098,8 +2098,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Locks' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Locks' - type: GRAPH_PROTOTYPE x: '12' @@ -2123,8 +2123,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Database size' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Database size' - type: GRAPH_PROTOTYPE 'y': '15' @@ -2147,8 +2147,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Queries' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Queries' - type: GRAPH_PROTOTYPE x: '12' @@ -2172,8 +2172,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Slow queries' host: 'PostgreSQL by Zabbix agent' + name: 'DB {#DBNAME}: Slow queries' - uuid: f2ceabf59fd64ca9828ea55e9b9668bd name: 'PostgreSQL stat' @@ -2193,8 +2193,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL connections' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL connections' - type: GRAPH_CLASSIC x: '12' @@ -2209,8 +2209,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL transactions' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL transactions' - type: GRAPH_CLASSIC 'y': '5' @@ -2225,8 +2225,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL ping' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL ping' - type: GRAPH_CLASSIC x: '12' @@ -2242,8 +2242,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL uptime' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL uptime' - type: GRAPH_CLASSIC 'y': '10' @@ -2258,8 +2258,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL replication lag' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL replication lag' - type: GRAPH_CLASSIC x: '12' @@ -2275,8 +2275,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL WAL' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL WAL' - type: GRAPH_CLASSIC 'y': '15' @@ -2291,8 +2291,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL bgwriter' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL bgwriter' - type: GRAPH_CLASSIC x: '12' @@ -2308,8 +2308,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'PostgreSQL checkpoints' host: 'PostgreSQL by Zabbix agent' + name: 'PostgreSQL checkpoints' valuemaps: - uuid: 2e376ee568d04e7bbe98cbae4181f313 diff --git a/templates/db/postgresql_agent2/template_db_postgresql_agent2.yaml b/templates/db/postgresql_agent2/template_db_postgresql_agent2.yaml index 0dbe94d0980..4c95722cad9 100644 --- a/templates/db/postgresql_agent2/template_db_postgresql_agent2.yaml +++ b/templates/db/postgresql_agent2/template_db_postgresql_agent2.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:24Z' - groups: + date: '2022-06-07T19:36:37Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -2688,8 +2688,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: pg_stat_database metrics' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: pg_stat_database metrics' - type: GRAPH_PROTOTYPE x: '12' @@ -2712,8 +2712,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Locks' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: Locks' - type: GRAPH_PROTOTYPE 'y': '5' @@ -2736,8 +2736,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Size' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: Size' - type: GRAPH_PROTOTYPE x: '12' @@ -2761,8 +2761,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Number of bloating tables' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: Number of bloating tables' - type: GRAPH_PROTOTYPE 'y': '10' @@ -2785,8 +2785,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Queries' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: Queries' - type: GRAPH_PROTOTYPE x: '12' @@ -2810,8 +2810,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'DB {#DBNAME}: Slow queries' host: 'PostgreSQL by Zabbix agent 2' + name: 'DB {#DBNAME}: Slow queries' valuemaps: - uuid: 9f38c01c325248d4b538c0582432b541 diff --git a/templates/db/redis/README.md b/templates/db/redis/README.md index 3a126ef5770..c0259818890 100644 --- a/templates/db/redis/README.md +++ b/templates/db/redis/README.md @@ -202,7 +202,7 @@ There are no template links in this template. |Redis: Number of slaves has changed |<p>Redis number of slaves has changed. Ack to close.</p> |`last(/Redis by Zabbix agent 2/redis.replication.connected_slaves,#1)<>last(/Redis by Zabbix agent 2/redis.replication.connected_slaves,#2)` |INFO |<p>Manual close: YES</p> | |Redis: Replication role has changed |<p>Redis replication role has changed. Ack to close.</p> |`last(/Redis by Zabbix agent 2/redis.replication.role,#1)<>last(/Redis by Zabbix agent 2/redis.replication.role,#2) and length(last(/Redis by Zabbix agent 2/redis.replication.role))>0` |WARNING |<p>Manual close: YES</p> | |Redis: Version has changed |<p>Redis version has changed. Ack to close.</p> |`last(/Redis by Zabbix agent 2/redis.server.redis_version,#1)<>last(/Redis by Zabbix agent 2/redis.server.redis_version,#2) and length(last(/Redis by Zabbix agent 2/redis.server.redis_version))>0` |INFO |<p>Manual close: YES</p> | -|Redis: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/Redis by Zabbix agent 2/redis.server.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|Redis: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/Redis by Zabbix agent 2/redis.server.uptime)<10m` |INFO |<p>Manual close: YES</p> | |Redis: Connections are rejected |<p>The number of connections has reached the value of "maxclients".</p><p>https://redis.io/topics/clients</p> |`last(/Redis by Zabbix agent 2/redis.stats.rejected_connections)>0` |HIGH | | |Redis: Replication lag with master is too high |<p>-</p> |`min(/Redis by Zabbix agent 2/redis.replication.master_last_io_seconds_ago[{#SINGLETON}],5m)>{$REDIS.REPL.LAG.MAX.WARN}` |WARNING | | |Redis: Process is not running |<p>-</p> |`last(/Redis by Zabbix agent 2/proc.num["{$REDIS.PROCESS_NAME}{#SINGLETON}"])=0` |HIGH | | diff --git a/templates/db/redis/template_db_redis.yaml b/templates/db/redis/template_db_redis.yaml index cb92f827f36..35c12737602 100644 --- a/templates/db/redis/template_db_redis.yaml +++ b/templates/db/redis/template_db_redis.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T19:59:29Z' - groups: + date: '2022-06-07T19:36:40Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -1078,7 +1078,7 @@ zabbix_export: name: 'Redis: has been restarted' event_name: 'Redis: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - @@ -3013,8 +3013,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Clients' host: 'Redis by Zabbix agent 2' + name: 'Redis: Clients' - type: GRAPH_CLASSIC x: '12' @@ -3029,8 +3029,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Keyspace' host: 'Redis by Zabbix agent 2' + name: 'Redis: Keyspace' - type: GRAPH_CLASSIC 'y': '5' @@ -3045,8 +3045,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Commands' host: 'Redis by Zabbix agent 2' + name: 'Redis: Commands' - type: GRAPH_CLASSIC x: '12' @@ -3062,8 +3062,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Expired keys' host: 'Redis by Zabbix agent 2' + name: 'Redis: Expired keys' - type: GRAPH_CLASSIC 'y': '10' @@ -3078,8 +3078,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Persistence' host: 'Redis by Zabbix agent 2' + name: 'Redis: Persistence' - type: GRAPH_CLASSIC x: '12' @@ -3095,8 +3095,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Slaves' host: 'Redis by Zabbix agent 2' + name: 'Redis: Slaves' - type: GRAPH_CLASSIC 'y': '15' @@ -3111,8 +3111,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Slowlog' host: 'Redis by Zabbix agent 2' + name: 'Redis: Slowlog' - type: GRAPH_CLASSIC x: '12' @@ -3128,8 +3128,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Uptime' host: 'Redis by Zabbix agent 2' + name: 'Redis: Uptime' - type: GRAPH_PROTOTYPE 'y': '20' @@ -3152,8 +3152,8 @@ zabbix_export: type: GRAPH_PROTOTYPE name: graphid value: - name: 'Redis: Replication lag time{#SINGLETON}' host: 'Redis by Zabbix agent 2' + name: 'Redis: Replication lag time{#SINGLETON}' - uuid: ee4c29eb7a0f443fafb7e7d3b9df7b24 name: 'Redis performance' @@ -3173,8 +3173,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: CPU' host: 'Redis by Zabbix agent 2' + name: 'Redis: CPU' - type: GRAPH_CLASSIC x: '12' @@ -3189,8 +3189,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Network' host: 'Redis by Zabbix agent 2' + name: 'Redis: Network' - type: GRAPH_CLASSIC 'y': '5' @@ -3205,8 +3205,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Memory' host: 'Redis by Zabbix agent 2' + name: 'Redis: Memory' - type: GRAPH_CLASSIC x: '12' @@ -3222,8 +3222,8 @@ zabbix_export: type: GRAPH name: graphid value: - name: 'Redis: Memory fragmentation' host: 'Redis by Zabbix agent 2' + name: 'Redis: Memory fragmentation' valuemaps: - uuid: 82f4dc4ef0c9471d82dbe3605f4f31d0 diff --git a/templates/db/tidb_http/tidb_pd_http/README.md b/templates/db/tidb_http/tidb_pd_http/README.md index b4df2c8ea01..7e464359d5b 100644 --- a/templates/db/tidb_http/tidb_pd_http/README.md +++ b/templates/db/tidb_http/tidb_pd_http/README.md @@ -90,7 +90,7 @@ There are no template links in this template. |----|-----------|----|----|----| |PD: Instance is not responding |<p>-</p> |`last(/TiDB PD by HTTP/pd.status)=0` |AVERAGE | | |PD: Version has changed |<p>PD version has changed. Ack to close.</p> |`last(/TiDB PD by HTTP/pd.version,#1)<>last(/TiDB PD by HTTP/pd.version,#2) and length(last(/TiDB PD by HTTP/pd.version))>0` |INFO |<p>Manual close: YES</p> | -|PD: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/TiDB PD by HTTP/pd.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|PD: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/TiDB PD by HTTP/pd.uptime)<10m` |INFO |<p>Manual close: YES</p> | |TiDB cluster: There are offline TiKV nodes |<p>PD has not received a TiKV heartbeat for a long time.</p> |`last(/TiDB PD by HTTP/pd.cluster_status.store_down[{#SINGLETON}])>0` |AVERAGE | | |TiDB cluster: There are low space TiKV nodes |<p>Indicates that there is no sufficient space on the TiKV node.</p> |`last(/TiDB PD by HTTP/pd.cluster_status.store_low_space[{#SINGLETON}])>0` |AVERAGE | | |TiDB cluster: There are disconnected TiKV nodes |<p>PD does not receive a TiKV heartbeat within 20 seconds. Normally a TiKV heartbeat comes in every 10 seconds.</p> |`last(/TiDB PD by HTTP/pd.cluster_status.store_disconnected[{#SINGLETON}])>0` |WARNING | | diff --git a/templates/db/tidb_http/tidb_pd_http/template_db_tidb_pd_http.yaml b/templates/db/tidb_http/tidb_pd_http/template_db_tidb_pd_http.yaml index 01512e840da..2a33e730fa8 100644 --- a/templates/db/tidb_http/tidb_pd_http/template_db_tidb_pd_http.yaml +++ b/templates/db/tidb_http/tidb_pd_http/template_db_tidb_pd_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T20:01:17Z' - groups: + date: '2022-06-07T19:37:41Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -169,7 +169,7 @@ zabbix_export: name: 'PD: has been restarted' event_name: 'PD: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/tidb_http/tidb_tidb_http/README.md b/templates/db/tidb_http/tidb_tidb_http/README.md index 4d75e22191a..a050ff588e3 100644 --- a/templates/db/tidb_http/tidb_tidb_http/README.md +++ b/templates/db/tidb_http/tidb_tidb_http/README.md @@ -116,7 +116,7 @@ There are no template links in this template. |TiDB: Too few keep alive operations |<p>Indicates whether the TiDB process still exists. If the number of times for tidb_monitor_keep_alive_total increases less than 10 per minute, the TiDB process might already exit and an alert is triggered.</p> |`max(/TiDB by HTTP/tidb.monitor_keep_alive.rate,5m)<{$TIDB.MONITOR_KEEP_ALIVE.MAX.WARN}` |AVERAGE | | |TiDB: Heap memory usage is too high |<p>-</p> |`min(/TiDB by HTTP/tidb.heap_bytes,5m)>{$TIDB.HEAP.USAGE.MAX.WARN}` |WARNING | | |TiDB: Current number of open files is too high |<p>Heavy file descriptor usage (i.e., near the process's file descriptor limit) indicates a potential file descriptor exhaustion issue.</p> |`min(/TiDB by HTTP/tidb.process_open_fds,5m)/last(/TiDB by HTTP/tidb.process_max_fds)*100>{$TIDB.OPEN.FDS.MAX.WARN}` |WARNING | | -|TiDB: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/TiDB by HTTP/tidb.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|TiDB: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/TiDB by HTTP/tidb.uptime)<10m` |INFO |<p>Manual close: YES</p> | |TiDB: Version has changed |<p>TiDB version has changed. Ack to close.</p> |`last(/TiDB by HTTP/tidb.version,#1)<>last(/TiDB by HTTP/tidb.version,#2) and length(last(/TiDB by HTTP/tidb.version))>0` |INFO |<p>Manual close: YES</p> | |TiDB: Too many time jump backs |<p>-</p> |`min(/TiDB by HTTP/tidb.monitor_time_jump_back.rate,5m)>{$TIDB.TIME_JUMP_BACK.MAX.WARN}` |WARNING | | |TiDB: There are panicked TiDB threads |<p>When a panic occurs, an alert is triggered. The thread is often recovered, otherwise, TiDB will frequently restart.</p> |`last(/TiDB by HTTP/tidb.tidb_server_panic_total.rate)>0` |AVERAGE | | diff --git a/templates/db/tidb_http/tidb_tidb_http/template_db_tidb_tidb_http.yaml b/templates/db/tidb_http/tidb_tidb_http/template_db_tidb_tidb_http.yaml index 6be05500c17..bab39373ebb 100644 --- a/templates/db/tidb_http/tidb_tidb_http/template_db_tidb_tidb_http.yaml +++ b/templates/db/tidb_http/tidb_tidb_http/template_db_tidb_tidb_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T20:01:18Z' - groups: + date: '2022-06-07T19:37:41Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -881,7 +881,7 @@ zabbix_export: name: 'TiDB: has been restarted' event_name: 'TiDB: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - diff --git a/templates/db/tidb_http/tidb_tikv_http/README.md b/templates/db/tidb_http/tidb_tikv_http/README.md index 9aefcbecf6a..df3a2bd16a3 100644 --- a/templates/db/tidb_http/tidb_tikv_http/README.md +++ b/templates/db/tidb_http/tidb_tikv_http/README.md @@ -101,7 +101,7 @@ There are no template links in this template. |TiKV: Too many coprocessor request error |<p>-</p> |`min(/TiDB TiKV by HTTP/tikv.coprocessor_request_error.rate,5m)>{$TIKV.COPOCESSOR.ERRORS.MAX.WARN}` |WARNING | | |TiKV: Too many pending commands |<p>-</p> |`min(/TiDB TiKV by HTTP/tikv.scheduler_contex,5m)>{$TIKV.PENDING_COMMANDS.MAX.WARN}` |AVERAGE | | |TiKV: Too many pending tasks |<p>-</p> |`min(/TiDB TiKV by HTTP/tikv.worker_pending_task,5m)>{$TIKV.PENDING_TASKS.MAX.WARN}` |AVERAGE | | -|TiKV: has been restarted |<p>Uptime is less than 10 minutes</p> |`last(/TiDB TiKV by HTTP/tikv.uptime)<10m` |INFO |<p>Manual close: YES</p> | +|TiKV: has been restarted |<p>Uptime is less than 10 minutes.</p> |`last(/TiDB TiKV by HTTP/tikv.uptime)<10m` |INFO |<p>Manual close: YES</p> | |TiKV: Store_id {#STORE_ID}: Too many failure messages "{#TYPE}" |<p>Indicates that the remote TiKV cannot be connected.</p> |`min(/TiDB TiKV by HTTP/tikv.messages.failure.rate[{#STORE_ID},{#TYPE}],5m)>{$TIKV.STORE.ERRORS.MAX.WARN}` |WARNING | | ## Feedback diff --git a/templates/db/tidb_http/tidb_tikv_http/template_db_tidb_tikv_http.yaml b/templates/db/tidb_http/tidb_tikv_http/template_db_tidb_tikv_http.yaml index 979a644b7b3..06e3777400b 100644 --- a/templates/db/tidb_http/tidb_tikv_http/template_db_tidb_tikv_http.yaml +++ b/templates/db/tidb_http/tidb_tikv_http/template_db_tidb_tikv_http.yaml @@ -1,7 +1,7 @@ zabbix_export: version: '6.2' - date: '2022-04-06T20:01:19Z' - groups: + date: '2022-06-07T19:37:42Z' + template_groups: - uuid: 748ad4d098d447d492bb935c907f652f name: Templates/Databases @@ -721,7 +721,7 @@ zabbix_export: name: 'TiKV: has been restarted' event_name: 'TiKV: has been restarted (uptime < 10m)' priority: INFO - description: 'Uptime is less than 10 minutes' + description: 'Uptime is less than 10 minutes.' manual_close: 'YES' tags: - |