Related Documentation Download this Manual
PDF (US Ltr) - 40.3Mb
PDF (A4) - 40.4Mb
Man Pages (TGZ) - 266.0Kb
Man Pages (Zip) - 370.5Kb
Info (Gzip) - 4.0Mb
Info (Zip) - 4.0Mb
Excerpts from this Manual

MySQL 8.2 Reference Manual  /  ...  /  Server Metrics

33.2.2 Server Metrics

The following server metrics are registered by default:

The maximum number of metric instruments which can be created is set by performance_schema_max_metric_classes.

mysql.stats Metrics

Table 33.3 mysql.stats Metrics

Name Source Variable OTEL Type Description

aborted_clients

Aborted_clients

ASYNC COUNTER

The number of connections that were aborted because the client died without closing the connection properly

aborted_connects

Aborted_connects

ASYNC COUNTER

The number of failed attempts to connect to the MySQL server

acl_cache_items_count

Acl_cache_items_count

ASYNC GAUGE COUNTER

The number of cached privilege objects

binlog_cache.disk_use

Binlog_cache_disk_use

ASYNC COUNTER

The number of transactions that used the temporary binary log cache but that exceeded the value of binlog_cache_size and used a temporary file to store statements from the transaction

binlog_cache.use

Binlog_cache_use

ASYNC COUNTER

The number of transactions that used the binary log cache.

binlog_stmt_cache_disk_use

Binlog_stmt_cache_disk_use

ASYNC COUNTER

The number of nontransaction statements that used the binary log statement cache but that exceeded the value of binlog_stmt_cache_size and used a temporary file to store those statements.

binlog_stmt_cache_use

Binlog_stmt_cache_use

ASYNC COUNTER

The number of nontransactional statements that used the binary log statement cache

bytes_received

Bytes_received

ASYNC COUNTER

The number of bytes received from all clients

bytes_sent

Bytes_sent

ASYNC COUNTER

The number of bytes sent to all clients

created.tmp_disk_tables

Created_tmp_disk_tables

ASYNC COUNTER

The number of internal on-disk temporary tables created by the server while executing statements

created.tmp_files

Created_tmp_files

ASYNC COUNTER

How many temporary files mysqld has created

created.tmp_tables

Created_tmp_tables

ASYNC COUNTER

The number of internal temporary tables created by the server while executing statements

error_log.buffered_bytes

Error_log_buffered_bytes

ASYNC GAUGE COUNTER

The number of bytes currently used in the Performance Schema error_log table

error_log.buffered_events

Error_log_buffered_events

ASYNC GAUGE COUNTER

The number of events currently present in the Performance Schema error_log table

error_log.expired_events

Error_log_expired_events

ASYNC COUNTER

The number of events discarded from the Performance Schema error_log table to make room for new events

flush_commands

Flush_commands

ASYNC COUNTER

The number of times the server flushes tables

global_connection_memory

Global_connection_memory

ASYNC GAUGE COUNTER

The memory used by all user connections to the server

locked_connects

Locked_connects

ASYNC COUNTER

The number of attempts to connect to locked user accounts

max_execution_time_exceeded

Max_execution_time_exceeded

ASYNC COUNTER

The number of SELECT statements for which the execution timeout was exceeded

max_execution_time_set

Max_execution_time_set

ASYNC COUNTER

The number of SELECT statements for which a nonzero execution timeout was set

max_execution_time_set_failed

Max_execution_time_set_failed

ASYNC COUNTER

The number of SELECT statements for which the attempt to set an execution timeout failed

max_used_connections

Max_used_connections

ASYNC GAUGE COUNTER

The maximum number of connections that have been in use simultaneously since the server started

ongoing_anonymous_transaction_count

Ongoing_anonymous_transaction_count

ASYNC GAUGE COUNTER

Shows the number of ongoing transactions which have been marked as anonymous

open_files

Open_files

ASYNC COUNTER

The number of files that are open. This count includes regular files opened by the server.

open_streams

Open_streams

ASYNC COUNTER

The number of streams that are open, used mainly for logging

open_table_definitions

Open_table_definitions

ASYNC GAUGE COUNTER

The number of cached table definitions

open_tables

Open_tables

ASYNC GAUGE COUNTER

The number of tables that are open.

