MySQL 메트릭

문서 > OpenTelemetry in Datadog > Integrations > MySQL 메트릭

개요

MySQL 수신기를 사용하면 MySQL 메트릭을 수집하고 MySQL Overview 대시보드에 접근할 수 있습니다. mysqlreceiver 최신 버전 사양에 따라 수신기를 구성하세요.

자세한 내용은 OpenTelemetry 프로젝트 문서의 MySQL receiver 항목을 참고하세요.

설정

Datadog에서 사용할 MySQL 메트릭을 OpenTelemetry로 수집하는 방법:

OpenTelemetry Collector 구성에서 MySQL 수신기를 설정하세요.
OpenTelemetry Collector가 MySQL 데이터베이스와 동일한 서버에서 실행 중인 경우, 선택적으로 호스트 메트릭 수신기를 구성할 수 있습니다.
OpenTelemetry Collector가 MySQL 데이터베이스와 동일한 서버에서 실행 중인 경우, 선택적으로 파일 로그 수신기를 구성할 수 있습니다.
서비스 파이프라인을 구성합니다.
OpenTelemetry Collector가 Datadog로 내보내도록 구성되어 있는지 확인하세요.

MySQL 수신기

receivers:
  mysql/mysql-host-1:
    endpoint: "<HOST>:<PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    collection_interval: 10s
    metrics:
      mysql.connection.count:
        enabled: true
      mysql.connection.errors:
        enabled: true
      mysql.commands:
        enabled: true
      mysql.query.slow.count:
        enabled: true
      mysql.max_used_connections:
        enabled: true

processors:
  resource/mysql-host-1:
    attributes:
      - action: insert
        key: datadog.host.name
        value: <HOST>
  transform/mysql-host-1:
    metric_statements:
      - convert_sum_to_gauge() where metric.name == "mysql.locks"
  cumulativetodelta: {}
  deltatorate:
    metrics:
      - mysql.connection.count
      - mysql.commands
      - mysql.operations
      - mysql.query.slow.count
      - mysql.connection.errors
      - mysql.log_operations
      - system.network.io

자세한 구성 옵션 및 요구 사항은 MySQL 수신기 설명서를 참고하세요.

호스트 메트릭 수신기

receivers:
  hostmetrics:
    scrapers:
      load:
      cpu:
        metrics:
         system.cpu.utilization:
           enabled: true
      memory:
      network:

파일 로그 수신기

receivers:
  filelog:
    include:
      - <PATH_TO_YOUR_MYSQL_ERROR_LOG>
      - <PATH_TO_YOUR_MYSQL_LOG_FILE>
    operators:
      - type: json_parser
        parse_from: body
        timestamp:
          parse_from: attributes.timestamp
          layout: "%Y-%m-%dT%H:%M:%SZ"

processors:
  transform/logs:
    log_statements:
      - context: resource
        statements:
          - set(attributes["datadog.host.name"], "<HOST>")
          - set(attributes["datadog.log.source"], "mysql")

  batch: {}

서비스 파이프라인

service:
  pipelines:
    metrics/mysql-host-1:
      receivers: [mysql/mysql-host-1]
      exporters: [datadog/exporter]
      processors: [resource/mysql-host-1,cumulativetodelta,deltatorate,transform/mysql-host-1]

구성한 경우 hostmetrics 및 filelog 수신기를 추가합니다. 예:

      receivers: [mysql/mysql-host-1,hostmetrics,filelog]

수집한 데이터

