Microsoft Azure DB for MySQL

개요

Azure Database for MySQL는 완전관리형 엔터프라이즈 지원 커뮤니티 MySQL 데이터베이스를 제공하는 서비스입니다.

Azure Database for MySQL 메트릭을 얻으면 다음을 할 수 있습니다.

  • MySQL 데이터베이스의 성능을 가시화
  • MySQL 데이터베이스의 성능과 애플리케이션의 상관 관계 파악

설정

설치

아직 설정하지 않았다면, 먼저 Microsoft Azure 통합을 설정하세요. 그 외 다른 설치 단계는 없습니다.

수집한 데이터

메트릭

azure.dbformysql_flexibleservers.aborted_connections
(count)		Aborted Connections
Shown as connection
azure.dbformysql_flexibleservers.active_connections
(gauge)		Active Connections
Shown as connection
azure.dbformysql_flexibleservers.active_transactions
(gauge)		Number of active transactions
Shown as transaction
azure.dbformysql_flexibleservers.backup_storage_used
(gauge)		Backup Storage used
Shown as byte
azure.dbformysql_flexibleservers.binlog_storage_used
(gauge)		Storage used by Binlog files
Shown as byte
azure.dbformysql_flexibleservers.com_alter_table
(count)		The total number of times ALTER TABLE statement has been executed
azure.dbformysql_flexibleservers.com_create_db
(count)		The total number of times CREATE DB statement has been executed
azure.dbformysql_flexibleservers.com_create_table
(count)		The total number of times CREATE TABLE statement has been executed
azure.dbformysql_flexibleservers.com_drop_db
(count)		The total number of times DROP DB statement has been executed
azure.dbformysql_flexibleservers.com_drop_table
(count)		The total number of times DROP TABLE statement has been executed
azure.dbformysql_flexibleservers.com_insert
(count)		The total number of times INSERT statement has been executed
azure.dbformysql_flexibleservers.com_select
(count)		The total number of times SELECT statement has been executed
azure.dbformysql_flexibleservers.com_update
(count)		The total number of times UPDATE statement has been executed
azure.dbformysql_flexibleservers.core_count
(gauge)		Core count
azure.dbformysql_flexibleservers.count
(gauge)		The count of Azure MySQL server integration
azure.dbformysql_flexibleservers.cpu_credits_consumed
(gauge)		CPU Credits Consumed
Shown as byte
azure.dbformysql_flexibleservers.cpu_credits_remaining
(gauge)		CPU Credits Remaining
Shown as byte
azure.dbformysql_flexibleservers.cpu_percent
(gauge)		Host CPU Percent
Shown as percent
azure.dbformysql_flexibleservers.data_storage_used
(gauge)		Storage used by data files
Shown as byte
azure.dbformysql_flexibleservers.ha_io_status
(gauge)		Status for replication IO thread running
azure.dbformysql_flexibleservers.ha_replication_lag
(gauge)		HA Replication lag in seconds
Shown as second
azure.dbformysql_flexibleservers.ha_sql_status
(gauge)		Status for replication SQL thread running
azure.dbformysql_flexibleservers.ibdata1_storage_used
(gauge)		Storage used by ibdata1 files
Shown as byte
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data
(count)		The number of pages in the InnoDB buffer pool containing data
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data_dirty
(count)		The current number of dirty pages in the InnoDB buffer pool
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data_flushed
(gauge)		The number of requests to flush pages from the InnoDB buffer pool
Shown as request
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_free
(count)		The total number of free pages in the InnoDB buffer pool
Shown as page
azure.dbformysql_flexibleservers.innodb_buffer_pool_read_requests
(count)		The total number of logical read requests
Shown as request
azure.dbformysql_flexibleservers.innodb_buffer_pool_reads
(count)		The total number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk
Shown as read
azure.dbformysql_flexibleservers.innodb_data_writes
(count)		The total number of data writes
Shown as write
azure.dbformysql_flexibleservers.innodb_row_lock_time
(gauge)		The total time spent in acquiring row locks for InnoDB tables, in milliseconds
Shown as millisecond
azure.dbformysql_flexibleservers.innodb_row_lock_waits
(gauge)		The number of times operations on InnoDB tables had to wait for a row lock
azure.dbformysql_flexibleservers.io_consumption_percent
(gauge)		IO percent
Shown as percent
azure.dbformysql_flexibleservers.lock_deadlocks
(gauge)		Number of deadlocks
Shown as deadlock
azure.dbformysql_flexibleservers.lock_timeouts
(gauge)		Number of lock timeouts
azure.dbformysql_flexibleservers.memory_percent
(gauge)		Memory percent
Shown as percent
azure.dbformysql_flexibleservers.network_bytes_egress
(count)		Network Out across active connections
Shown as byte
azure.dbformysql_flexibleservers.network_bytes_ingress
(count)		Network In across active connections
Shown as byte
azure.dbformysql_flexibleservers.others_storage_used
(gauge)		Storage used by other files
Shown as byte
azure.dbformysql_flexibleservers.queries
(count)		The number of queries
Shown as query
azure.dbformysql_flexibleservers.replica_io_running
(gauge)		Status for replication IO thread running
azure.dbformysql_flexibleservers.replica_sql_running
(gauge)		Status for replication SQL thread running
azure.dbformysql_flexibleservers.replication_lag
(gauge)		Replication lag in seconds
Shown as second
azure.dbformysql_flexibleservers.serverlog_storage_limit
(gauge)		Serverlog Storage Limit
Shown as byte
azure.dbformysql_flexibleservers.serverlog_storage_percent
(gauge)		Serverlog Storage Percent
Shown as percent
azure.dbformysql_flexibleservers.serverlog_storage_usage
(gauge)		Serverlog Storage Usage
Shown as byte
azure.dbformysql_flexibleservers.slow_queries
(count)		The total number of queries that have taken more than longquerytime seconds
Shown as query
azure.dbformysql_flexibleservers.storage_io_count
(count)		The number of storage I/O consumed
azure.dbformysql_flexibleservers.status
(gauge)		Status of Azure DB for MySQL integration (deprecated)
azure.dbformysql_flexibleservers.storage_limit
(gauge)		Storage limit
Shown as byte
azure.dbformysql_flexibleservers.storage_percent
(gauge)		DB storage in percent
Shown as percent
azure.dbformysql_flexibleservers.storage_used
(gauge)		DB storage used in bytes
Shown as byte
azure.dbformysql_flexibleservers.threads_running
(count)		The total number of threads that are not sleeping
Shown as thread
azure.dbformysql_flexibleservers.total_connections
(count)		Total Connections
Shown as connection
azure.dbformysql_flexibleservers.threads_running
(count)		The total number of threads that are not sleeping
Shown as thread
azure.dbformysql_flexibleservers.trx_rseg_history_len
(gauge)		Length of the TRXRSEGHISTORY list
azure.dbformysql_flexibleservers.uptime
(gauge)		The number of seconds that the server has been up
Shown as second
azure.dbformysql_servers.active_connections
(gauge)		Active Connections
Shown as connection
azure.dbformysql_servers.backup_storage_used
(gauge)		Backup Storage used
Shown as byte
azure.dbformysql_servers.connections_failed
(count)		Failed Connections
Shown as connection
azure.dbformysql_servers.core_count
(gauge)		Core count
azure.dbformysql_servers.count
(gauge)		The count of Azure MySQL server integration
azure.dbformysql_servers.cpu_percent
(gauge)		CPU percent
Shown as percent
azure.dbformysql_servers.io_consumption_percent
(gauge)		IO percent
Shown as percent
azure.dbformysql_servers.memory_percent
(gauge)		Memory percent
Shown as percent
azure.dbformysql_servers.network_bytes_egress
(count)		Network Out across active connections
Shown as byte
azure.dbformysql_servers.network_bytes_ingress
(count)		Network In across active connections
Shown as byte
azure.dbformysql_servers.seconds_behind_master
(gauge)		Replication lag in seconds
Shown as second
azure.dbformysql_servers.serverlog_storage_limit
(gauge)		Server Log storage limit
Shown as byte
azure.dbformysql_servers.serverlog_storage_percent
(gauge)		Server Log storage percent
Shown as percent
azure.dbformysql_servers.serverlog_storage_usage
(gauge)		Server Log storage used
Shown as byte
azure.dbformysql_servers.status
(gauge)		Status of Azure DB for MySQL integration (deprecated)
azure.dbformysql_servers.storage_limit
(gauge)		Storage limit
Shown as byte
azure.dbformysql_servers.storage_percent
(gauge)		DB storage in percent
Shown as percent
azure.dbformysql_servers.storage_used
(gauge)		DB storage used in bytes
Shown as byte

이벤트

Azure Database for MySQL 통합에는 이벤트가 포함되어 있지 않습니다.

서비스 점검

Azure Database for MySQL 통합에는 서비스 점검이 포함되어 있지 않습니다.

트러블슈팅

도움이 필요하신가요? Datadog 지원팀에 문의하세요.