콘텐츠로 이동

금산운 KCH ClickHouse

금산운 KCH ClickHouse 모니터링 데이터를 수집합니다.

설정

사전 조건

요구 사항을 충족하는 금산운 AK ID, AK Secret을 미리 준비하고, 수집에 필요한 서비스에 대한 읽기 전용 권한을 부여해 주세요.

Func 설치

Guance 통합 - 확장 - 호스팅 버전 Func를 여는 것을 권장합니다: 모든 사전 조건이 자동으로 설치되니, 스크립트 설치를 계속 진행해 주세요.

직접 배포한 Func는 직접 배포한 Func를 참고하세요.

설치 스크립트

  1. Func 콘솔에 로그인한 뒤【스크립트 마켓】을 클릭하고, Guance 스크립트 마켓에 들어가 integration_kingsoftcloud_clickhouse를 검색합니다
  2. 【설치】를 클릭한 뒤, 해당 파라미터인 금산운 AK ID, AK Secret 및 계정명을 입력합니다
  3. 【배포 시작 스크립트】를 클릭하면 시스템이 자동으로 Startup 스크립트 세트를 생성하고, 해당 시작 스크립트를 자동으로 구성합니다
  4. 활성화한 뒤에는 「관리 / 자동 트리거 설정」에서 해당 자동 트리거 설정을 볼 수 있습니다. 【실행】을 클릭하면 예약 시간을 기다릴 필요 없이 즉시 한 번 실행할 수 있습니다. 잠시 후 실행 작업 기록과 해당 로그를 확인할 수 있습니다

검증

  1. 「관리 / 자동 트리거 설정」에서 해당 작업의 자동 트리거 설정이 존재하는지 확인하고, 동시에 해당 작업 기록과 로그를 확인해 이상이 있는지 점검합니다
  2. Guance의 「기반 시설 - 리소스 디렉터리」에서 자산 정보가 있는지 확인합니다
  3. Guance의 「지표」에서 해당 모니터링 데이터가 있는지 확인합니다

지표

금산운-클라우드 모니터링을 설정한 뒤 기본 지표 집합은 다음과 같으며, 설정을 통해 더 많은 지표를 수집할 수 있습니다. 금산운 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의 필드는 후속 업데이트에 따라 변경될 수 있습니다.

문서 평가

이 페이지가 도움이 되었나요?