opened_files

Opened_files

ASYNC COUNTER

The number of files that have been opened with my_open().

opened_table_definitions

Opened_table_definitions

ASYNC GAUGE COUNTER

The number of table definitions that have been cached.

opened_tables

Opened_tables

ASYNC COUNTER

The number of tables that have been opened

prepared_stmt_count

Prepared_stmt_count

ASYNC GAUGE COUNTER

The current number of prepared statements

queries

Queries

ASYNC COUNTER

The number of statements executed by the server, including ones executed within stored programs. It does not count COM_PING or COM_STATISTICS commands.

questions

Questions

ASYNC COUNTER

The number of statements executed by the server. This includes only statements sent to the server by clients and not statements executed within stored programs.

replica_open_temp_tables

Replica_open_temp_tables

ASYNC GAUGE COUNTER

Number of temporary tables that the replication SQL thread currently has open.

secondary_engine_execution_count

Secondary_engine_execution_count

ASYNC COUNTER

The number of queries offloaded to a secondary engine

select_full_join

Select_full_join

ASYNC COUNTER

The number of joins that perform table scans because they do not use indexes

select_full_range_join

Select_full_range_join

ASYNC COUNTER

The number of joins that used a range search on a reference table

select_range

Select_range

ASYNC COUNTER

The number of joins that used ranges on the first table

select_range_check

Select_range_check

ASYNC COUNTER

The number of joins without keys that check for key usage after each row

select_scan

Select_scan

ASYNC COUNTER

The number of joins that did a full scan of the first table

slow_launch_threads

Slow_launch_threads

ASYNC COUNTER

The number of threads that have taken more than slow_launch_time seconds to create.

slow_queries

Slow_queries

ASYNC COUNTER

The number of queries that have taken more than long_query_time seconds

sort_merge_passes

Sort_merge_passes

ASYNC COUNTER

The number of merge passes that the sort algorithm has had to do

sort_range

Sort_range

ASYNC COUNTER

The number of sorts that were done using ranges

sort_rows

Sort_rows

ASYNC COUNTER

The number of sorted rows.

sort_scan

Sort_scan

ASYNC COUNTER

The number of sorts that were done by scanning the table.

table_locks_immediate

Table_locks_immediate

ASYNC COUNTER

The number of times that a request for a table lock could be granted immediately

table_locks_waited

Table_locks_waited

ASYNC COUNTER

The number of times that a request for a table lock could not be granted immediately and a wait was needed.

table_open_cache_hits

Table_open_cache_hits

ASYNC COUNTER

The number of hits for open tables cache lookups.

table_open_cache_misses

Table_open_cache_misses

ASYNC COUNTER

The number of misses for open tables cache lookups.

table_open_cache_overflows

Table_open_cache_overflows

ASYNC COUNTER

The number of overflows for the open tables cache.

tc_log_page_waits

Tc_log_page_waits

ASYNC COUNTER

For the memory-mapped implementation of the recovery log, this variable increments each time the server was not able to commit a transaction and had to wait for a free page in the log.

threads_cached

Threads_cached

ASYNC GAUGE COUNTER

The number of threads in the thread cache.

threads_connected

Threads_connected

ASYNC GAUGE COUNTER

The number of currently open connections

threads_created

Threads_created

ASYNC GAUGE COUNTER

The number of threads created to handle connections.

threads_running

Threads_running

ASYNC GAUGE COUNTER

The number of threads that are not sleeping.

uptime

Uptime

ASYNC COUNTER

The number of seconds that the server has been up.


mysql.stats.com Metrics

The mysql.stats.com metrics correspond to the Com_xxx statement counter variables. See Section 5.1.10, “Server Status Variables” and Com_xxxfor more information.

The mysql.stats.com metrics are named for those variables, without the Com_ prefix. For example, the select metric corresponds to the Com_select statement counter variable.

These metrics are of OTEL Type ASYNC COUNTER and record the number of times (INTEGER) the corresponding command statement has been executed.

mysql.stats.connection Metrics

The mysql.stats.connection metrics correspond to the Connections and Connection_XXX status variables.

Table 33.4 mysql.stats.connection Metrics

Name Source Variable OTEL Type Description

total

Connections

ASYNC COUNTER

