MySQL Receiver

OpenTelemetry Collector receiver · contrib distribution

Component ID: contrib-mysqlreceiver
Name: mysqlreceiver
Type: receiver
Distribution: contrib
Repository: opentelemetry-collector-contrib

Stability

Level	Signals
beta	metrics
development	logs

Metrics

Metric	Type	Value type	Unit	Stability	Enabled	Attributes	Description
`mysql.buffer_pool.data_pages`	sum	int	1	development	yes	`buffer_pool_data` (string)	The number of data pages in the InnoDB buffer pool.
`mysql.buffer_pool.limit`	sum	int	By	development	yes		The configured size of the InnoDB buffer pool.
`mysql.buffer_pool.operations`	sum (monotonic)	int	1	development	yes	`buffer_pool_operations` (string)	The number of operations on the InnoDB buffer pool.
`mysql.buffer_pool.page_flushes`	sum (monotonic)	int	1	development	yes		The number of requests to flush pages from the InnoDB buffer pool.
`mysql.buffer_pool.pages`	sum	int	1	development	yes	`buffer_pool_pages` (string)	The number of pages in the InnoDB buffer pool.
`mysql.buffer_pool.usage`	sum	int	By	development	yes	`buffer_pool_data` (string)	The number of bytes in the InnoDB buffer pool.
`mysql.client.network.io`	sum (monotonic)	int	By	development	no	`direction` (string)	The number of transmitted bytes between server and clients.
`mysql.commands`	sum (monotonic)	int	1	development	no	`command` (string)	The number of times each type of command has been executed.
`mysql.connection.count`	sum (monotonic)	int	1	development	no		The number of connection attempts (successful or not) to the MySQL server.
`mysql.connection.errors`	sum (monotonic)	int	1	development	no	`connection_error` (string)	Errors that occur during the client connection process.
`mysql.double_writes`	sum (monotonic)	int	1	development	yes	`double_writes` (string)	The number of writes to the InnoDB doublewrite buffer.
`mysql.file.open`	gauge	int	1	development	no		The number of currently open files.
`mysql.handlers`	sum (monotonic)	int	1	development	yes	`handler` (string)	The number of requests to various MySQL handlers.
`mysql.index.io.wait.count`	sum (monotonic)	int	1	development	yes	`index_name` (string), `io_waits_operations` (string), `schema` (string), `table_name` (string)	The total count of I/O wait events for an index.
`mysql.index.io.wait.time`	sum (monotonic)	int	ns	development	yes	`index_name` (string), `io_waits_operations` (string), `schema` (string), `table_name` (string)	The total time of I/O wait events for an index.
`mysql.innodb.data_file.io`	sum (monotonic)	int	By	development	no	`disk.io.direction` (string)	The total bytes read from and written to InnoDB data files.
`mysql.innodb.operation.pending`	sum	int	1	development	no	`operations` (string)	The number of pending InnoDB data file operations.
`mysql.innodb.row_lock.wait.count`	gauge	int	{wait}	development	no		The number of InnoDB row lock waits currently pending.
`mysql.innodb.row_lock.wait.duration.avg`	gauge	double	s	development	no		The average InnoDB row lock wait duration since server startup or last status reset.
`mysql.innodb.row_lock.wait.duration.max`	gauge	double	s	development	no		The maximum InnoDB row lock wait duration since server startup or last status reset.
`mysql.joins`	sum (monotonic)	int	1	development	no	`join_kind` (string)	The number of joins that perform table scans.
`mysql.locks`	sum (monotonic)	int	1	development	yes	`locks` (string)	The number of MySQL locks.
`mysql.log_operations`	sum (monotonic)	int	1	development	yes	`log_operations` (string)	The number of InnoDB log operations.
`mysql.max_used_connections`	sum	int	1	development	no		Maximum number of connections used simultaneously since the server started.
`mysql.myisam.key_cache.block.unused`	gauge	int	{block}	development	no		The number of unused MyISAM key cache blocks.
`mysql.myisam.key_cache.block.used.max`	gauge	int	{block}	development	no		The maximum number of MyISAM key cache blocks simultaneously in use since the server started or status counters were reset.
`mysql.myisam.key_cache.disk.operation`	sum (monotonic)	int	{operation}	development	no	`mysql.myisam.key_cache.operation.type` (string)	The number of physical MyISAM key cache disk operations.
`mysql.myisam.key_cache.request`	sum (monotonic)	int	{request}	development	no	`mysql.myisam.key_cache.operation.type` (string)	The number of logical MyISAM key cache requests.
`mysql.mysqlx_connections`	sum (monotonic)	int	1	development	yes	`connection_status` (string)	The number of mysqlx connections. This metric is specific for MySQL working as Document Store (X-Plugin). more docs
`mysql.mysqlx_worker_threads`	sum	int	1	development	no	`mysqlx_threads` (string)	The number of worker threads available. This metric is specific for MySQL working as Document Store (X-Plugin). more docs
`mysql.opened_resources`	sum (monotonic)	int	1	development	yes	`opened_resources` (string)	The number of opened resources.
`mysql.operations`	sum (monotonic)	int	1	development	yes	`operations` (string)	The number of InnoDB operations.
`mysql.page_operations`	sum (monotonic)	int	1	development	yes	`page_operations` (string)	The number of InnoDB page operations.
`mysql.page_size`	sum	int	By	development	no		InnoDB page size.
`mysql.prepared_statements`	sum (monotonic)	int	1	development	yes	`prepared_statements_command` (string)	The number of times each type of prepared statement command has been issued.
`mysql.query.client.count`	sum (monotonic)	int	1	development	no		The number of statements executed by the server. This includes only statements sent to the server by clients.
`mysql.query.count`	sum (monotonic)	int	1	development	no		The number of statements executed by the server.
`mysql.query.slow.count`	sum (monotonic)	int	1	development	no		The number of slow queries.
`mysql.replica.sql_delay`	sum	int	s	development	no		The number of seconds that the replica must lag the source.
`mysql.replica.temp_table.open`	gauge	int	{table}	development	no		The number of temporary tables currently open by the replica while applying replicated events.
`mysql.replica.thread.running`	gauge	int	1	development	no	`mysql.replica.channel.name` (string), `mysql.replica.thread.type` (string)	Whether the replica IO and SQL threads report a running status. A value of 1 means the thread reports Yes; 0 means any other status, including No or Connecting. If the thread type or channel name attributes are disabled or dropped, configure the aggregation strategy as min or max based on the desired collapsed status.
`mysql.replica.time_behind_source`	sum	int	s	development	no		This field is an indication of how “late” the replica is.
`mysql.row_locks`	sum (monotonic)	int	1	development	yes	`row_locks` (string)	The number of InnoDB row locks.
`mysql.row_operations`	sum (monotonic)	int	1	development	yes	`row_operations` (string)	The number of InnoDB row operations.
`mysql.sorts`	sum (monotonic)	int	1	development	yes	`sorts` (string)	The number of MySQL sorts.
`mysql.statement_event.count`	sum	int	1	development	no	`digest` (string), `digest_text` (string), `event_state` (string), `schema` (string)	Summary of current and recent statement events.
`mysql.statement_event.wait.time`	sum	int	ns	development	no	`digest` (string), `digest_text` (string), `schema` (string)	The total wait time of the summarized timed events.
`mysql.table.average_row_length`	sum	int	By	development	no	`schema` (string), `table_name` (string)	The average row length in bytes for a given table.
`mysql.table.io.wait.count`	sum (monotonic)	int	1	development	yes	`io_waits_operations` (string), `schema` (string), `table_name` (string)	The total count of I/O wait events for a table.
`mysql.table.io.wait.time`	sum (monotonic)	int	ns	development	yes	`io_waits_operations` (string), `schema` (string), `table_name` (string)	The total time of I/O wait events for a table.
`mysql.table.lock_wait.read.count`	sum	int	1	development	no	`read_lock_type` (string), `schema` (string), `table_name` (string)	The total table lock wait read events.
`mysql.table.lock_wait.read.time`	sum	int	ns	development	no	`read_lock_type` (string), `schema` (string), `table_name` (string)	The total table lock wait read events times.
`mysql.table.lock_wait.write.count`	sum	int	1	development	no	`schema` (string), `table_name` (string), `write_lock_type` (string)	The total table lock wait write events.
`mysql.table.lock_wait.write.time`	sum	int	ns	development	no	`schema` (string), `table_name` (string), `write_lock_type` (string)	The total table lock wait write events times.
`mysql.table.open`	gauge	int	1	development	no		The number of currently open tables.
`mysql.table.rows`	sum	int	1	development	no	`schema` (string), `table_name` (string)	The number of rows for a given table.
`mysql.table.size`	sum	int	By	development	no	`schema` (string), `table_name` (string), `table_size_type` (string)	The table size in bytes for a given table.
`mysql.table_open_cache`	sum (monotonic)	int	1	development	no	`cache_status` (string)	The number of hits, misses or overflows for open tables cache lookups.
`mysql.thread.slow_launch`	sum (monotonic)	int	1	development	no		The number of threads that have taken more than slow_launch_time seconds to create.
`mysql.threads`	sum	int	1	development	yes	`threads` (string)	The state of MySQL threads.
`mysql.tmp_resources`	sum (monotonic)	int	1	development	yes	`tmp_resource` (string)	The number of created temporary resources.
`mysql.uptime`	sum (monotonic)	int	s	development	yes		The number of seconds that the server has been up.

