SHOW DIAGNOSTICS 语句

诊断信息主要包括关于您的 InfluxDB 服务器的信息，这些信息不一定是数字格式。此诊断信息未存储在 _internal 数据库中。

要查看 InfluxDB 服务器或节点诊断信息，您可以使用 SHOW DIAGNOSTICS 语句。此语句返回 InfluxDB 实例信息，包括构建详细信息、正常运行时间、主机名、服务器配置、内存使用情况和 Go 运行时诊断。此信息对于 InfluxData 支持尤其有用，因此请务必在提交支持工单或 GitHub 问题时包含此查询的输出。

SHOW DIAGNOSTICS 测量详情

SHOW DIAGNOSTICS 语句返回以下信息。

build

• Branch
• Build Time
• Commit

config

• bind-address
• reporting-disabled

config-coordinator

• log-queries-after
• max-concurrent-queries
• max-select-buckets
• max-select-point
• max-select-series
• query-timeout
• write-timeout

config-cqs

• enabled
• query-stats-enabled
• run-interval

config-data

• cache-max-memory-size
• cache-snapshot-memory-size
• cache-snapshot-write-cold-duration
• compact-full-write-cold-duration
• dir
• max-concurrent-compactions
• max-series-per-database
• max-values-per-tag
• wal-dir
• wal-fsync-delay

config-httpd

• access-log-path
• bind-address
• enabled
• https-enabled
• max-connection-limit
• max-row-limit

config-meta

• dir

config-monitor

• store-database
• store-enabled
• store-interval

config-precreator

• advance-period
• check-interval
• enabled

config-retention

• check-interval
• enabled

config-subscriber

• enabled
• http-timeout
• write-buffer-size
• write-concurrency

network

• hostname

runtime

• GOARCH
• GOMAXPROCS
• GOOS
• version

system

• PID currentTime
• started
• uptime

SHOW DIAGNOSTICS 输出示例

以下是在 InfluxDB OSS 服务器上运行 SHOW DIAGNOSTICS 语句时返回的输出示例。

> show diagnostics
name: build
Branch Build Time Commit                                   Version
------ ---------- ------                                   -------
master            389de31c961831de0a9f4172173337d4a6193909 v1.6.3

name: config
bind-address   reporting-disabled
------------   ------------------
127.0.0.1:8088 false

name: config-coordinator
log-queries-after max-concurrent-queries max-select-buckets max-select-point max-select-series query-timeout write-timeout
----------------- ---------------------- ------------------ ---------------- ----------------- ------------- -------------
0s                0                      0                  0                0                 0s            10s

name: config-cqs
enabled query-stats-enabled run-interval
------- ------------------- ------------
true    false               1s

name: config-data
cache-max-memory-size cache-snapshot-memory-size cache-snapshot-write-cold-duration compact-full-write-cold-duration dir                          max-concurrent-compactions max-series-per-database max-values-per-tag wal-dir                     wal-fsync-delay
--------------------- -------------------------- ---------------------------------- -------------------------------- ---                          -------------------------- ----------------------- ------------------ -------                     ---------------
1073741824            26214400                   10m0s                              4h0m0s                           /usr/local/var/influxdb/data 0                          1000000                 100000             /usr/local/var/influxdb/wal 0s

name: config-httpd
access-log-path bind-address enabled https-enabled max-connection-limit max-row-limit
--------------- ------------ ------- ------------- -------------------- -------------
                :8086        true    false         0                    0

name: config-meta
dir
---
/usr/local/var/influxdb/meta

name: config-monitor
store-database store-enabled store-interval
-------------- ------------- --------------
_internal      true          10s

name: config-precreator
advance-period check-interval enabled
-------------- -------------- -------
30m0s          10m0s          true

name: config-retention
check-interval enabled
-------------- -------
30m0s          true

name: config-subscriber
enabled http-timeout write-buffer-size write-concurrency
------- ------------ ----------------- -----------------
true    30s          1000              40

name: network
hostname
--------
influxdb-1.local

name: runtime
GOARCH GOMAXPROCS GOOS   version
------ ---------- ----   -------
amd64  8          darwin go1.11

name: system
PID currentTime                 started                     uptime
--- -----------                 -------                     ------
940 2018-10-15T15:07:47.435739Z 2018-10-15T06:03:34.002126Z 9h4m13.433613s