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.