OTEL	DATADOG	DESCRIPTION	FILTER
mysql.buffer_pool.data_pages	mysql.innodb.buffer_pool_pages_dirty	The number of data pages in the InnoDB buffer pool.	`status`: `dirty`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_read_ahead	The number of operations on the InnoDB buffer pool.	`operation`: `read_ahead`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_read_ahead_evicted	The number of operations on the InnoDB buffer pool.	`operation`: `read_ahead_evicted`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_read_ahead_rnd	The number of operations on the InnoDB buffer pool.	`operation`: `read_ahead_rnd`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_read_requests	The number of operations on the InnoDB buffer pool.	`operation`: `read_requests`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_reads	The number of operations on the InnoDB buffer pool.	`operation`: `reads`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_wait_free	The number of operations on the InnoDB buffer pool.	`operation`: `wait_free`
mysql.buffer_pool.operations	mysql.innodb.buffer_pool_write_requests	The number of operations on the InnoDB buffer pool.	`operation`: `write_requests`
mysql.buffer_pool.page_flushes	mysql.innodb.buffer_pool_pages_flushed	The number of requests to flush pages from the InnoDB buffer pool.
mysql.buffer_pool.pages	mysql.innodb.buffer_pool_pages_data	The number of pages in the InnoDB buffer pool.	`kind`: `data`
mysql.buffer_pool.pages	mysql.innodb.buffer_pool_pages_free	The number of pages in the InnoDB buffer pool.	`kind`: `free`
mysql.buffer_pool.usage	mysql.innodb.buffer_pool_data	The number of bytes in the InnoDB buffer pool.
mysql.buffer_pool.usage	mysql.innodb.buffer_pool_dirty	The number of bytes in the InnoDB buffer pool.	`status`: `dirty`
mysql.client.network.io	mysql.performance.bytes_received	The number of transmitted bytes between server and clients.	`kind`: `received`
mysql.client.network.io	mysql.performance.bytes_sent	The number of transmitted bytes between server and clients.	`kind`: `sent`
mysql.commands	mysql.performance.com_select	The number of times each type of command has been executed.	`command`: `select`
mysql.commands	mysql.performance.com_update	The number of times each type of command has been executed.	`command`: `update`
mysql.commands	mysql.performance.com_delete	The number of times each type of command has been executed.	`command`: `delete`
mysql.commands	mysql.performance.com_insert	The number of times each type of command has been executed.	`command`: `insert`
mysql.connection.count	mysql.net.connections	The number of connection attempts (successful or not) to the MySQL server.
mysql.connection.errors	mysql.net.aborted_connects	Errors that occur during the client connection process.	`error`: `aborted`
mysql.double_writes	mysql.innodb.dblwr_pages_written	The number of writes to the InnoDB doublewrite buffer.	`kind`: `pages_written`
mysql.double_writes	mysql.innodb.dblwr_writes	The number of writes to the InnoDB doublewrite buffer.	`kind`: `writes`
mysql.handlers	mysql.performance.handler_write	The number of requests to various MySQL handlers.	`kind`: `write`
mysql.handlers	mysql.performance.handler_update	The number of requests to various MySQL handlers.	`kind`: `update`
mysql.handlers	mysql.performance.handler_rollback	The number of requests to various MySQL handlers.	`kind`: `rollback`
mysql.handlers	mysql.performance.handler_read_rnd_next	The number of requests to various MySQL handlers.	`kind`: `read_rnd_next`
mysql.handlers	mysql.performance.handler_read_rnd	The number of requests to various MySQL handlers.	`kind`: `read_rnd`
mysql.handlers	mysql.performance.handler_read_prev	The number of requests to various MySQL handlers.	`kind`: `read_prev`
mysql.handlers	mysql.performance.handler_read_first	The number of requests to various MySQL handlers.	`kind`: `read_first`
mysql.handlers	mysql.performance.handler_read_key	The number of requests to various MySQL handlers.	`kind`: `read_key`
mysql.handlers	mysql.performance.handler_prepare	The number of requests to various MySQL handlers.	`kind`: `prepare`
mysql.handlers	mysql.performance.handler_delete	The number of requests to various MySQL handlers.	`kind`: `delete`
mysql.handlers	mysql.performance.handler_commit	The number of requests to various MySQL handlers.	`kind`: `commit`
mysql.handlers	mysql.performance.handler_read_next	The number of requests to various MySQL handlers.	`kind`: `read_next`
mysql.joins	mysql.performance.select_scan	The number of joins that perform table scans.	`kind`: `scan`
mysql.joins	mysql.performance.select_range_check	The number of joins that perform table scans.	`kind`: `range_check`
mysql.joins	mysql.performance.select_full_range_join	The number of joins that perform table scans.	`kind`: `full_range`
mysql.joins	mysql.performance.select_range	The number of joins that perform table scans.	`kind`: `range`
mysql.joins	mysql.performance.select_full_join	The number of joins that perform table scans.	`kind`: `full`
mysql.locks	mysql.performance.table_locks_immediate	The number of MySQL locks.	`kind`: `immediate`
mysql.locks	mysql.performance.table_locks_waited	The number of MySQL locks.	`kind`: `waited`
mysql.log_operations	mysql.innodb.log_waits	The number of InnoDB log operations.	`operation`: `waits`
mysql.log_operations	mysql.innodb.log_write_requests	The number of InnoDB log operations.	`operation`: `write_requests`
mysql.log_operations	mysql.innodb.log_writes	The number of InnoDB log operations.	`operation`: `writes`
mysql.log_operations	mysql.innodb.os_log_fsyncs	The number of InnoDB log operations.	`operation`: `fsyncs`
mysql.max_used_connections	mysql.net.max_connections	Maximum number of connections used simultaneously since the server started.
mysql.operations	mysql.innodb.data_fsyncs	The number of InnoDB operations.	`operation`: `fsyncs`
mysql.operations	mysql.innodb.data_writes	The number of InnoDB operations.	`operation`: `writes`
mysql.operations	mysql.innodb.data_reads	The number of InnoDB operations.	`operation`: `reads`
mysql.page_operations	mysql.innodb.pages_created	The number of InnoDB page operations.	`operation`: `created`
mysql.page_operations	mysql.innodb.pages_read	The number of InnoDB page operations.	`operation`: `read`
mysql.page_operations	mysql.innodb.pages_written	The number of InnoDB page operations.	`operation`: `written`
mysql.query.slow.count	mysql.performance.slow_queries	The number of slow queries.
mysql.replica.time_behind_source	mysql.replication.seconds_behind_source	This field is an indication of how “late” the replica is.
mysql.row_locks	mysql.innodb.row_lock_current_waits	The number of InnoDB row locks.	`kind`: `waits`
mysql.row_locks	mysql.innodb.current_row_locks	The number of InnoDB row locks.
mysql.row_operations	mysql.innodb.rows_deleted	The number of InnoDB row operations.	`operation`: `deleted`
mysql.row_operations	mysql.innodb.rows_inserted	The number of InnoDB row operations.	`operation`: `inserted`
mysql.row_operations	mysql.innodb.rows_read	The number of InnoDB row operations.	`operation`: `read`
mysql.row_operations	mysql.innodb.rows_updated	The number of InnoDB row operations.	`operation`: `updated`
mysql.sorts	mysql.performance.sort_merge_passes	The number of MySQL sorts.	`kind`: `merge_passes`
mysql.sorts	mysql.performance.sort_range	The number of MySQL sorts.	`kind`: `range`
mysql.sorts	mysql.performance.sort_rows	The number of MySQL sorts.	`kind`: `rows`
mysql.sorts	mysql.performance.sort_scan	The number of MySQL sorts.	`kind`: `scan`
mysql.table_open_cache	mysql.performance.table_cache_hits	The number of hits, misses or overflows for open tables cache lookups.	`status`: `hit`
mysql.table_open_cache	mysql.performance.table_cache_misses	The number of hits, misses or overflows for open tables cache lookups.	`status`: `miss`
mysql.threads	mysql.performance.threads_cached	The state of MySQL threads.	`kind`: `cached`
mysql.threads	mysql.performance.threads_connected	The state of MySQL threads.	`kind`: `connected`
mysql.threads	mysql.performance.threads_created	The state of MySQL threads.	`kind`: `created`
mysql.threads	mysql.performance.threads_running	The state of MySQL threads.	`kind`: `running`
mysql.tmp_resources	mysql.performance.created_tmp_files	The number of created temporary resources.	`resource`: `files`
mysql.tmp_resources	mysql.performance.created_tmp_disk_tables	The number of created temporary resources.	`resource`: `disk_tables`
mysql.tmp_resources	mysql.performance.created_tmp_tables	The number of created temporary resources.	`resource`: `tables`