Cumulative count of total connections created.

errors_accept

Connection_errors_accept

ASYNC COUNTER

The number of errors that occurred during calls to accept() on the listening port.

errors_internal

Connection_errors_internal

ASYNC COUNTER

The number of connections refused due to internal errors in the server, such as failure to start a new thread or an out-of-memory condition.

errors_max_connections

Connection_errors_max_connections

ASYNC COUNTER

The number of connections refused because the server max_connections limit was reached.

errors_peer_address

Connection_errors_peer_address

ASYNC COUNTER

The number of errors that occurred while searching for connecting client IP addresses.

errors_select

Connection_errors_select

ASYNC COUNTER

The number of errors that occurred during calls to select() or poll() on the listening port.

errors_tcpwrap

Connection_

ASYNC COUNTER

The number of connections refused by the libwrap library.


mysql.perf_schema Metrics

The mysql.perf_schema correspond to the Performance_schema_XXX status variables. See Section 27.7, “Performance Schema Status Monitoring”.

Table 33.5 mysql.perf_schema Metrics

Name Source Variable OTEL Type Description

accounts_lost

Performance_schema_accounts_lost

ASYNC COUNTER

The number of times a row could not be added to the accounts table because it was full.

cond_classes_lost

Performance_schema_cond_classes_lost

ASYNC COUNTER

How many condition instruments could not be loaded.

cond_instances_lost

Performance_schema_cond_instances_lost

ASYNC COUNTER

How many condition instrument instances could not be created.

digest_lost

Performance_schema_digest_lost

ASYNC COUNTER

The number of digest instances that could not be instrumented in the events_statements_summary_by_digest table.

file_classes_lost

Performance_schema_file_classes_lost

ASYNC COUNTER

How many file instruments could not be loaded.

file_handles_lost

Performance_schema_file_handles_lost

ASYNC COUNTER

How many file instrument instances could not be opened.

file_instances_lost

Performance_schema_file_instances_lost

ASYNC COUNTER

How many file instrument instances could not be created.

hosts_lost

Performance_schema_hosts_lost

ASYNC COUNTER

The number of times a row could not be added to the hosts table because it was full.

index_stat_lost

Performance_schema_index_stat_lost

ASYNC COUNTER

The number of indexes for which statistics were lost.

locker_lost

Performance_schema_locker_lost

ASYNC COUNTER

How many events are lost or not recorded.

memory_classes_lost

Performance_schema_memory_classes_lost

ASYNC COUNTER

The number of times a memory instrument could not be loaded.

metadata_lock_lost

Performance_schema_metadata_lock_lost

ASYNC COUNTER

The number of metadata locks that could not be instrumented in the metadata_locks table.

meter_lost

Performance_schema_meter_lost

ASYNC COUNTER

How many meter instruments could not be loaded.

metric_lost

Performance_schema_metric_lost

ASYNC COUNTER

How many metric instruments could not be loaded.

mutex_classes_lost

Performance_schema_mutex_classes_lost

ASYNC COUNTER

How many mutex instruments could not be loaded.

mutex_instances_lost

Performance_schema_mutex_instances_lost

ASYNC COUNTER

How many mutex instrument instances could not be created.

nested_statement_lost

Performance_schema_nested_statement_lost

ASYNC COUNTER

The number of stored program statements for which statistics were lost.

prepared_statements_lost

Performance_schema_prepared_statements_lost

ASYNC COUNTER

The number of prepared statements that could not be instrumented in the prepared_statements_instances table.

program_lost

Performance_schema_program_lost

ASYNC COUNTER

The number of stored programs for which statistics were lost.

rwlock_classes_lost

Performance_schema_rwlock_classes_lost

ASYNC COUNTER

How many rwlock instruments could not be loaded.

rwlock_instances_lost

Performance_schema_rwlock_instances_lost

ASYNC COUNTER

How many rwlock instrument instances could not be created.

session_connect_attrs_longest_seen

Performance_schema_session_connect_attrs_longest_seen

ASYNC COUNTER

Longest seen connection attribute received.

session_connect_attrs_lost

Performance_schema_session_connect_attrs_lost

ASYNC COUNTER

The number of connections for which connection attribute truncation has occurred

socket_classes_lost

Performance_schema_socket_classes_lost

