From 29d9b5e51603792ee27ef5a21f1de0ba8e130158 Mon Sep 17 00:00:00 2001 From: Ilya Mashchenko Date: Fri, 31 Jan 2020 10:38:44 +0300 Subject: installer: include go.d.plugin version v0.15.0 (#7882) * /web/giu/dashboard_info.js: add cockroachdb info * /web/giu/dashboard_info.js: lgtm fix * /health/health.d/: add cockroachdb.conf --- health/Makefile.am | 1 + health/health.d/cockroachdb.conf | 91 +++++++++++++++++++ packaging/go.d.checksums | 32 +++---- packaging/go.d.version | 2 +- web/gui/dashboard_info.js | 184 ++++++++++++++++++++++++++++++++++++++- 5 files changed, 292 insertions(+), 18 deletions(-) create mode 100644 health/health.d/cockroachdb.conf diff --git a/health/Makefile.am b/health/Makefile.am index ccd36bf1b7..853ed0d708 100644 --- a/health/Makefile.am +++ b/health/Makefile.am @@ -37,6 +37,7 @@ dist_healthconfig_DATA = \ health.d/ceph.conf \ health.d/cgroups.conf \ health.d/cpu.conf \ + health.d/cockroachdb.conf \ health.d/couchdb.conf \ health.d/disks.conf \ health.d/dnsmasq_dhcp.conf \ diff --git a/health/health.d/cockroachdb.conf b/health/health.d/cockroachdb.conf new file mode 100644 index 0000000000..8ab2c9d0f7 --- /dev/null +++ b/health/health.d/cockroachdb.conf @@ -0,0 +1,91 @@ + +# Availability + +template: cockroachdb_last_collected_secs + on: cockroachdb.live_nodes + calc: $now - $last_collected_t + units: seconds ago + every: 10s + warn: $this > (($status >= $WARNING) ? ($update_every) : ( 5 * $update_every)) + crit: $this > (($status == $CRITICAL) ? ($update_every) : (60 * $update_every)) + delay: down 5m multiplier 1.5 max 1h + info: number of seconds since the last successful data collection + to: dba + +# Capacity + +template: cockroachdb_used_storage_capacity + on: cockroachdb.storage_used_capacity_percentage + calc: $capacity_used_percent + units: % + every: 10s + warn: $this > (($status >= $WARNING) ? (80) : (85)) + crit: $this > (($status == $CRITICAL) ? (85) : (95)) + delay: down 15m multiplier 1.5 max 1h + info: entire disk usage percentage + to: dba + +template: cockroachdb_used_usable_storage_capacity + on: cockroachdb.storage_used_capacity_percentage + calc: $capacity_usable_used_percent + units: % + every: 10s + warn: $this > (($status >= $WARNING) ? (80) : (85)) + crit: $this > (($status == $CRITICAL) ? (85) : (95)) + delay: down 15m multiplier 1.5 max 1h + info: usable space usage percentage + to: dba + +# Replication + +template: cockroachdb_unavailable_ranges + on: cockroachdb.ranges_replication_problem + calc: $ranges_unavailable + units: num + every: 10s + warn: $this > 0 + delay: down 15m multiplier 1.5 max 1h + info: number of ranges with fewer live replicas than the replication target + to: dba + +template: cockroachdb_replicas_leaders_not_leaseholders + on: cockroachdb.replicas_leaders + calc: $replicas_leaders_not_leaseholders + units: num + every: 10s + warn: $this > 0 + delay: down 15m multiplier 1.5 max 1h + info: number of replicas that are Raft leaders whose range lease is held by another store + to: dba + +# FD + +template: cockroachdb_open_file_descriptors_limit + on: cockroachdb.process_file_descriptors + calc: $sys_fd_open/$sys_fd_softlimit * 100 + units: % + every: 10s + warn: $this > 80 + delay: down 15m multiplier 1.5 max 1h + info: open file descriptors usage percentage + to: dba + +# SQL + +template: cockroachdb_sql_active_connections + on: cockroachdb.sql_connections + calc: $sql_conns + units: active connections + every: 10s + info: number of active SQL connections + to: dba + +template: cockroachdb_sql_executed_statements_total_last_5m + on: cockroachdb.sql_statements_total + lookup: sum -5m absolute of sql_query_count + units: statements + every: 10s + warn: $this == 0 AND $cockroachdb_sql_active_connections != 0 + delay: down 15m up 30s multiplier 1.5 max 1h + info: number of executed SQL statements in the last 5 minutes + to: dba diff --git a/packaging/go.d.checksums b/packaging/go.d.checksums index c0e85c460e..798558abbf 100644 --- a/packaging/go.d.checksums +++ b/packaging/go.d.checksums @@ -1,16 +1,16 @@ -f038852ab4c6fb1623384685a8d2b2d0ab85474d91303d8e6b3a670d0625f104 *config.tar.gz -2087d74c4f18cd1d5f49f5e000e0cf2f63464930e9e1164e0b903268e7e85a9f *go.d.plugin-v0.14.1.darwin-386.tar.gz -acd275d58c8ba448572b50b04b3faeefcd35be985a1155192ac77d0e383c5854 *go.d.plugin-v0.14.1.darwin-amd64.tar.gz -b8da98b28dc5a048e9bb7d187c07df69bf631738ec540847b2c194e422f21ecc *go.d.plugin-v0.14.1.freebsd-386.tar.gz -021ae15d077f3688704db91650542dfab284b5d7d3f21ff83d3ba398c7cc77af *go.d.plugin-v0.14.1.freebsd-amd64.tar.gz -ea69f36e745d92b98e8a1bea118433954e1d6aea5af8923413857ca61da02b8a *go.d.plugin-v0.14.1.freebsd-arm.tar.gz -6173c2c632ee01b911d8436c64e88df0dfff6360ff9f9662c560615557c78101 *go.d.plugin-v0.14.1.linux-386.tar.gz -641d943355b31677c4cb6d445817a17317c4cb89cb173e5ecfa8567ebcef96ef *go.d.plugin-v0.14.1.linux-amd64.tar.gz -2ec678203c5728444a8550ac5e378c74c434e5e0db6ae71dd5acc28b8ab45018 *go.d.plugin-v0.14.1.linux-arm.tar.gz -b1070000c9b853d50cce0e644b8e4602ed0c6bcdf203a25678a6f9f6554dd4e1 *go.d.plugin-v0.14.1.linux-arm64.tar.gz -c6e7574680a2281fdce764861197bb61dde5e0e6c0d24ab57bab5deb321e218d *go.d.plugin-v0.14.1.linux-mips.tar.gz -b7bdd268e485d67a60670f432fd7dca9122abbbf25d4be4706406f4e9c0efaab *go.d.plugin-v0.14.1.linux-mips64.tar.gz -dc865ffeb2cf07d89a38927bbce812b2407b0c2a84299c207c497dd77c3f9be9 *go.d.plugin-v0.14.1.linux-mips64le.tar.gz -6b8d55742dfe9f4116edd2cbca670245a3e81344ffa50fb75885b841f85b7699 *go.d.plugin-v0.14.1.linux-mipsle.tar.gz -830a6bb2028476568870d4a01725586c1799862a4eb0eb7a3bce9e2e617fb688 *go.d.plugin-v0.14.1.linux-ppc64.tar.gz -985ee3f5e24cc6cba71723e7b6acd06e49f48280007f33174b557fa8dda6daef *go.d.plugin-v0.14.1.linux-ppc64le.tar.gz +eac6cdc2f38986ba8605030b6ac41304b5f03e880fc9fea943ed034fc8f7490a *config.tar.gz +7021f071689e4efa879d557f4a76c369e3a7b95c093913ba3c5429087e093258 *go.d.plugin-v0.15.0.darwin-386.tar.gz +ac16155b37fd51c5d333e490b4e5b85e3388b3b42ae9bb5bc828f78aa1cbd58a *go.d.plugin-v0.15.0.darwin-amd64.tar.gz +5d34e399ee75db0fce858a34038b3d645c8b5c80b26c346f6908117a738899ff *go.d.plugin-v0.15.0.freebsd-386.tar.gz +d2ff775c11dcf8c90ab92e8d229a74980bb498513cc7411962cdc8056cb22eef *go.d.plugin-v0.15.0.freebsd-amd64.tar.gz +3563424c41ca047786a9ef80ac25704d27d53e7b64b8252ce30d3b54b3d1638f *go.d.plugin-v0.15.0.freebsd-arm.tar.gz +8e8e52bde2da6ce98fa902bad164152c53632fc7b1e1c9f689a89c0e5a87548f *go.d.plugin-v0.15.0.linux-386.tar.gz +292546c3338b372441816be12e13f7fe6951281c2f03cff947d9bfb0cb39aeb2 *go.d.plugin-v0.15.0.linux-amd64.tar.gz +ab5fb4d2f277255de31ca9330aacb67ebab2f10c398dc96f207eefefae1960ce *go.d.plugin-v0.15.0.linux-arm.tar.gz +93ebd48c2b781fb42a26e21759885772d08e3ee2eea46b12e10681ff6c914de6 *go.d.plugin-v0.15.0.linux-arm64.tar.gz +c83e8c758b116c13184314158ed5e7516fa4467a50e43b7d30bd466938e1a0c7 *go.d.plugin-v0.15.0.linux-mips.tar.gz +7a036e6e74ac13b82a6baedf61208a6eae6dc1b57da50ad47b2fc5a376ef680a *go.d.plugin-v0.15.0.linux-mips64.tar.gz +8f5a92bc4feac4ae44c0881e0de4490643fccc2d7e0867de437e0d08fc858256 *go.d.plugin-v0.15.0.linux-mips64le.tar.gz +5a87a29f6a723d7bdc063e767c20c377cb8383edca96f36a3ed45d3434b7b157 *go.d.plugin-v0.15.0.linux-mipsle.tar.gz +b67f5ed415c8f2109c916f655c60d2d61cb520623065bee770941bf8f40af1cc *go.d.plugin-v0.15.0.linux-ppc64.tar.gz +69ab1728f6017e3e83db5971a6e57dabdb5b9190ae1d817ee9b010bc0a2995a0 *go.d.plugin-v0.15.0.linux-ppc64le.tar.gz diff --git a/packaging/go.d.version b/packaging/go.d.version index 64a3b7907b..86dd09abce 100644 --- a/packaging/go.d.version +++ b/packaging/go.d.version @@ -1 +1 @@ -v0.14.1 +v0.15.0 diff --git a/web/gui/dashboard_info.js b/web/gui/dashboard_info.js index 7032074b7e..b86841653c 100644 --- a/web/gui/dashboard_info.js +++ b/web/gui/dashboard_info.js @@ -534,6 +534,12 @@ netdataDashboard.menu = { title: 'Squid log', icon: '', info: undefined + }, + + 'cockroachdb': { + title: 'CockroachDB', + icon: '', + info: 'Performance and health statistics for various CockroachDB components.' } }; @@ -2828,6 +2834,182 @@ netdataDashboard.context = { 'squidlog.mime_type_requests': { info: 'The content type of the object as seen in the HTTP reply header. Please note that ICP exchanges usually don\'t have any content type.' - } + }, + + // ------------------------------------------------------------------------ + // CockroachDB + + 'cockroachdb.process_cpu_time_combined_percentage': { + info: 'Current combined cpu utilization, calculated as (user+system)/num of logical cpus.' + }, + + 'cockroachdb.host_disk_bandwidth': { + info: 'Summary disk bandwidth statistics across all system host disks.' + }, + + 'cockroachdb.host_disk_operations': { + info: 'Summary disk operations statistics across all system host disks.' + }, + + 'cockroachdb.host_disk_iops_in_progress': { + info: 'Summary disk iops in progress statistics across all system host disks.' + }, + + 'cockroachdb.host_network_bandwidth': { + info: 'Summary network bandwidth statistics across all system host network interfaces.' + }, + + 'cockroachdb.host_network_packets': { + info: 'Summary network packets statistics across all system host network interfaces.' + }, + + 'cockroachdb.live_nodes': { + info: 'Will be 0 if this node is not itself live.' + }, + + 'cockroachdb.total_storage_capacity': { + info: 'Entire disk capacity. It includes non-CR data, CR data, and empty space.' + }, + + 'cockroachdb.storage_capacity_usability': { + info: 'usable is sum of empty space and CR data, unusable is space used by non-CR data.' + }, + + 'cockroachdb.storage_usable_capacity': { + info: 'Breakdown of usable space.' + }, + + 'cockroachdb.storage_used_capacity_percentage': { + info: 'total is % of total space used, usable is % of usable space used.' + }, + + 'cockroachdb.sql_bandwidth': { + info: 'The total amount of SQL client network traffic.' + }, + + 'cockroachdb.sql_errors': { + info: 'statement is statements resulting in a planning or runtime error, ' + + 'transaction is SQL transactions abort errors.' + }, + + 'cockroachdb.sql_started_ddl_statements': { + info: 'The amount of started DDL (Data Definition Language) statements. ' + + 'This type means database schema changes. ' + + 'It includes CREATE, ALTER, DROP, RENAME, TRUNCATE and COMMENT statements.' + }, + + 'cockroachdb.sql_executed_ddl_statements': { + info: 'The amount of executed DDL (Data Definition Language) statements. ' + + 'This type means database schema changes. ' + + 'It includes CREATE, ALTER, DROP, RENAME, TRUNCATE and COMMENT statements.' + }, + + 'cockroachdb.sql_started_dml_statements': { + info: 'The amount of started DML (Data Manipulation Language) statements.' + }, + + 'cockroachdb.sql_executed_dml_statements': { + info: 'The amount of executed DML (Data Manipulation Language) statements.' + }, + + 'cockroachdb.sql_started_tcl_statements': { + info: 'The amount of started TCL (Transaction Control Language) statements.' + }, + + 'cockroachdb.sql_executed_tcl_statements': { + info: 'The amount of executed TCL (Transaction Control Language) statements.' + }, + + 'cockroachdb.live_bytes': { + info: 'The amount of live data used by both applications and the CockroachDB system.' + }, + + 'cockroachdb.kv_transactions': { + info: 'KV transactions breakdown:
' + + '' + }, + + 'cockroachdb.kv_transaction_restarts': { + info: 'KV transactions restarts breakdown:
' + + '' + }, + + 'cockroachdb.ranges': { + info: 'CockroachDB stores all user data (tables, indexes, etc.) and almost all system data in a giant sorted map of key-value pairs. ' + + 'This keyspace is divided into "ranges", contiguous chunks of the keyspace, so that every key can always be found in a single range.' + }, + + 'cockroachdb.ranges_replication_problem': { + info: 'Ranges with not optimal number of replicas:
' + + '' + }, + + 'cockroachdb.replicas': { + info: 'CockroachDB replicates each range (3 times by default) and stores each replica on a different node.' + }, + + 'cockroachdb.replicas_leaders': { + info: 'For each range, one of the replicas is the leader for write requests, not leaseholders is the number of Raft leaders whose range lease is held by another store.' + }, + + 'cockroachdb.replicas_leaseholders': { + info: 'For each range, one of the replicas holds the "range lease". This replica, referred to as the leaseholder, is the one that receives and coordinates all read and write requests for the range.' + }, + + 'cockroachdb.queue_processing_failures': { + info: 'Failed replicas breakdown by queue:
' + + '' + }, + + 'cockroachdb.rebalancing_queries': { + info: 'Number of kv-level requests received per second by the store, averaged over a large time period as used in rebalancing decisions.' + }, + + 'cockroachdb.rebalancing_writes': { + info: 'Number of keys written (i.e. applied by raft) per second to the store, averaged over a large time period as used in rebalancing decisions.' + }, + + 'cockroachdb.slow_requests': { + info: 'Requests that have been stuck for a long time.' + }, + + 'cockroachdb.timeseries_samples': { + info: 'The amount of metric samples written to disk.' + }, + + 'cockroachdb.timeseries_write_errors': { + info: 'The amount of errors encountered while attempting to write metrics to disk.' + }, + + 'cockroachdb.timeseries_write_bytes': { + info: 'Size of metric samples written to disk.' + }, }; -- cgit v1.2.3