Alibaba Cloud AnalyticDB for MySQL

Integration version1.0.0

To find out if this integration is available in your organization, see your Datadog Integrations page or ask your organization administrator.

To initiate an exception request to enable this integration for your organization, email support@ddog-gov.com.

Overview

Alibaba Cloud AnalyticDB for MySQL is a cloud-native data warehousing service that provides real-time, massively parallel processing (MPP) analytics on petabyte-scale datasets while remaining compatible with the MySQL protocol.

Use this integration to monitor cluster CPU, memory, and disk usage, query throughput and latency, connection counts, and Spark job resource consumption across your AnalyticDB for MySQL clusters.

Setup

Installation

After you set up the Alibaba Cloud integration, ensure that the AnalyticDB for MySQL service is included in your Alibaba Cloud monitoring configuration.

Data Collected

Metrics

alibabacloud.analyticdb_for_mysql.auto_mc_queued_queries_count_v5.average
(gauge)
Queued SQL count.
Shown as query
alibabacloud.analyticdb_for_mysql.auto_mc_running_queries_count_v5.average
(gauge)
Running SQL count.
Shown as query
alibabacloud.analyticdb_for_mysql.cold_data_disk_usage.average
(gauge)
Cold data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.cold_data_disk_usage_v5.average
(gauge)
Cold data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.executor_down_count.maximum
(gauge)
Number of elastic compute nodes not serving online.
Shown as item
alibabacloud.analyticdb_for_mysql.executor_down_count_v5.maximum
(gauge)
Number of elastic compute nodes not serving online.
Shown as item
alibabacloud.analyticdb_for_mysql.hot_data_disk_usage.average
(gauge)
Hot data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.hot_data_disk_usage_v5.average
(gauge)
Hot data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.lake_cache_dir_data_size_v5.average
(gauge)
LakeCache total cache file size.
Shown as byte
alibabacloud.analyticdb_for_mysql.lake_cache_dir_file_count_v5.average
(gauge)
LakeCache total cache file count.
Shown as item
alibabacloud.analyticdb_for_mysql.lake_cache_hit_ratio_v5.average
(gauge)
LakeCache cache hit rate.
Shown as percent
alibabacloud.analyticdb_for_mysql.lake_cache_read_bytes_v5.average
(gauge)
LakeCache cumulative data read.
Shown as byte
alibabacloud.analyticdb_for_mysql.lake_cache_used_bytes_v5.average
(gauge)
LakeCache cache usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.query_failed_ratio.average
(gauge)
Ratio of failed queries to total queries over a period.
Shown as percent
alibabacloud.analyticdb_for_mysql.query_failed_ratio_v5.average
(gauge)
Ratio of failed queries to total queries over a period.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_avg_cpu_used.average
(gauge)
Access node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_avg_cpu_used_v5.average
(gauge)
Access node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_max_cpu_used.average
(gauge)
Access node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_max_cpu_used_v5.average
(gauge)
Access node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_p95cpu_used.average
(gauge)
Access node P95 CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.rc_p95cpu_used_v5.average
(gauge)
Access node P95 CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.resource_group_cpu_usage_percentage.average
(gauge)
Average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.resource_group_cpu_usage_percentage_v5.average
(gauge)
Average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.spark_cpu_utilization_eci.average
(gauge)
Spark CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.spark_cpu_utilization_shenlong.average
(gauge)
Spark CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.spark_executor_disk_used_bytes.average
(gauge)
RDD Storage disk usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_major_gc_count.average
(gauge)
Major GC count.
Shown as operation
alibabacloud.analyticdb_for_mysql.spark_executor_minor_gc_count.average
(gauge)
Minor GC count.
Shown as operation
alibabacloud.analyticdb_for_mysql.spark_executor_off_heap_execution_memory_bytes.average
(gauge)
Peak off-heap execution memory usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_off_heap_storage_memory_bytes.average
(gauge)
Peak off-heap storage memory usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_on_heap_execution_memory_bytes.average
(gauge)
Peak on-heap execution memory usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_on_heap_storage_memory_bytes.average
(gauge)
Peak on-heap storage memory usage.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_total_gc_time_seconds.average
(gauge)
Spark GC duration.
Shown as second
alibabacloud.analyticdb_for_mysql.spark_executor_total_input_bytes_bytes_total.average
(gauge)
Spark read data count.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_total_shuffle_read_bytes.average
(gauge)
Spark Shuffle read data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_executor_total_shuffle_write_bytes.average
(gauge)
Spark Shuffle write data volume.
Shown as byte
alibabacloud.analyticdb_for_mysql.spark_memory_utilization_eci.average
(gauge)
Spark memory usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.spark_memory_utilization_shenlong.average
(gauge)
Spark memory usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.synchronization_latency.average
(gauge)
Synchronization latency.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.wlm_resubmit_queries_count.average
(gauge)
Resubmitted query count.
Shown as query
alibabacloud.analyticdb_for_mysql.wlm_resubmit_queries_count_v5.average
(gauge)
Resubmitted query count.
Shown as query
alibabacloud.analyticdb_for_mysql.wlm_sqa_avg_rt_ms.average
(gauge)
Small query average response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.wlm_sqa_avg_rt_ms_v5.average
(gauge)
Small query average response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.wlm_sqa_queries_count.average
(gauge)
Small query count.
Shown as query
alibabacloud.analyticdb_for_mysql.wlm_sqa_queries_count_v5.average
(gauge)
Small query count.
Shown as query
alibabacloud.analyticdb_for_mysql.wlm_sqa_queries_percentage.average
(gauge)
Small query percentage.
Shown as percent
alibabacloud.analyticdb_for_mysql.wlm_sqa_queries_percentage_v5.average
(gauge)
Small query percentage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_down_count.maximum
(gauge)
Number of storage nodes not serving online.
Shown as item
alibabacloud.analyticdb_for_mysql.worker_down_count_v5.maximum
(gauge)
Number of reserved resource nodes not serving online.
Shown as item
alibabacloud.analyticdb_for_mysql.aps_avg_latency.average
(gauge)
Data ingestion link average read latency.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_avg_latency_v3.average
(gauge)
Data ingestion link average read latency.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_avg_latency_by_job.average
(gauge)
Data ingestion link average read latency (per job).
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_avg_latency_by_job_v3.average
(gauge)
Data ingestion link average read latency (per job).
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_max_latency.average
(gauge)
Data ingestion link maximum read latency.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_max_latency_v3.average
(gauge)
Data ingestion link maximum read latency.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_max_latency_by_job.average
(gauge)
Data ingestion link maximum read latency (per job).
Shown as millisecond
alibabacloud.analyticdb_for_mysql.aps_max_latency_by_job_v3.average
(gauge)
Data ingestion link maximum read latency (per job).
Shown as millisecond
alibabacloud.analyticdb_for_mysql.connections.average
(gauge)
Number of connections.
Shown as connection
alibabacloud.analyticdb_for_mysql.connections_v5.average
(gauge)
Number of connections.
Shown as connection
alibabacloud.analyticdb_for_mysql.delete_avg_rt.average
(gauge)
Average delete response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.delete_avg_rt_v5.average
(gauge)
Average delete response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.delete_max_rt.average
(gauge)
Maximum delete response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.delete_max_rt_v5.average
(gauge)
Maximum delete response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.disk_used_mb.average
(gauge)
Average node hot data volume.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.disk_used_mb_v5.average
(gauge)
Average node hot data volume.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.disk_used_percent.average
(gauge)
Average node disk usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.executor_avg_cpu_used.average
(gauge)
Compute node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.executor_avg_cpu_used_v5.average
(gauge)
Elastic compute node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.executor_avg_read_bytes_mb.average
(gauge)
Compute node average disk read throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.executor_avg_read_bytes_mb_v5.average
(gauge)
Elastic compute node average disk read throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.executor_avg_read_iops.average
(gauge)
Compute node average disk read IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.executor_avg_read_iops_v5.average
(gauge)
Elastic compute node average disk read IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.executor_avg_write_bytes_mb.average
(gauge)
Compute node average disk write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.executor_avg_write_bytes_mb_v5.average
(gauge)
Elastic compute node average disk write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.executor_avg_write_iops.average
(gauge)
Compute node average disk write IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.executor_avg_write_iops_v5.average
(gauge)
Elastic compute node average disk write IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.executor_max_cpu_used.average
(gauge)
Compute node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.executor_max_cpu_used_v5.average
(gauge)
Elastic compute node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.insert_avg_rt.average
(gauge)
Average insert response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.insert_avg_rt_v5.average
(gauge)
Average insert response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.insert_in_bytes.average
(gauge)
Write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.insert_in_bytes_v5.average
(gauge)
Write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.insert_max_rt.average
(gauge)
Maximum insert response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.insert_max_rt_v5.average
(gauge)
Maximum insert response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.qps.average
(gauge)
Queries per second.
Shown as query
alibabacloud.analyticdb_for_mysql.qps_v5.average
(gauge)
Queries per second.
Shown as query
alibabacloud.analyticdb_for_mysql.query_avg_rt.average
(gauge)
Average query response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_avg_rt_v5.average
(gauge)
Average query response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_failed_ratio_non_syntax_error.average
(gauge)
Query failure rate (excluding syntax errors).
Shown as percent
alibabacloud.analyticdb_for_mysql.query_failed_ratio_non_syntax_error_v5.average
(gauge)
Query failure rate (excluding syntax errors).
Shown as percent
alibabacloud.analyticdb_for_mysql.query_max_rt.average
(gauge)
Maximum query response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_max_rt_v5.average
(gauge)
Maximum query response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_max_wait_time.average
(gauge)
Maximum query wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_max_wait_time_v5.average
(gauge)
Maximum query wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_total_wait_time.average
(gauge)
Average query wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.query_total_wait_time_v5.average
(gauge)
Average query wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.queued_queries.average
(gauge)
Queued query count.
Shown as query
alibabacloud.analyticdb_for_mysql.queued_queries_v5.average
(gauge)
Queued query count.
Shown as query
alibabacloud.analyticdb_for_mysql.rc_down_count.average
(gauge)
Access node down count.
Shown as item
alibabacloud.analyticdb_for_mysql.rc_down_count_v5.average
(gauge)
Access node down count.
Shown as item
alibabacloud.analyticdb_for_mysql.running_queries.average
(gauge)
Running query count.
Shown as query
alibabacloud.analyticdb_for_mysql.running_queries_v5.average
(gauge)
Running query count.
Shown as query
alibabacloud.analyticdb_for_mysql.total_queries.average
(gauge)
Total query count.
Shown as query
alibabacloud.analyticdb_for_mysql.total_queries_v5.average
(gauge)
Total query count.
Shown as query
alibabacloud.analyticdb_for_mysql.tps.average
(gauge)
Write transactions per second.
Shown as transaction
alibabacloud.analyticdb_for_mysql.tps_v5.average
(gauge)
Write transactions per second.
Shown as transaction
alibabacloud.analyticdb_for_mysql.updateinto_avg_rt.average
(gauge)
Average update response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.updateinto_avg_rt_v5.average
(gauge)
Average update response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.updateinto_max_rt.average
(gauge)
Maximum update response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.updateinto_max_rt_v5.average
(gauge)
Maximum update response time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.worker_avg_cpu_used.average
(gauge)
Storage node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_avg_cpu_used_v5.average
(gauge)
Reserved resource node average CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_avg_io_await.average
(gauge)
Reserved resource node average disk IO wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.worker_avg_io_await_v5.average
(gauge)
Storage node average disk IO wait time.
Shown as millisecond
alibabacloud.analyticdb_for_mysql.worker_avg_io_util.average
(gauge)
Storage node average disk IO usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_avg_io_util_v5.average
(gauge)
Reserved resource node average disk IO usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_avg_read_bytes.average
(gauge)
Storage node average disk read throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_avg_read_bytes_v5.average
(gauge)
Reserved resource node average disk read throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_avg_read_iops.average
(gauge)
Storage node average disk read IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.worker_avg_read_iops_v5.average
(gauge)
Reserved resource node average disk read IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.worker_avg_write_bytes.average
(gauge)
Storage node average disk write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_avg_write_bytes_v5.average
(gauge)
Reserved resource node average disk write throughput.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_avg_write_iops.average
(gauge)
Storage node average disk write IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.worker_avg_write_iops_v5.average
(gauge)
Reserved resource node average disk write IOPS.
Shown as operation
alibabacloud.analyticdb_for_mysql.worker_max_cpu_used.average
(gauge)
Storage node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_max_cpu_used_v5.average
(gauge)
Reserved resource node maximum CPU usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_max_node_disk_used_mb.average
(gauge)
Maximum node hot data volume.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_max_node_disk_used_mb_v5.average
(gauge)
Maximum node hot data volume.
Shown as mebibyte
alibabacloud.analyticdb_for_mysql.worker_max_node_disk_used_percent.average
(gauge)
Maximum node disk usage.
Shown as percent
alibabacloud.analyticdb_for_mysql.worker_max_node_disk_used_percent_v5.average
(gauge)
Maximum node disk usage.
Shown as percent

Events

Alibaba Cloud AnalyticDB for MySQL does not include any events.

Service Checks

Alibaba Cloud AnalyticDB for MySQL does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.