--- title: Alibaba Cloud AnalyticDB for MySQL description: >- Monitor Alibaba Cloud AnalyticDB for MySQL cluster CPU, disk, query performance, and Spark job resource metrics. breadcrumbs: Docs > Integrations > Alibaba Cloud AnalyticDB for MySQL --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Alibaba Cloud AnalyticDB for MySQL Integration version1.0.0 {% callout %} # Important note for users on the following Datadog sites: us2.ddog-gov.com {% alert level="info" %} To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator. To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com). {% /alert %} {% /callout %} ## Overview{% #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{% #setup %} ### Installation{% #installation %} After you set up the [Alibaba Cloud](https://docs.datadoghq.com/integrations/alibaba_cloud.md) integration, ensure that the AnalyticDB for MySQL service is included in your Alibaba Cloud monitoring configuration. ## Data Collected{% #data-collected %} ### Metrics{% #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{% #events %} Alibaba Cloud AnalyticDB for MySQL does not include any events. ### Service Checks{% #service-checks %} Alibaba Cloud AnalyticDB for MySQL does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).