Rechercher dans le manuel MySQL
20.5.6.3 X Plugin Status Variables
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_addresssystem variable,Mysqlx_addressdisplays only those addresses for which the bind succeeded. If the bind has failed for every network address specified bymysqlx_bind_address, or if theskip_networkingoption has been used, the value ofMysqlx_addressisUNDEFINED. If X Plugin startup is not yet complete, the value ofMysqlx_addressis 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_payloadThe number of bytes received as compressed message payloads, measured before decompression.
Mysqlx_bytes_received_uncompressed_frameThe 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_payloadThe number of bytes sent as compressed message payloads, measured after compression.
Mysqlx_bytes_sent_uncompressed_frameThe 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_algorithmssystem variable.(Session scope) The compression level in use for the X Protocol connection for this session.
Mysqlx_connection_accept_errorsThe 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_replicationNumber 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_networkingsystem variable is enabled, the value showsUNDEFINED.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_renegotiatesThe 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_indexThe 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_indexThe 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
xpluginnamespace. From MySQL 8.0.19, thexpluginnamespace has been removed so this status variable is no longer used.Mysqlx_stmt_get_collection_optionsThe 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_optionsThe 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.
Traduction non disponible
Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.
Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-x-plugin-status-variables.html
L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.
Références
Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.
