| Server IP : www.new.bangkokfinder.com / Your IP : 162.158.189.185 Web Server : nginx/1.20.1 System : Linux new 4.15.0-159-generic #167-Ubuntu SMP Tue Sep 21 08:55:05 UTC 2021 x86_64 User : bangkokfinder ( 1000) PHP Version : 7.4.33 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /etc/datadog-agent/conf.d/clickhouse.d/ |
Upload File : |
## All options defined here are available to all instances.
#
init_config:
## @param global_custom_queries - list of mappings - optional
## See `custom_queries` defined below.
##
## Global custom queries can be applied to all instances using the
## `use_global_custom_queries` setting at the instance level.
#
# global_custom_queries:
# - metric_prefix: clickhouse
# query: <QUERY>
# columns: <COLUMNS>
# tags: <TAGS>
## @param service - string - optional
## Attach the tag `service:<SERVICE>` to every metric, event, and service check emitted by this integration.
##
## Additionally, this sets the default `service` for every log source.
#
# service: <SERVICE>
## Every instance is scheduled independent of the others.
#
instances:
## @param server - string - required
## The hostname used to connect to the system.
#
- server: <SERVER>
## @param port - integer - optional - default: 9000
## The port used to connect to the system.
#
# port: 9000
## @param username - string - optional - default: default
## The database user to authenticate as.
#
# username: default
## @param password - string - optional
## The password of `username`.
#
# password: <PASSWORD>
## @param db - string - optional - default: default
## The database to connect to.
#
# db: <DB>
## @param connect_timeout - integer - optional - default: 10
## The timeout for connecting to the `server`.
#
# connect_timeout: 10
## @param read_timeout - integer - optional - default: 10
## The timeout for reading from the `server`.
#
# read_timeout: 10
## @param compression - string - optional
## The compression algorithm to use. The default is no compression.
##
## Valid values are:
##
## - lz4
## - lz4hc
#
# compression: <COMPRESSION>
## @param tls_verify - boolean - optional - default: false
## Whether or not to connect securely using TLS. The server must also support this.
#
# tls_verify: false
## @param use_global_custom_queries - string - optional - default: true
## How `global_custom_queries` should be used for this instance. There are 3 options:
##
## 1. true - `global_custom_queries` override `custom_queries`.
## 2. false - `custom_queries` override `global_custom_queries`.
## 3. extend - `global_custom_queries` are used in addition to any `custom_queries`.
#
# use_global_custom_queries: 'true'
## @param custom_queries - list of mappings - optional
## Each query must have 2 fields, and can have a third optional field:
##
## 1. query - The SQL to execute. It can be a simple statement or a multi-line script.
## Use the pipe `|` if you require a multi-line script.
## 2. columns - The list representing each column, ordered sequentially from left to right.
## The number of columns must equal the number of columns returned in the query.
## There are 2 required pieces of data:
## a. name - The suffix to append to `<INTEGRATION>.` to form
## the full metric name. If `type` is `tag`, this column is
## considered a tag and applied to every
## metric collected by this particular query.
## b. type - The submission method (gauge, monotonic_count, etc.).
## This can also be set to `tag` to tag each metric in the row
## with the name and value of the item in this column. You can
## use the `count` type to perform aggregation for queries that
## return multiple rows with the same or no tags.
## Columns without a name are ignored. To skip a column, enter:
## - {}
## 3. tags (optional) - A list of tags to apply to each metric.
#
# custom_queries:
# - query: SELECT foo, COUNT(*) FROM table.events GROUP BY foo
# columns:
# - name: foo
# type: tag
# - name: event.total
# type: gauge
# tags:
# - test:clickhouse
## @param tags - list of strings - optional
## A list of tags to attach to every metric and service check emitted by this instance.
##
## Learn more about tagging at https://docs.datadoghq.com/tagging
#
# tags:
# - <KEY_1>:<VALUE_1>
# - <KEY_2>:<VALUE_2>
## @param service - string - optional
## Attach the tag `service:<SERVICE>` to every metric, event, and service check emitted by this integration.
##
## Overrides any `service` defined in the `init_config` section.
#
# service: <SERVICE>
## @param min_collection_interval - number - optional - default: 15
## This changes the collection interval of the check. For more information, see:
## https://docs.datadoghq.com/developers/write_agent_check/#collection-interval
#
# min_collection_interval: 15
## @param empty_default_hostname - boolean - optional - default: false
## This forces the check to send metrics with no hostname.
##
## This is useful for cluster-level checks.
#
# empty_default_hostname: false
## Log Section
##
## type - required - Type of log input source (tcp / udp / file / windows_event)
## port / path / channel_path - required - Set port if type is tcp or udp.
## Set path if type is file.
## Set channel_path if type is windows_event.
## source - required - Attribute that defines which integration sent the logs.
## encoding - optional - For file specifies the file encoding, default is utf-8, other
## possible values are utf-16-le and utf-16-be.
## service - optional - The name of the service that generates the log.
## Overrides any `service` defined in the `init_config` section.
## tags - optional - Add tags to the collected logs.
##
## Discover Datadog log collection: https://docs.datadoghq.com/logs/log_collection/
#
# logs:
# - source: clickhouse
# type: file
# path: /var/log/clickhouse-server/clickhouse-server.log
# log_processing_rules:
# - type: multi_line
# name: log_start_with_date
# pattern: \d{4}\.\d{2}\.\d{2}
# - source: clickhouse
# type: file
# path: /var/log/clickhouse-server/clickhouse-server.err.log
# log_processing_rules:
# - type: multi_line
# name: log_start_with_date
# pattern: \d{4}\.\d{2}\.\d{2}