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 のサポートチームまでお問合せください。