Attributes

Attribute	Type	Description
`buffer_pool_data`	string	The status of buffer pool data.
`buffer_pool_operations`	string	The buffer pool operations types.
`buffer_pool_pages`	string	The buffer pool pages types.
`cache_status`	string	The status of cache access.
`client.address`	string	Hostname or address of the client.
`client.port`	int	TCP port used by the client.
`command`	string	The command types.
`connection_error`	string	The connection error type.
`connection_status`	string	The connection status.
`db.namespace`	string	The default database for the thread, or empty if none has been selected (originally processlist_db).
`db.query.text`	string	The SQL statement text for the event.
`db.system.name`	string	The name of the database system.
`digest`	string	Digest.
`digest_text`	string	Text before digestion.
`direction`	string	The name of the transmission direction.
`disk.io.direction`	string	The disk IO operation direction.
`double_writes`	string	The doublewrite types.
`event_state`	string	Possible event states.
`handler`	string	The handler types.
`index_name`	string	The name of the index.
`io_waits_operations`	string	The io_waits operation type.
`join_kind`	string	The kind of join.
`locks`	string	The table locks type.
`log_operations`	string	The log operation types. 'fsyncs' aren't available in MariaDB 10.8 or later.
`mysql.event_id`	int	The thread associated with the event and the thread current event number when the event starts.
`mysql.events_statements_current.digest`	string	The statement digest SHA-256 value as a string of 64 hexadecimal characters, or empty if the statements_digest consumer is no.
`mysql.events_statements_current.timer_wait`	double	Elapsed time the current statement has been executing, in seconds.
`mysql.events_statements_summary_by_digest.count_star`	int	The number of times the statement was executed, report in delta value.
`mysql.events_statements_summary_by_digest.digest`	string	The statement digest SHA-256 value as a string of 64 hexadecimal characters, or empty if the statements_digest consumer is no.
`mysql.events_statements_summary_by_digest.sum_timer_wait`	double	The total time spent executing the statement, report in delta seconds.
`mysql.events_waits_current.timer_wait`	double	Timing information for the event, indicating elapsed time the event waited in seconds.
`mysql.myisam.key_cache.operation.type`	string	The MyISAM key cache operation type.
`mysql.query_plan`	string	The query plan for the statement, if available.
`mysql.query_plan.hash`	string	This attribute is set to the same value as mysql.events_statements_summary_by_digest.digest (query digest) by design.
`mysql.replica.channel.name`	string	The replication channel name.
`mysql.replica.thread.type`	string	The replica thread type.
`mysql.session.id`	int	The unique identifier for the session associated with the event.
`mysql.session.status`	string	Simplified session status, either 'waiting', 'running' or 'other'.
`mysql.threads.processlist_command`	string	The type of command the thread is executing on behalf of the client for foreground threads, or `Sleep` if the session is idle.
`mysql.threads.processlist_state`	string	An action, event, or state that indicates what the thread is doing.
`mysql.threads.thread_id`	int	The unique identifier for the thread executing the statement.
`mysql.wait_type`	string	The name of the instrument that produced the event.
`mysqlx_threads`	string	The worker thread count kind.
`network.peer.address`	string	IP address of the peer client.
`network.peer.port`	int	TCP port used by the peer client.
`opened_resources`	string	The kind of the resource.
`operations`	string	The operation types.
`page_operations`	string	The page operation types.
`prepared_statements_command`	string	The prepare statement command types.
`read_lock_type`	string	Read operation types.
`row_locks`	string	The row lock type.
`row_operations`	string	The row operation type.
`schema`	string	The schema of the object.
`sorts`	string	The sort count type.
`table_name`	string	Table name for event or process.
`table_size_type`	string	The table size types.
`threads`	string	The thread count type.
`tmp_resource`	string	The kind of temporary resources.
`user.name`	string	The user associated with a foreground thread, empty for a background thread (originally processlist_user).
`write_lock_type`	string	Write operation types.

Data

JSON (latest): /data/collector/components/contrib-mysqlreceiver/latest.json
JSON (pinned): /data/collector/components/contrib-mysqlreceiver/contrib-mysqlreceiver-228c2070e2e9.json
Explore: /collector/components/contrib/mysqlreceiver