GCP Cloud SQL
采集 GCP Cloud SQL 指标
配置¶
安装 Func¶
推荐开通 观测云集成 - 扩展 - 托管版 Func: 一切前置条件都自动安装好, 请继续脚本安装
如果自行部署 Func 参考自行部署 Func
安装脚本¶
-
登陆Func 控制台，点击【脚本市场】，进入观测云脚本市场，搜索
integration_gcp_cloudsql -
点击【安装】后，输入相应的参数：账户文件名、Target Principal、帐号名
-
点击【部署启动脚本】，系统会自动创建
Startup脚本集，并自动配置相应的启动脚本。 -
开启后可以在「管理 / 自动触发配置」里看到对应的自动触发配置。点击【执行】，即可立即执行一次，无需等待定期时间。稍等片刻，可以查看执行任务记录以及对应日志。
验证¶
- 在「管理 / 自动触发配置」确认对应的任务是否已存在对应的自动触发配置，同时可以查看对应任务记录及日志检查是否有异常
- 在观测云，「基础设施 / 自定义」中查看是否存在资产信息
- 在观测云，「指标」查看是否有对应监控数据
指标¶
GCP Cloud SQL 指标在 gcp_cloudsql 指标集下，以下是指标说明
GCP MySQL 指标¶
| 指标 | 原始指标 | 描述信息 | 单位 |
|---|---|---|---|
| database_cpu_reserved_cores | database/cpu/reserved_cores |
CPU 保留的核心数 | Count |
| database_cpu_usage_time | database/cpu/usage_time |
CPU 用量 | 秒 |
| database_cpu_utilization | database/cpu/utilization |
CPU 用量 | % |
| database_disk_bytes_used_by_data_type | database/disk/bytes_used_by_data_type |
使用的字节数 | Bytes |
| database_disk_bytes_used | database/disk/bytes_used |
使用的字节数 | Bytes |
| database_disk_quota | database/disk/quota |
磁盘配额 | Bytes |
| database_disk_read_bytes_count | database/disk/read_bytes_count |
磁盘读取字节数 | Bytes |
| database_disk_read_ops_count | database/disk/read_ops_count |
磁盘读取 IO | Count |
| database_disk_write_ops_count | database/disk/write_ops_count |
磁盘写入 IO | Count |
| database_disk_utilization | database/disk/utilization |
磁盘利用率 | % |
| database_disk_write_bytes_count | database/disk/write_bytes_count |
磁盘写入字节数 | Bytes |
| database_instance_state | database/instance_state |
实例状态 | 数值 |
| database_memory_components | database/memory/components |
内存组件 | % |
| database_memory_quota | database/memory/quota |
内存配额 | Bytes |
| database_memory_total_usage | database/memory/total_usage |
总内存用量 | % |
| database_memory_usage | database/memory/usage |
内存用量 | Bytes |
| database_memory_utilization | database/memory/utilization |
内存利用率 | % |
| database_mysql_aborted_clients_count | database/mysql/aborted_clients_count |
MySQL 中止的客户端数 | Count |
| database_mysql_aborted_connects_count | database/mysql/aborted_connects_count |
MySQL 中止的连接数 | Count |
| database_mysql_connections_count | database/mysql/connections_count |
MySQL 连接数 | Count |
| database_mysql_ddl_operations_count | database/mysql/ddl_operations_count |
MySQL DDL 操作数 | Count |
| database_mysql_dml_operations_count | database/mysql/dml_operations_count |
MySQL DML 操作数 | Count |
| database_mysql_handler_operations_count | database/mysql/handler_operations_count |
MySQL 处理程序操作数 | Count |
| database_mysql_innodb_active_transactions | database/mysql/innodb/active_transactions |
InnoDB 活跃事务数 | Count |
| database_mysql_innodb_active_trx_longest_time | database/mysql/innodb/active_trx_longest_time |
InnoDB 活跃事务最长时间 | Count |
| database_mysql_innodb_active_trx_rows_locked | database/mysql/innodb/active_trx_rows_locked |
InnoDB 活跃事务锁定行数 | Count |
| database_mysql_innodb_active_trx_rows_modified | database/mysql/innodb/active_trx_rows_modified |
InnoDB 活跃事务修改的行数 | Count |
| database_mysql_innodb_active_trx_total_time | database/mysql/innodb/active_trx_total_time |
InnoDB 活跃事务总时间 | s |
| database_mysql_innodb_adaptive_hash_operation_count | database/mysql/innodb/adaptive_hash_operation_count |
Innodb AHI 操作数 | Count |
| database_mysql_innodb_ahi_search_count | database/mysql/innodb/ahi_search_count |
AHI 或 Btree 搜索次数 | Count |
| database_mysql_innodb_buffer_flush_sync_waits_count | database/mysql/innodb/buffer_flush_sync_waits_count |
Innodb 同步刷新等待时间 | s |
| database_mysql_innodb_buffer_pool_pages | database/mysql/innodb/buffer_pool_pages |
InnoDB 缓冲区池页面 | Count |
| database_mysql_innodb_buffer_pool_read_requests_count | database/mysql/innodb/buffer_pool_read_requests_count |
Innodb 缓冲池读取请求数 | Count |
| database_mysql_innodb_buffer_pool_reads_count | database/mysql/innodb/buffer_pool_reads_count |
Innodb 缓冲池读取次数 | Count |
| database_mysql_innodb_buffer_pool_write_requests_count | database/mysql/innodb/buffer_pool_write_requests_count |
InnoDB 缓冲区池写入请求数 | Count |
| database_mysql_innodb_data_cache_cache_hit_count | database/mysql/innodb/data_cache/cache_hit_count |
MySQL 数据缓存命中次数 | Count |
| database_mysql_innodb_data_cache_cache_miss_count | database/mysql/innodb/data_cache/cache_miss_count |
MySQL 数据缓存未命中次数 | Count |
| database_mysql_innodb_data_cache_pages | database/mysql/innodb/data_cache/pages |
数据缓存中的 Innodb 页面数 | Count |
| database_mysql_innodb_data_fsyncs | database/mysql/innodb/data_pending_fsyncs |
InnoDB 数据待处理的 Fsync 操作数 | Count |
| database_mysql_innodb_deadlocks_count | database/mysql/innodb/deadlocks_count |
InnoDB 死锁数 | Count |
| database_mysql_innodb_dictionary_memory | database/mysql/innodb/dictionary_memory |
MySQL InnoDB 字典缓存 | Bytes |
| database_mysql_innodb_history_list_length | database/mysql/innodb/history_list_length |
MySQL InnoDB 字典缓存 | Bytes |
| database_mysql_innodb_ibuf_merge_operation_count | database/mysql/innodb/ibuf_merge_operation_count |
InnoDB 合并记录（按操作） | Count |
| database_mysql_innodb_ibuf_merges_count | database/mysql/innodb/ibuf_merges_count |
InnoDB 更改缓冲区合并次数 | Count |
| database/mysql/innodb/innodb_log_waits_count | database/mysql/innodb/innodb_log_waits_count |
事务等待 Innodb 日志缓冲区刷新 | Count |
| database_mysql_innodb_lock_timeout_count | database/mysql/innodb/lock_timeout_count |
Innodb 行锁定等待超时次数 | Count |
| database_mysql_innodb_lsn | database/mysql/innodb/lsn |
MySQL InnoDB 字典缓存 | Bytes |
| database_mysql_innodb_operation_disk_io_count | database/mysql/innodb/operation_disk_io_count |
由 InnoDB 执行的磁盘 IO | Count |
| database_mysql_innodb_os_log_fsyncs | database/mysql/innodb/os_log_fsyncs_count |
Innodb OS 日志 Fsyncs 计数 | Count |
| database_mysql_innodb_os_log_pending_fsyncs | database/mysql/innodb/os_log_pending_fsyncs |
InnoDB OS 日志待处理的 Fsync 操作次数 | Count |
| database_mysql_innodb_os_log_pending_writes | database/mysql/innodb/os_log_pending_writes |
InnoDB OS 日志待处理写入 | Count |
| database_mysql_innodb_pages_read | database/mysql/innodb_pages_read |
Innodb 页面读取次数 | Bytes |
| database_mysql_max_connections | database/mysql/max_connections |
MySQL 最大连接数 | Count |
| database_mysql_open_tables | database/mysql/open_tables |
MySQL 打开的表数 | Count |
| database_mysql_threads | database/mysql/threads |
MySQL 线程数 | Count |
| database_network_connections | database/network/connections |
Cloud SQL 连接 | Count |
| database_network_received_bytes_count | database/mysql/open_tables |
MySQL 打开的表数 | Count |
| database_network_sent_bytes_count | database/network/received_bytes_count |
收到的字节数 | Bytes |
GCP PostgreSQL 指标¶
| 指标 | 原始指标 | 描述信息 | 单位 |
|---|---|---|---|
| database_postgresql_backends_in_wait | database/postgresql/backends_in_wait |
等待中的 PostgreSQL 后端 | Count |
| database_postgresql_blocks_read_count | database/postgresql/blocks_read_count |
读取的磁盘块数 | Count |
| database_postgresql_checkpoint_count | database/postgresql/checkpoint_count |
CPU 保留的核心数 | Count |
| database_postgresql_data_cache_hit_count | database/postgresql/data_cache/hit_count |
PostgreSQL 数据缓存命中次数 | Count |
| database_postgresql_data_cache_hit_ratio | database/postgresql/data_cache/hit_ratio |
PostgreSQL 数据缓存命中率 | % |
| database_postgresql_data_cache_miss_count | database/postgresql/data_cache/miss_count |
缓存未命中次数 | Count |
| database_postgresql_deadlock_count | database/postgresql/deadlock_count |
死锁数 | Count |
| database_postgresql_insights_aggregate_execution_time | database/postgresql/insights/aggregate/execution_time |
执行时间 | us |
| database_postgresql_insights_aggregate_io_time | database/postgresql/insights/aggregate/io_time |
IO时间 | us |
| database_postgresql_insights_aggregate_latencies | database/postgresql/insights/aggregate/latencies |
延迟时间 | us |
| database_postgresql_insights_aggregate_lock_time | database/postgresql/insights/aggregate/lock_time |
汇总锁定时间 | us |
| database_postgresql_insights_aggregate_shared_blk_access_count | database/postgresql/insights/aggregate/shared_blk_access_count |
共享块缓存访问 | Count |
| database_postgresql_insights_perquery_execution_time | database/postgresql/insights/perquery/execution_time |
每次查询的执行时间 | us |
| database_postgresql_insights_perquery_io_time | database/postgresql/insights/perquery/io_time |
每次查询执行的 IO 时间 | us |
| database_postgresql_insights_perquery_latencies | database/postgresql/insights/perquery/latencies |
每次查询的延迟时间 | us |
| database_postgresql_insights_perquery_lock_time | database/postgresql/insights/perquery/lock_time |
每次查询的锁定时间 | us |
| database_postgresql_insights_perquery_row_count | database/postgresql/insights/perquery/row_count |
每个查询影响的行数 | Count |
| database_postgresql_insights_perquery_shared_blk_access_count | database/postgresql/insights/perquery/shared_blk_access_count |
每次查询的共享块缓存访问次数 | Count |
| database_postgresql_insights_pertag_execution_time | database/postgresql/insights/pertag/execution_time |
每次代码执行时间 | us |
| database_postgresql_insights_pertag_io_time | database/postgresql/insights/pertag/io_time |
每个标记的 IO 时间 | Count |
| database_postgresql_insights_pertag_latencies | database/postgresql/insights/pertag/latencies |
每个标记的延迟时间 | us |
| database_postgresql_insights_pertag_lock_time | database/postgresql/insights/pertag/lock_time |
每个标记的锁定时间 | us |
| database_postgresql_insights_pertag_row_count | database/postgresql/insights/pertag/row_count |
每个标记影响的行数 | Count |
| database_postgresql_insights_pertag_shared_blk_access_count | database/postgresql/backends_in_wait |
每个标记访问的共享块缓存 | Count |
| database_postgresql_new_connection_count | database/postgresql/new_connection_count |
PostgreSQL 新连接数 | Count |
| database_postgresql_num_backends | database/postgresql/num_backends |
PostgreSQL 连接数 | Count |
| database_postgresql_num_backends_by_state | database/postgresql/num_backends_by_state |
按状态划分的 PostgreSQL 连接数 | Count |
| database_postgresql_replication_replica_byte_lag | database/postgresql/backends_in_wait |
滞后的字节数 | B |
| database_postgresql_statements_executed_count | database/postgresql/statements_executed_count |
执行的语句数 | Count |
| database_postgresql_temp_bytes_written_count | database/postgresql/temp_bytes_written_count |
写入临时文件的数据（以字节为单位） | B |
| database_postgresql_temp_files_written_count | database/postgresql/temp_files_written_count |
用于写入数据的临时文件 | Count |
| database_postgresql_transaction_count | database/postgresql/transaction_count |
交易数量 | Count |
| database_postgresql_transaction_id_utilization | database/postgresql/transaction_id_utilization |
事务 ID 利用率 | % |
| database_postgresql_tuple_size | database/postgresql/tuple_size |
数据库中的元组（行）数量 | Count |
| database_postgresql_tuples_fetched_count | database/postgresql/tuples_fetched_count |
提取的元组数 | Count |
| database_postgresql_tuples_processed_count | database/postgresql/tuples_processed_count |
处理的行数 | % |
| database_postgresql_tuples_returned_count | database/postgresql/tuples_returned_count |
返回的元组数 | % |
| database_postgresql_vacuum_oldest_transaction_age | database/postgresql/vacuum/oldest_transaction_age |
最早事务的存在时长 | s |
| database_postgresql_write_ahead_log_flushed_bytes_count | database/postgresql/write_ahead_log/flushed_bytes_count |
PostgreSQL WAL 刷新字节数 | B |
| database_postgresql_write_ahead_log_written_bytes_count | database/postgresql/write_ahead_log/written_bytes_count |
PostgreSQL WAL 写入的字节数 | B |
| database_replication_log_archive_failure_count | database/replication/log_archive_failure_count |
日志归档失败次数 | B |
| database_replication_log_archive_success_count | database/replication/log_archive_success_count |
成功归档的日志数量 | Count |