Spec-Zone.ru › MySQL 5.7

19.4.2.3 X Plugin Status Variables

The X Plugin status variables have the following meanings.

  • Mysqlx_address

    The network address which X Plugin is bound to. If the bind has failed, or if the skip_networking option has been used, the value shows UNDEFINED.

  • Mysqlx_bytes_received

    The number of bytes received through the network.

  • Mysqlx_bytes_sent

    The number of bytes sent through the network.

  • Mysqlx_connection_accept_errors

    The number of connections which have caused accept errors.

  • Mysqlx_connection_errors

    The number of connections which have caused errors.

  • Mysqlx_connections_accepted

    The number of connections which have been accepted.

  • Mysqlx_connections_closed

    The number of connections which have been closed.

  • Mysqlx_connections_rejected

    The number of connections which have been rejected.

  • Mysqlx_crud_create_view

    The number of create view requests received.

  • Mysqlx_crud_delete

    The number of delete requests received.

  • Mysqlx_crud_drop_view

    The number of drop view requests received.

  • Mysqlx_crud_find

    The number of find requests received.

  • Mysqlx_crud_insert

    The number of insert requests received.

  • Mysqlx_crud_modify_view

    The number of modify view requests received.

  • Mysqlx_crud_update

    The number of update requests received.

  • Mysqlx_errors_sent

    The number of errors sent to clients.

  • Mysqlx_errors_unknown_message_type

    The number of unknown message types that have been received.

  • Mysqlx_expect_close

    The number of expectation blocks closed.

  • Mysqlx_expect_open

    The number of expectation blocks opened.

  • Mysqlx_init_error

    The number of errors during initialisation.

  • Mysqlx_notice_other_sent

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

  • Mysqlx_notice_warning_sent

    The number of warning notices sent back to clients.

  • Mysqlx_port

    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.

  • Mysqlx_rows_sent

    The number of rows sent back to clients.

  • Mysqlx_sessions

    The number of sessions that have been opened.

  • Mysqlx_sessions_accepted

    The number of session attempts which have been accepted.

  • Mysqlx_sessions_closed

    The number of sessions that have been closed.

  • Mysqlx_sessions_fatal_error

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

  • Mysqlx_sessions_killed

    The number of sessions which have been killed.

  • Mysqlx_sessions_rejected

    The number of session attempts which have been rejected.

  • Mysqlx_socket

    The Unix socket which X Plugin is listening to.

  • Mysqlx_ssl_accept_renegotiates

    The number of negotiations needed to establish the connection.

  • Mysqlx_ssl_accepts

    The number of accepted SSL connections.

  • Mysqlx_ssl_active

    If SSL is active.

  • Mysqlx_ssl_cipher

    The current SSL cipher (empty for non-SSL connections).

  • Mysqlx_ssl_cipher_list

    A list of possible SSL ciphers (empty for non-SSL connections).

  • Mysqlx_ssl_ctx_verify_depth

    The certificate verification depth limit currently set in ctx.

  • Mysqlx_ssl_ctx_verify_mode

    The certificate verification mode currently set in ctx.

  • Mysqlx_ssl_finished_accepts

    The number of successful SSL connections to the server.

  • Mysqlx_ssl_server_not_after

    The last date for which the SSL certificate is valid.

  • Mysqlx_ssl_server_not_before

    The first date for which the SSL certificate is valid.

  • Mysqlx_ssl_verify_depth

    The certificate verification depth for SSL connections.

  • Mysqlx_ssl_verify_mode

    The certificate verification mode for SSL connections.

  • Mysqlx_ssl_version

    The name of the protocol used for SSL connections.

  • Mysqlx_stmt_create_collection

    The number of create collection statements received.

  • Mysqlx_stmt_create_collection_index

    The number of create collection index statements received.

  • Mysqlx_stmt_disable_notices

    The number of disable notice statements received.

  • Mysqlx_stmt_drop_collection

    The number of drop collection statements received.

  • Mysqlx_stmt_drop_collection_index

    The number of drop collection index statements received.

  • Mysqlx_stmt_enable_notices

    The number of enable notice statements received.

  • Mysqlx_stmt_ensure_collection

    The number of ensure collection statements received.

  • Mysqlx_stmt_execute_mysqlx

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

  • Mysqlx_stmt_execute_sql

    The number of StmtExecute requests received for the SQL namespace.

  • Mysqlx_stmt_execute_xplugin

    The number of StmtExecute requests received for the X Plugin namespace.

  • Mysqlx_stmt_kill_client

    The number of kill client statements received.

  • Mysqlx_stmt_list_clients

    The number of list client statements received.

  • Mysqlx_stmt_list_notices

    The number of list notice statements received.

  • Mysqlx_stmt_list_objects

    The number of list object statements received.

  • Mysqlx_stmt_ping

    The number of ping statements received.

  • Mysqlx_worker_threads

    The number of worker threads available.

  • Mysqlx_worker_threads_active

    The number of worker threads currently used.

© 2025 Oracle
Licensed under the GPLv2 License.
https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/x-plugin-status-variables.html

Spec-Zone.ru

Настройки Оффлайн Что нового Помощь О нас
Spec-Zone .ru
спецификации, руководства, описания, API