ASYNC COUNTER

How many socket instruments could not be loaded.

socket_instances_lost

Performance_schema_socket_instances_lost

ASYNC COUNTER

How many socket instrument instances could not be created.

stage_classes_lost

Performance_schema_stage_classes_lost

ASYNC COUNTER

How many stage instruments could not be loaded.

statement_classes_lost

Performance_schema_statement_classes_lost

ASYNC COUNTER

How many statement instruments could not be loaded.

table_handles_lost

Performance_schema_table_handles_lost

ASYNC COUNTER

How many table instrument instances could not be opened.

table_instances_lost

Performance_schema_table_instances_lost

ASYNC COUNTER

How many table instrument instances could not be created.

table_lock_stat_lost

Performance_schema_table_lock_stat_lost

ASYNC COUNTER

The number of tables for which lock statistics were lost.

thread_classes_lost

Performance_schema_thread_classes_lost

ASYNC COUNTER

How many thread instruments could not be loaded.

thread_instances_lost

Performance_schema_thread_instances_lost

ASYNC COUNTER

The number of thread instances that could not be instrumented in the threads table.

users_lost

Performance_schema_users_lost

ASYNC COUNTER

The number of times a row could not be added to the users table because it was full.


mysql.stats.handler Metrics

The mysql.stats.handler metrics correspond to the Handler_XXX status variables.

Table 33.6 mysql.perf_schema Metrics

Name Source Variable OTEL Type Description

commit

Handler_commit

ASYNC COUNTER

The number of internal COMMIT statements.

delete

Handler_delete

ASYNC COUNTER

The number of times that rows have been deleted from tables

discover

Handler_discover

ASYNC COUNTER

The number of times that tables have been discovered.

external_lock

Handler_external_lock

ASYNC COUNTER

The server increments this variable for each call to its external_lock() function, which generally occurs at the beginning and end of access to a table instance.

mrr_init

Handler_mrr_init

ASYNC COUNTER

The number of times the server uses a storage engine's own Multi-Range Read implementation for table access.

prepare

Handler_prepare

ASYNC COUNTER

A counter for the prepare phase of two-phase commit operations.

read_first

Handler_read_first

ASYNC COUNTER

The number of times the first entry in an index was read.

read_key

Handler_read_key

ASYNC COUNTER

The number of requests to read a row based on a key.

read_last

Handler_read_last

ASYNC COUNTER

The number of requests to read the last key in an index.

read_next

Handler_read_next

ASYNC COUNTER

The number of requests to read the next row in key order.

read_prev

Handler_read_prev

ASYNC COUNTER

The number of requests to read the previous row in key order.

read_rnd

Handler_read_rnd

ASYNC COUNTER

The number of requests to read a row based on a fixed position.

read_rnd_next

Handler_read_rnd_next

ASYNC COUNTER

The number of requests to read the next row in the data file.

rollback

Handler_rollback

ASYNC COUNTER

The number of requests for a storage engine to perform a rollback operation.

savepoint

Handler_savepoint

ASYNC COUNTER

The number of requests for a storage engine to place a savepoint.

savepoint_rollback

Handler_savepoint_rollback

ASYNC COUNTER

The number of requests for a storage engine to roll back to a savepoint.

update

Handler_update

ASYNC COUNTER

The number of requests to update a row in a table.

write

Handler_write

ASYNC COUNTER

The number of requests to insert a row in a table.


mysql.stats.myisam Metrics

Table 33.7 mysql.perf_schema Metrics

Name Source Variable OTEL Type Description

key_blocks_not_flushed

Key_blocks_not_flushed

ASYNC COUNTER

The number of key blocks in the MyISAM key cache that have changed but have not yet been flushed to disk.

key_blocks_unused

Key_blocks_unused

ASYNC COUNTER

The number of unused blocks in the MyISAM key cache.

key_blocks_used

Key_blocks_used

ASYNC COUNTER

The number of used blocks in the MyISAM key cache.

key_read_requests

Key_read_requests

ASYNC COUNTER

The number of requests to read a key block from the MyISAM key cache.

key_reads

Key_reads

ASYNC COUNTER

The number of physical reads of a key block from disk into the MyISAM key cache.

key_write_requests

Key_write_requests

