Kingsoft Cloud KCH ClickHouse
Kingsoft Cloud KCH ClickHouse の監視データを収集します。
設定¶
前提条件¶
事前に要件を満たす Kingsoft Cloud の AK ID と AK Secret を用意し、収集対象サービスの読み取り専用権限を付与してください。
Func のインストール¶
Guance の統合 - 拡張 - マネージド版 Func を有効にすることを推奨します。前提条件はすべて自動でインストールされるため、このままスクリプトのインストールを進めてください
Func を自己デプロイする場合はFunc を自己デプロイするを参照してください
スクリプトのインストール¶
- Func コンソールにログインし、[スクリプトマーケット] をクリックして Guance スクリプトマーケットに入り、
integration_kingsoftcloud_clickhouseを検索します - [インストール] をクリックし、Kingsoft Cloud の AK ID、AK Secret、アカウント名を入力します
- [起動スクリプトをデプロイ] をクリックすると、システムが自動的に
Startupスクリプトセットを作成し、対応する起動スクリプトを自動設定します - 有効化後、「管理 / 自動トリガー設定」で対応する自動トリガー設定を確認できます。[実行] をクリックすると、定期実行を待たずにすぐ 1 回実行できます。しばらくすると、実行タスクの記録と対応するログを確認できます
確認¶
- 「管理 / 自動トリガー設定」で対応するタスクに自動トリガー設定が存在するか確認し、必要に応じてタスク記録とログで異常の有無を確認します
- Guance の「インフラストラクチャ - リソースディレクトリ」で資産情報が存在するか確認します
- Guance の「メトリクス」で対応する監視データがあるか確認します
メトリクス¶
Kingsoft Cloud のクラウドモニタリングを設定すると、デフォルトのメトリクスセットは以下のとおりです。設定により、さらに多くのメトリクスを収集できます。Kingsoft Cloud KCH ClickHouse の監視メトリクスは kingsoftcloud_kck メトリクスセットにあります。
| MetricName | MetricDescribe | Dimensions | Unit |
|---|---|---|---|
ch_bytes_average |
平均 1 秒あたりの書き込み量 | 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 |
最大 1 秒あたりの書き込み量 | 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 |
最小 1 秒あたりの書き込み量 | 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 |
平均インスタンスの 1 秒あたりの受信トラフィック | 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 |
最大インスタンスの 1 秒あたりの受信トラフィック | 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 |
最小インスタンスの 1 秒あたりの受信トラフィック | 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 |
平均インスタンスの 1 秒あたりの送信トラフィック | 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 |
最大インスタンスの 1 秒あたりの送信トラフィック | 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 |
最小インスタンスの 1 秒あたりの送信トラフィック | 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 |
平均 1 秒あたりのクエリ数 | 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 |
最大 1 秒あたりのクエリ数 | 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 |
最小 1 秒あたりのクエリ数 | 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 |
平均 1 秒あたりの書き込み行数 | 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 |
最大 1 秒あたりの書き込み行数 | 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 |
最小 1 秒あたりの書き込み行数 | 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 |
オブジェクト¶
収集された Kingsoft Cloud 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 の項目は、後続の更新により変更される場合があります。