MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
The X Plugin status variables have the following meanings.
The number of clients that were disconnected because of an input or output error.
The network address or addresses for which X Plugin accepts
TCP/IP connections. If multiple addresses were specified
using the
mysqlx_bind_address system
variable, Mysqlx_address
displays only those addresses for which the bind succeeded.
If the bind has failed for every network address specified
by mysqlx_bind_address, or
if the skip_networking
option has been used, the value of
Mysqlx_address is
UNDEFINED. If X Plugin startup is not
yet complete, the value of
Mysqlx_address is empty.
The total number of bytes received through the network. If
compression is used for the connection, this figure
comprises compressed message payloads measured before
decompression
(Mysqlx_bytes_received_compressed_payload),
any items in compressed messages that were not compressed
such as X Protocol headers, and any uncompressed messages.
Mysqlx_bytes_received_compressed_payload
The number of bytes received as compressed message payloads, measured before decompression.
Mysqlx_bytes_received_uncompressed_frame
The number of bytes received as compressed message payloads, measured after decompression.
The total number of bytes sent through the network. If
compression is used for the connection, this figure
comprises compressed message payloads measured after
compression
(Mysqlx_bytes_sent_compressed_payload),
any items in compressed messages that were not compressed
such as X Protocol headers, and any uncompressed messages.
Mysqlx_bytes_sent_compressed_payload
The number of bytes sent as compressed message payloads, measured after compression.
Mysqlx_bytes_sent_uncompressed_frame
The number of bytes sent as compressed message payloads, measured before compression.
(Session scope) The compression algorithm in use for the
X Protocol connection for this session. The permitted
compression algorithms are listed by the
mysqlx_compression_algorithms
system variable.
(Session scope) The compression level in use for the X Protocol connection for this session.
Mysqlx_connection_accept_errors
The number of connections which have caused accept errors.
The number of connections which have caused errors.
The number of connections which have been accepted.
The number of connections which have been closed.
The number of connections which have been rejected.
The number of create view requests received.
The number of delete requests received.
The number of drop view requests received.
The number of find requests received.
The number of insert requests received.
The number of modify view requests received.
The number of update requests received.
The number of cursor-close messages received
The number of cursor-fetch messages received
The number of cursor-open messages received
The number of errors sent to clients.
The number of expectation blocks closed.
The number of expectation blocks opened.
The number of errors during initialisation.
The total number of messages of all types sent to clients.
The number of global notifications sent to clients.
The number of other types of notices sent back to clients.
The number of warning notices sent back to clients.
Mysqlx_notified_by_group_replication
Number of Group Replication notifications sent to clients.
The TCP port which X Plugin is listening to. If a network
bind has failed, or if the
skip_networking system
variable is enabled, the value shows
UNDEFINED.
The number of prepared-statement-deallocate messages received
The number of prepared-statement-execute messages received
The number of prepared-statement messages received
The number of rows sent back to clients.
The number of sessions that have been opened.
The number of session attempts which have been accepted.
The number of sessions that have been closed.
The number of sessions that have closed with a fatal error.
The number of sessions which have been killed.
The number of session attempts which have been rejected.
The Unix socket which X Plugin is listening to.
Mysqlx_ssl_accept_renegotiates
The number of negotiations needed to establish the connection.
The number of accepted SSL connections.
If SSL is active.
The current SSL cipher (empty for non-SSL connections).
A list of possible SSL ciphers (empty for non-SSL connections).
The certificate verification depth limit currently set in ctx.
The certificate verification mode currently set in ctx.
The number of successful SSL connections to the server.
The last date for which the SSL certificate is valid.
The first date for which the SSL certificate is valid.
The certificate verification depth for SSL connections.
The certificate verification mode for SSL connections.
The name of the protocol used for SSL connections.
The number of create collection statements received.
Mysqlx_stmt_create_collection_index
The number of create collection index statements received.
The number of disable notice statements received.
The number of drop collection statements received.
Mysqlx_stmt_drop_collection_index
The number of drop collection index statements received.
The number of enable notice statements received.
The number of ensure collection statements received.
The number of StmtExecute messages received with namespace
set to mysqlx.
The number of StmtExecute requests received for the SQL namespace.
The number of StmtExecute requests received for the
xplugin namespace. From MySQL 8.0.19, the
xplugin namespace has been removed so
this status variable is no longer used.
Mysqlx_stmt_get_collection_options
The number of get collection object statements received.
The number of kill client statements received.
The number of list client statements received.
The number of list notice statements received.
The number of list object statements received.
Mysqlx_stmt_modify_collection_options
The number of modify collection options statements received.
The number of ping statements received.
The number of worker threads available.
The number of worker threads currently used.