ASYNC COUNTER

The number of requests to write a key block to the MyISAM key cache.

key_writes

Key_writes

ASYNC COUNTER

The number of physical writes of a key block from the MyISAM key cache to disk.


mysql.stats.ssl Metrics

Table 33.8 mysql.stats.ssl Metrics

Name Source Variable OTEL Type Description

client_connects

Ssl_client_connects

ASYNC COUNTER

The number of SSL connection attempts to an SSL-enabled replication source server.

connect_renegotiates

Ssl_connect_renegotiates

ASYNC COUNTER

The number of negotiates needed to establish the connection to an SSL-enabled replication source server.

finished_accepts

Ssl_finished_accepts

ASYNC COUNTER

The number of successful SSL connections to the server.

finished_connects

Ssl_finished_connects

ASYNC COUNTER

The number of successful replica connections to an SSL-enabled replication source server.

session_cache_hits

Ssl_session_cache_hits

ASYNC COUNTER

The number of SSL session cache hits.

session_cache_misses

Ssl_session_cache_misses

ASYNC COUNTER

The number of SSL session cache misses.

session_cache_overflows

Ssl_session_cache_overflows

ASYNC COUNTER

The number of SSL session cache overflows.

session_cache_size

Ssl_session_cache_size

ASYNC COUNTER

The SSL session cache size.

session_cache_timeouts

Ssl_session_cache_timeouts

ASYNC COUNTER

The number of SSL session cache timeouts.

used_session_cache_entries

Ssl_used_session_cache_entries

ASYNC COUNTER

How many SSL session cache entries were used.

accept_renegotiates

Ssl_accept_renegotiates

ASYNC COUNTER

The number of negotiates needed to establish the connection.

accepts

Ssl_accepts

ASYNC COUNTER

The number of accepted SSL connections.

callback_cache_hits

Ssl_callback_cache_hits

ASYNC COUNTER

The number of callback cache hits.


mysql.inno Metrics

Table 33.9 mysql.inno Metrics

Name Source Variable OTEL Type Description

dblwr_pages_written

innodb_dblwr_pages_written

ASYNC COUNTER

Number of pages that have been written for doublewrite operations

dblwr_writes

innodb_dblwr_writes

ASYNC COUNTER

Number of doublewrite operations that have been performed

redo_log_logical_size

innodb_redo_log_logical_size

ASYNC GAUGE COUNTER

LSN range size in bytes containing in-use redo log data.

redo_log_physical_size

innodb_redo_log_physical_size

ASYNC GAUGE COUNTER

Disk space in bytes currently consumed by all redo log files on disk, excluding spare redo log files

redo_log_capacity_resized

innodb_redo_log_capacity_resized

ASYNC GAUGE COUNTER

Redo log capacity in bytes for all redo log files, after the last completed capacity resize operation

log_waits

innodb_log_waits

ASYNC COUNTER

Number of log waits due to small log buffer

log_write_requests

innodb_log_write_requests

ASYNC COUNTER

Number of log write requests

log_writes

innodb_log_writes

ASYNC COUNTER

The number of physical writes to the InnoDB redo log file

os_log_fsyncs

innodb_os_log_fsyncs

ASYNC COUNTER

Number of fsync log writes.

os_log_pending_fsyncs

innodb_os_log_pending_fsyncs

ASYNC GAUGE COUNTER

Number of pending fsync writes.

os_log_pending_writes

innodb_os_log_pending_writes

ASYNC GAUGE COUNTER

Number of pending log file writes.

os_log_written

innodb_os_log_written

ASYNC COUNTER

Bytes of log written.

page_size

innodb_page_size

ASYNC GAUGE COUNTER

InnoDB page size in bytes.

pages_created

innodb_pages_created

ASYNC COUNTER

Number of pages created

pages_read

innodb_pages_read

ASYNC COUNTER

Number of pages read.

pages_written

innodb_pages_written

ASYNC COUNTER

Number of pages written.

row_lock_current_waits

innodb_row_lock_current_waits

ASYNC GAUGE COUNTER

Number of row locks currently being waited for.

row_lock_time

innodb_row_lock_time

ASYNC COUNTER

Time spent in acquiring row locks, in milliseconds

row_lock_time_avg

innodb_row_lock_time_avg

