metadata.yaml

name: mysqlreceiver

resource_attributes:
  mysql.instance.endpoint:
    description: Endpoint of the MySQL instance.
    type: string

attributes:
  buffer_pool_pages:
    value: kind
    description: The buffer pool pages types.
    enum: [data, free, misc]
  buffer_pool_data:
    value: status
    description: The status of buffer pool data.
    enum: [dirty, clean]
  buffer_pool_operations:
    value: operation
    description: The buffer pool operations types.
    enum: [read_ahead_rnd, read_ahead, read_ahead_evicted, read_requests, reads, wait_free, write_requests]
  command:
    value: command
    description: The command types.
    enum: [execute, close, fetch, prepare, reset, send_long_data]
  handler:
    value: kind
    description: The handler types.
    enum: [commit, delete, discover, external_lock, mrr_init, prepare, read_first, read_key, read_last, read_next, read_prev, read_rnd, read_rnd_next, rollback, savepoint, savepoint_rollback, update, write]
  double_writes:
    value: kind
    description: The doublewrite types.
    enum: [pages_written, writes]
  log_operations:
    value: operation
    description: The log operation types.
    enum: [waits, write_requests, writes]
  operations:
    value: operation
    description: The operation types.
    enum: [fsyncs, reads, writes]
  page_operations:
    value: operation
    description: The page operation types.
    enum: [created, read, written]
  row_locks:
    value: kind
    description: The row lock type.
    enum: [waits, time]
  row_operations:
    value: operation
    description: The row operation type.
    enum: [deleted, inserted, read, updated]
  locks:
    value: kind
    description: The table locks type.
    enum: [immediate, waited]
  sorts:
    value: kind
    description: The sort count type.
    enum: [merge_passes, range, rows, scan]
  threads:
    value: kind
    description: The thread count type.
    enum: [cached, connected, created, running]
  schema:
    value: schema
    description: The schema of the object.
  io_waits_operations:
    value: operation
    description: The io_waits operation type.
    enum: [delete, fetch, insert, update]
  table_name:
    value: table
    description: Table name for event or process.
  index_name:
    value: index
    description: The name of the index.
  digest:
    value: digest
    description: Digest.
  digest_text:
    value: digest_text
    description: Text before digestion.
  event_state:
    value: kind
    description: Possible event states.
    enum: [errors, warnings, rows_affected, rows_sent, rows_examined, created_tmp_disk_tables, created_tmp_tables, sort_merge_passes, sort_rows, no_index_used]
  opened_resources:
    value: kind
    description: The kind of the resource.
    enum: [file, table_definition, table]
  tmp_resource:
    value: resource
    description: The kind of temporary resources.
    enum: [disk_tables, files, tables]
  mysqlx_threads:
    value: kind
    description: The worker thread count kind.
    enum: [available, active]

metrics:
  mysql.buffer_pool.pages:
    enabled: true
    description: The number of pages in the InnoDB buffer pool.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: false
      aggregation: cumulative
    attributes: [buffer_pool_pages]
  mysql.buffer_pool.data_pages:
    enabled: true
    description: The number of data pages in the InnoDB buffer pool.
    unit: 1
    sum:
      value_type: int
      monotonic: false
      aggregation: cumulative
    attributes: [buffer_pool_data]
  mysql.buffer_pool.page_flushes:
    enabled: true
    description: The number of requests to flush pages from the InnoDB buffer pool.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
  mysql.buffer_pool.operations:
    enabled: true
    description: The number of operations on the InnoDB buffer pool.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [buffer_pool_operations]
  mysql.buffer_pool.limit:
    enabled: true
    description: The configured size of the InnoDB buffer pool.
    unit: By
    sum:
      value_type: int
      input_type: string
      monotonic: false
      aggregation: cumulative
  mysql.buffer_pool.usage:
    enabled: true
    description: The number of bytes in the InnoDB buffer pool.
    unit: By
    sum:
      value_type: int
      monotonic: false
      aggregation: cumulative
    attributes: [buffer_pool_data]
  mysql.commands:
    enabled: true
    description: The number of times each type of command has been executed.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [command]
  mysql.handlers:
    enabled: true
    description: The number of requests to various MySQL handlers.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [handler]
  mysql.double_writes:
    enabled: true
    description: The number of writes to the InnoDB doublewrite buffer.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [double_writes]
  mysql.log_operations:
    enabled: true
    description: The number of InnoDB log operations.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [log_operations]
  mysql.operations:
    enabled: true
    description: The number of InnoDB operations.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [operations]
  mysql.page_operations:
    enabled: true
    description: The number of InnoDB page operations.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [page_operations]
  mysql.table.io.wait.count:
    enabled: true
    description: The total count of I/O wait events for a table.
    unit: 1
    sum:
      value_type: int
      monotonic: true
      aggregation: cumulative
    attributes: [io_waits_operations, table_name, schema]
  mysql.table.io.wait.time:
    enabled: true
    description: The total time of I/O wait events for a table.
    unit: ns
    sum:
      value_type: int
      monotonic: true
      aggregation: cumulative
    attributes: [io_waits_operations, table_name, schema]
  mysql.index.io.wait.count:
    enabled: true
    description: The total count of I/O wait events for an index.
    unit: 1
    sum:
      value_type: int
      monotonic: true
      aggregation: cumulative
    attributes: [io_waits_operations, table_name, schema, index_name]
  mysql.index.io.wait.time:
    enabled: true
    description: The total time of I/O wait events for an index.
    unit: ns
    sum:
      value_type: int
      monotonic: true
      aggregation: cumulative
    attributes: [io_waits_operations, table_name, schema, index_name]
  mysql.row_locks:
    enabled: true
    description: The number of InnoDB row locks.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [row_locks]
  mysql.row_operations:
    enabled: true
    description: The number of InnoDB row operations.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [row_operations]
  mysql.locks:
    enabled: true
    description: The number of MySQL locks.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [locks]
  mysql.sorts:
    enabled: true
    description: The number of MySQL sorts.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [sorts]
  mysql.threads:
    enabled: true
    description: The state of MySQL threads.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: false
      aggregation: cumulative
    attributes: [threads]
  mysql.opened_resources:
    enabled: true
    description: The number of opened resources.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [opened_resources]
  mysql.locked_connects:
    enabled: true
    description: The number of attempts to connect to locked user accounts.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
  mysql.tmp_resources:
    enabled: true
    description: The number of created temporary resources.
    unit: 1
    sum:
      value_type: int
      input_type: string
      monotonic: true
      aggregation: cumulative
    attributes: [tmp_resource]
  mysql.statement_event.count:
    enabled: false
    description: Summary of current and recent statement events.
    unit: 1
    sum:
      value_type: int
      monotonic: false
      aggregation: cumulative
    attributes: [schema, digest, digest_text, event_state]
  mysql.statement_event.wait.time:
    enabled: false
    description: The total wait time of the summarized timed events.
    unit: ns
    sum:
      value_type: int
      monotonic: false
      aggregation: cumulative
    attributes: [schema, digest, digest_text]
  mysql.mysqlx_worker_threads:
    enabled: true
    description: The number of worker threads available.
    unit: 1
    extended_documentation: This metric is specific for MySQL working as Document Store (X-Plugin). [more docs](https://dev.mysql.com/doc/refman/8.0/en/document-store.html)
    sum:
      value_type: int
      input_type: string
      monotonic: false
      aggregation: cumulative
    attributes: [mysqlx_threads]