跳转至

金山云 KCH ClickHouse

采集金山云 KCH ClickHouse 监控数据。

配置

前置条件

请提前准备好符合要求的金山云 AK ID、AK Secret，并授予采集所需服务的只读权限。

安装 Func

推荐开通 观测云集成 - 扩展 - 托管版 Func: 一切前置条件都自动安装好, 请继续脚本安装

如果自行部署 Func 参考自行部署 Func

安装脚本

  1. 登陆 Func 控制台，点击【脚本市场】，进入观测云脚本市场，搜索 integration_kingsoftcloud_clickhouse
  2. 点击【安装】后，输入相应的参数：金山云 AK ID、AK Secret 及账户名
  3. 点击【部署启动脚本】，系统会自动创建 Startup 脚本集，并自动配置相应的启动脚本
  4. 开启后可以在「管理 / 自动触发配置」里看到对应的自动触发配置。点击【执行】，即可立即执行一次，无需等待定期时间。稍等片刻，可以查看执行任务记录以及对应日志

验证

  1. 在「管理 / 自动触发配置」确认对应的任务是否已存在对应的自动触发配置，同时可以查看对应任务记录及日志检查是否有异常
  2. 在观测云，「基础设施 - 资源目录」中查看是否存在资产信息
  3. 在观测云，「指标」查看是否有对应监控数据

指标

配置好金山云-云监控后，默认的指标集如下，可以通过配置的方式采集更多指标。金山云 KCH ClickHouse 监控指标位于 kingsoftcloud_kck 指标集。

MetricName MetricDescribe Dimensions Unit
ch_bytes_average 平均每秒写入量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_bytes_max 最大每秒写入量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_bytes_min 最小每秒写入量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_bytes_received_average 平均实例每秒入流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_bytes_received_max 最大实例每秒入流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_bytes_received_min 最小实例每秒入流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_bytes_sent_average 平均实例每秒出流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_bytes_sent_max 最大实例每秒出流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_bytes_sent_min 最小实例每秒出流量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id Kbps
ch_connections_average 平均当前连接数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_connections_max 最大当前连接数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_connections_min 最小当前连接数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_cpu_used_percent_average 平均 CPU 使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_cpu_used_percent_max 最大 CPU 使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_cpu_used_percent_min 最小 CPU 使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_cpu_wait_average 平均 CPU 等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms
ch_cpu_wait_max 最大 CPU 平均等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms
ch_cpu_wait_min 最小 CPU 平均等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms
ch_insert_delay_count_average 平均延迟 Insert 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_insert_delay_count_max 最大延迟 Insert 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_insert_delay_count_min 最小延迟 Insert 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_max_delay_average ch_max_delay_average node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_max_delay_max ch_max_delay_max node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_max_delay_min ch_max_delay_min node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_memory_used_percent_average 平均内存使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_memory_used_percent_max 最大内存使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_memory_used_percent_min 最小内存使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_merge_running_average 平均运行 Merge 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_merge_running_max 最大运行 Merge 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_merge_running_min 最小运行 Merge 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_mutation_running_average 平均运行 Mutation 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_mutation_running_max 最大运行 Mutation 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_mutation_running_min 最小运行 Mutation 任务数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_qps_average 平均每秒查询数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_qps_max 最大每秒查询数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_qps_min 最小每秒查询数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_query_failed_average 平均失败 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_query_failed_max 最大失败 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_query_failed_min 最小失败 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_query_running_average 平均运行 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_query_running_max 最大运行 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_query_running_min 最小运行 Query 数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id count
ch_rbps_average 平均读吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_rbps_max 最大读吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_rbps_min 最小读吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_resident_memory_size_average 平均内存使用量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_resident_memory_size_max 最大内存使用量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_resident_memory_size_min 最小内存使用量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_riops_average 平均磁盘读 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_riops_max 最大磁盘读 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_riops_min 最小磁盘读 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_rows_average 平均每秒写入行数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id rows（自定义）
ch_rows_max 最大每秒写入行数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id rows（自定义）
ch_rows_min 最小每秒写入行数 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id rows（自定义）
ch_space_used_percent_average 平均磁盘使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_space_used_percent_max 最大磁盘使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_space_used_percent_min 最小磁盘使用率 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id percent
ch_spaced_used_average 平均已用磁盘空间 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_spaced_used_max 最大已用磁盘空间 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_spaced_used_min 最小已用磁盘空间 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id MB
ch_unexecuted_logs_average ch_unexecuted_logs_average node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_unexecuted_logs_max ch_unexecuted_logs_max node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_unexecuted_logs_min ch_unexecuted_logs_min node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id -
ch_wbps_average 平均写吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_wbps_max 最大写吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_wbps_min 最小写吞吐量 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id B/S
ch_wiops_average 平均磁盘写 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_wiops_max 最大磁盘写 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_wiops_min 最小磁盘写 IOPS node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ops
ch_zk_wait_average 平均 ZooKeeper 等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms
ch_zk_wait_max 最大 ZooKeeper 平均等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms
ch_zk_wait_min 最小 ZooKeeper 平均等待时长 node_monitor_id, shard_name, instance_id, account_name, region_id, node_vip, cloud_provider, instance_name, shard_id, node_id, instance_vip, project_name, project_id ms

对象

采集到的金山云 KCH ClickHouse 对象数据结构，可以从「基础设施 - 资源目录」里看到对象数据。

{
  "measurement": "kingsoftcloud_clickhouse",
  "tags": {
    "account_name": "account_xxx",
    "cloud_provider": "kingsoftcloud",
    "region_id": "cn-beijing-6",
    "project_id": "xxxxxxxx",
    "project_name": "示例项目",
    "instance_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
    "instance_name": "example-clickhouse",
    "status": "2",
    "status_name": "运行中",
    "vpc_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
    "subnet_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
    "security_group_id": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
  },
  "fields": {
    "cpu": 8,
    "mem": 32,
    "instacne_config": "8C32G",
    "engine": "ClickHouse",
    "network_type": "VPC",
    "instance_vip": "192.0.2.10",
    "tcp_port": 9000,
    "http_port": 8123,
    "mysql_port": 9004,
    "node_num": 3,
    "replicas": 2,
    "instance_create_date": "2026-01-01T00:00:00Z"
  }
}

注意：tags、fields 中的字段可能会随后续更新有所变动。

文档评价

文档内容是否对您有帮助？