ASYNC GAUGE COUNTER

The average time to acquire a row lock, in milliseconds

row_lock_time_max

innodb_row_lock_time_max

ASYNC GAUGE COUNTER

The maximum time to acquire a row lock, in milliseconds.

row_lock_waits

innodb_row_lock_waits

ASYNC COUNTER

Number of times a row lock had to be waited for.

rows_deleted

innodb_rows_deleted

ASYNC COUNTER

The number of rows inserted into InnoDB tables.

rows_read

innodb_rows_read

ASYNC COUNTER

The number of rows read from InnoDB tables

rows_updated

innodb_rows_updated

ASYNC COUNTER

The number of rows updated in InnoDB tables.

system_rows_deleted

innodb_system_rows_deleted

ASYNC COUNTER

Number of rows deleted from InnoDB tables belonging to system-created schemas.

system_rows_inserted

innodb_system_rows_inserted

ASYNC COUNTER

Number of rows inserted into InnoDB tables belonging to system-created schemas

system_rows_read

innodb_system_rows_read

ASYNC COUNTER

Number of rows read from InnoDB tables belonging to system-created schemas.

system_rows_updated

innodb_system_rows_updated

ASYNC COUNTER

Number of rows updated in InnoDB tables belonging to system-created schemas.

num_open_files

innodb_num_open_files

ASYNC GAUGE COUNTER

Number of files currently open.

truncated_status_writes

innodb_truncated_status_writes

ASYNC COUNTER

Number of times output from the SHOW ENGINE INNODB STATUS statement has been truncated.

undo_tablespaces_total

innodb_undo_tablespaces_total

ASYNC GAUGE COUNTER

Total number of undo tablespaces.

undo_tablespaces_explicit

innodb_undo_tablespaces_explicit

ASYNC GAUGE COUNTER

Number of user-created undo tablespaces.

undo_tablespaces_active

innodb_undo_tablespaces_active

ASYNC GAUGE COUNTER

Number of active undo tablespaces, including implicit and explicit tablespaces


mysql.inno.buffer_pool Metrics

Table 33.10 mysql.inno.buffer_pool Metrics

Name Source Variable OTEL Type Description

pages_data

innodb_buffer_pool_pages_data

ASYNC GAUGE COUNTER

Buffer pages containing data.

bytes_data

innodb_buffer_pool_bytes_data

ASYNC GAUGE COUNTER

Buffer bytes containing data.

pages_dirty

innodb_buffer_pool_pages_dirty

ASYNC GAUGE COUNTER

Buffer pages currently dirty.

bytes_dirty

innodb_buffer_pool_bytes_dirty

ASYNC GAUGE COUNTER

Buffer bytes currently dirty

pages_flushed

innodb_buffer_pool_pages_flushed

ASYNC COUNTER

The number of requests to flush pages from the InnoDB buffer pool.

pages_free

innodb_buffer_pool_pages_free

ASYNC GAUGE COUNTER

Buffer pages currently free.

pages_misc

innodb_buffer_pool_pages_misc

ASYNC GAUGE COUNTER

Buffer pages for misc use such as row locks or the adaptive hash index.

pages_total

innodb_buffer_pool_pages_total

ASYNC GAUGE COUNTER

Total buffer pool size in pages.

read_ahead_rnd

innodb_buffer_pool_read_ahead_rnd

ASYNC COUNTER

The number of 'random' read-aheads initiated by InnoDB.

read_ahead

innodb_buffer_pool_read_ahead

ASYNC COUNTER

Number of pages read as read ahead.

read_ahead_evicted

innodb_buffer_pool_read_ahead_evicted

ASYNC COUNTER

Read-ahead pages evicted without being accessed.

read_requests

innodb_buffer_pool_read_requests

ASYNC COUNTER

Number of logical read requests.

reads

innodb_buffer_pool_reads

ASYNC COUNTER

Number of reads directly from disk.

wait_free

innodb_buffer_pool_wait_free

ASYNC COUNTER

Number of times waited for free buffer.

write_requests

innodb_buffer_pool_write_requests

ASYNC COUNTER

Number of write requests.


mysql.inno.data Metrics

Table 33.11 mysql.inno.data Metrics

Name Source Variable OTEL Type Description

