Microsoft Azure DB for MySQL

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.

概要

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
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 long_query_time seconds
Shown as query
azure.dbformysql_flexibleservers.storage_io_count
(count)
The number of storage I/O consumed
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 TRX_RSEG_HISTORY 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.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.dbformysql_flexibleservers.innodb_buffer_pool_pages_dirty
(gauge)
Current number of dirty pages in the innodb buffer pool.
azure.dbformysql_flexibleservers.sort_merge_passes
(gauge)
Number of merge passes that the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
azure.dbformysql_flexibleservers.com_delete
(count)
Number of times DELETE statement has been executed.
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_flushed
(gauge)
Number of requests to flush pages from the innodb buffer pool.

イベント

Azure Database for MySQL インテグレーションには、イベントは含まれません。

サービスチェック

Azure Database for MySQL インテグレーションには、サービスのチェック機能は含まれません。

トラブルシューティング

ご不明な点は、Datadog のサポートチームまでお問合せください。