fsyncs

innodb_fsyncs

ASYNC COUNTER

Number of fsync() calls.

pending_fsyncs

innodb_pending_fsyncs

ASYNC GAUGE COUNTER

Number of pending fsync operations.

pending_reads

innodb_pending_reads

ASYNC GAUGE COUNTER

The current number of pending reads

pending_writes

innodb_pending_writes

ASYNC GAUGE COUNTER

The current number of pending writes.

read

innodb_read

ASYNC COUNTER

Amount of data read in bytes.

reads

innodb_reads

ASYNC COUNTER

Number of reads initiated.

writes

innodb_writes

ASYNC COUNTER

Number of writes initiated.

written

innodb_written

ASYNC COUNTER

Amount of data written in bytes.


mysql.x Metrics

Table 33.12 mysql.x Metrics

Name Source Variable OTEL Type Description

aborted_clients

Mysqlx_aborted_clients

ASYNC COUNTER

The number of clients that were disconnected because of an input or output error.

bytes_received

Mysqlx_bytes_received

ASYNC COUNTER

The total number of bytes received through the network, measured before decompression.

bytes_received_compressed_payload

Mysqlx_bytes_received_compressed_payload

ASYNC COUNTER

The number of bytes received as compressed message payloads, measured before decompression.

bytes_received_uncompressed_frame

Mysqlx_bytes_received_uncompressed_frame

ASYNC COUNTER

The number of bytes received as compressed message payloads, measured after decompression.

bytes_sent

Mysqlx_bytes_sent

ASYNC COUNTER

The total number of bytes sent through the network.

bytes_sent_compressed_payload

Mysqlx_bytes_sent_compressed_payload

ASYNC COUNTER

The number of bytes sent as compressed message payloads, measured after compression.

bytes_sent_uncompressed_frame

Mysqlx_bytes_sent_uncompressed_frame

ASYNC COUNTER

The number of bytes sent as compressed message payloads, measured before compression.

connection_accept_errors

Mysqlx_connection_accept_errors

ASYNC COUNTER

The number of connections which have caused accept errors.

connection_errors

Mysqlx_connection_errors

ASYNC COUNTER

The number of connections which have caused errors.

connections_accepted

Mysqlx_connections_accepted

ASYNC COUNTER

The number of connections which have been accepted.

connections_closed

Mysqlx_connections_closed

ASYNC COUNTER

The number of connections which have been closed.

connections_rejected

Mysqlx_connections_rejected

ASYNC COUNTER

The number of connections which have been rejected.

crud_create_view

Mysqlx_crud_create_view

ASYNC COUNTER

The number of create view requests received.

crud_delete

Mysqlx_crud_delete

ASYNC COUNTER

The number of delete requests received.

crud_drop_view

Mysqlx_crud_drop_view

ASYNC COUNTER

The number of drop view requests received.

crud_find

Mysqlx_crud_find

ASYNC COUNTER

The number of find requests received.

crud_insert

Mysqlx_crud_insert

ASYNC COUNTER

The number of insert requests received.

crud_modify_view

Mysqlx_crud_modify_view

ASYNC COUNTER

The number of modify view requests received.

crud_update

Mysqlx_crud_update

ASYNC COUNTER

The number of update requests received.

cursor_close

Mysqlx_cursor_close

ASYNC COUNTER

The number of cursor-close messages received.

cursor_fetch

Mysqlx_cursor_fetch

ASYNC COUNTER

The number of cursor-fetch messages received.

cursor_open

Mysqlx_cursor_open

ASYNC COUNTER

The number of cursor-open messages received.

errors_sent

Mysqlx_errors_sent

ASYNC COUNTER

The number of errors sent to clients.

errors_unknown_message_type

Mysqlx_errors_unknown_message_type

ASYNC COUNTER

The number of unknown message types that have been received.

expect_close

Mysqlx_expect_close

ASYNC COUNTER

The number of expectation blocks closed.

expect_open

Mysqlx_expect_open

ASYNC COUNTER

The number of expectation blocks opened.

init_error

Mysqlx_init_error

ASYNC COUNTER

The number of errors during initialisation.

messages_sent

Mysqlx_messages_sent

ASYNC COUNTER

The total number of messages of all types sent to clients.

notice_global_sent

Mysqlx_notice_global_sent

ASYNC COUNTER

The number of global notifications sent to clients.

notice_other_sent

Mysqlx_notice_other_sent

ASYNC COUNTER

The number of other types of notices sent back to clients.

notice_warning_sent

Mysqlx_notice_warning_sent

ASYNC COUNTER

The number of warning notices sent back to clients.

notified_by_group_replication

Mysqlx_notified_by_group_replication

ASYNC COUNTER

Number of Group Replication notifications sent to clients.

prep_deallocate

Mysqlx_prep_deallocate

ASYNC COUNTER

The number of prepared-statement-deallocate messages received.

prep_execute

Mysqlx_prep_execute

ASYNC COUNTER

The number of prepared-statement-execute messages received.

prep_prepare

Mysqlx_prep_prepare

ASYNC COUNTER

The number of prepared-statement messages received.

rows_sent

Mysqlx_rows_sent

ASYNC COUNTER

The number of rows sent back to clients.

sessions

Mysqlx_sessions

ASYNC COUNTER

The number of sessions that have been opened.

sessions_accepted

Mysqlx_sessions_accepted

ASYNC COUNTER

The number of session attempts which have been accepted.

sessions_closed

Mysqlx_sessions_closed

ASYNC COUNTER

The number of sessions that have been closed.

sessions_fatal_error

Mysqlx_sessions_fatal_error

ASYNC COUNTER

The number of sessions that have closed with a fatal error.

sessions_killed

Mysqlx_sessions_killed

ASYNC COUNTER

The number of sessions which have been killed.

sessions_rejected

Mysqlx_sessions_rejected

ASYNC COUNTER

The number of session attempts which have been rejected.

ssl_accepts

Mysqlx_ssl_accepts

ASYNC COUNTER

The number of accepted SSL connections.

ssl_finished_accepts

Mysqlx_ssl_finished_accepts

ASYNC GAUGE COUNTER

The number of successful SSL connections to the server.

worker_threads

Mysqlx_worker_threads

ASYNC GAUGE COUNTER

The number of worker threads available.

worker_threads_active

Mysqlx_worker_threads_active

ASYNC COUNTER

The number of worker threads currently used.


mysql.x.stmt Metrics

Table 33.13 mysql.x.stmt Metrics

Name Source Variable OTEL Type Description

create_collection

Mysqlx_stmt_create_collection

ASYNC COUNTER

The number of create collection statements received.

create_collection_index

Mysqlx_stmt_create_collection_index

ASYNC COUNTER

The number of create collection index statements received.

disable_notices

Mysqlx_stmt_disable_notices

ASYNC COUNTER

The number of disable notice statements received.

drop_collection

Mysqlx_stmt_drop_collection

ASYNC COUNTER

The number of drop collection statements received.

drop_collection_index

Mysqlx_stmt_drop_collection_index

ASYNC COUNTER

The number of drop collection index statements received.

enable_notices

Mysqlx_stmt_enable_notices

ASYNC COUNTER

The number of enable notice statements received.

ensure_collection

Mysqlx_stmt_ensure_collection

ASYNC COUNTER

The number of ensure collection statements received.

execute_mysqlx

Mysqlx_stmt_execute_mysqlx

ASYNC COUNTER

The number of StmtExecute messages received with namespace set to mysqlx.

execute_sql

Mysqlx_stmt_execute_sql

ASYNC COUNTER

The number of StmtExecute requests received for the SQL namespace.

get_collection_options

Mysqlx_stmt_get_collection_options

ASYNC COUNTER

The number of get collection object statements received.

kill_client

Mysqlx_stmt_kill_client

ASYNC COUNTER

The number of kill client statements received.

list_clients

Mysqlx_stmt_list_clients

ASYNC COUNTER

The number of list client statements received.

list_notices

Mysqlx_stmt_list_notices

ASYNC COUNTER

The number of list notice statements received.

list_objects

Mysqlx_stmt_list_objects

ASYNC COUNTER

The number of list object statements received.

modify_collection_options

Mysqlx_stmt_modify_collection_options

ASYNC COUNTER

The number of modify collection options statements received.

ping

Mysqlx_stmt_ping

ASYNC COUNTER

The number of ping statements received.