Rechercher dans le manuel MySQL
20.5.5.2 X Plugin Options and System Variables
To control activation of X Plugin, use this option:
-
Property Value Command-Line Format --mysqlx[=value]
Introduced 8.0.11 Type Enumeration Default Value ON
Valid Values ON
OFF
FORCE
FORCE_PLUS_PERMANENT
This option controls how the server loads X Plugin at startup. In MySQL 8.0, X Plugin is enabled by default, but this option may be used to control its activation state.
The option value should be one of those available for plugin-loading options, as described in Section 5.6.1, “Installing and Uninstalling Plugins”.
If X Plugin is enabled, it exposes several system variables that permit control over its operation:
-
Property Value Command-Line Format --mysqlx-bind-address=addr
System Variable mysqlx_bind_address
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type String Default Value *
The network address on which X Plugin listens for TCP/IP connections. This variable is not dynamic and can be configured only at startup. This is the X Plugin equivalent of the
bind_address
system variable; see that variable description for more information.If
mysqlx_bind_address
is specified, its value must be a single non-wildcard IP address or host name, or one of the wildcard address formats that permit listening on multiple network interfaces (*
,0.0.0.0
, or::
).An IP address can be specified as an IPv4 or IPv6 address. If the value is a host name, X Plugin resolves the name to an IP address and binds to that address. If a host name resolves to multiple IP addresses, X Plugin uses the first IPv4 address if there are any, or the first IPv6 address otherwise.
X Plugin treats different types of addresses as follows:
If the address is
*
, X Plugin accepts TCP/IP connections on all server host IPv4 interfaces, and, if the server host supports IPv6, on all IPv6 interfaces. Use this address to permit both IPv4 and IPv6 connections for X Plugin. This value is the default.If the address is
0.0.0.0
, X Plugin accepts TCP/IP connections on all server host IPv4 interfaces.If the address is
::
, X Plugin accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces.If the address is an IPv4-mapped address, X Plugin accepts TCP/IP connections for that address, in either IPv4 or IPv6 format. For example, if X Plugin is bound to
::ffff:127.0.0.1
, a client such as MySQL Shell can connect using--host=127.0.0.1
or--host=::ffff:127.0.0.1
.If the address is a “regular” IPv4 or IPv6 address (such as
127.0.0.1
or::1
), X Plugin accepts TCP/IP connections only for that IPv4 or IPv6 address.
If binding to the address fails, X Plugin produces an error and the server does not load it.
-
Property Value Command-Line Format --mysqlx-connect-timeout=#
System Variable mysqlx_connect_timeout
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 30
Minimum Value 1
Maximum Value 1000000000
The number of seconds X Plugin waits for the first packet to be received from newly connected clients. This is the X Plugin equivalent of
connect_timeout
; see that variable for more information. mysqlx_document_id_unique_prefix
Property Value Command-Line Format --mysqlx-document-id-unique-prefix=#
System Variable mysqlx_document_id_unique_prefix
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 0
Minimum Value 0
Maximum Value 65535
Sets the first 4 bytes of document IDs generated by the server when documents are added to a collection. By setting this variable to a unique value per instance, you can ensure document IDs are unique across instances. See Understanding Document IDs.
-
Property Value Command-Line Format --mysqlx-document-id-unique-prefix[={OFF|ON}]
System Variable mysqlx_enable_hello_notice
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Boolean Default Value ON
Controls messages sent to classic MySQL protocol clients that try to connect over X Protocol. When enabled, clients which do not support X Protocol that attempt to connect to the server X Protocol port receive an error explaining they are using the wrong protocol.
mysqlx_idle_worker_thread_timeout
Property Value Command-Line Format --mysqlx-idle-worker-thread-timeout=#
System Variable mysqlx_idle_worker_thread_timeout
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 60
Minimum Value 0
Maximum Value 3600
The number of seconds after which idle worker threads are terminated.
-
Property Value Command-Line Format --mysqlx-interactive-timeout=#
Introduced 8.0.4 System Variable mysqlx_interactive_timeout
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 28800
Minimum Value 1
Maximum Value 2147483
The default value of the
mysqlx_wait_timeout
session variable for interactive clients. (The number of seconds to wait for interactive clients to timeout.) -
Property Value Command-Line Format --mysqlx-max-allowed-packet=#
System Variable mysqlx_max_allowed_packet
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 67108864
Minimum Value 512
Maximum Value 1073741824
The maximum size of network packets that can be received by X Plugin. This is the X Plugin equivalent of
max_allowed_packet
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-max-connections=#
System Variable mysqlx_max_connections
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 100
Minimum Value 1
Maximum Value 65535
The maximum number of concurrent client connections X Plugin can accept. This is the X Plugin equivalent of
max_connections
; see that variable for more information.For modifications to this variable, if the new value is smaller than the current number of connections, the new limit is taken into account only for new connections.
-
Property Value Command-Line Format --mysqlx-min-worker-threads=#
System Variable mysqlx_min_worker_threads
Scope Global Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 2
Minimum Value 1
Maximum Value 100
The minimum number of worker threads used by X Plugin for handling client requests.
-
Property Value Command-Line Format --mysqlx-port=port_num
System Variable mysqlx_port
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type Integer Default Value 33060
Minimum Value 1
Maximum Value 65535
The network port on which X Plugin listens for TCP/IP connections. This is the X Plugin equivalent of
port
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-port-open-timeout=#
System Variable mysqlx_port_open_timeout
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type Integer Default Value 0
Minimum Value 0
Maximum Value 120
The number of seconds X Plugin waits for a TCP/IP port to become free.
-
Property Value Command-Line Format --mysqlx-read-timeout=#
Introduced 8.0.4 System Variable mysqlx_read_timeout
Scope Session Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 28800
Minimum Value 30
Maximum Value 2147483
The number of seconds that X Plugin waits for blocking read operations to complete. After this time, if the read operation is not successful, the connection is aborted.
-
Property Value Command-Line Format --mysqlx-socket=file_name
System Variable mysqlx_socket
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type String Default Value /tmp/mysqlx.sock
The path to a Unix socket file which X Plugin uses for connections. This setting is only used by MySQL Server when running on Unix operating systems. Clients can use this socket to connect to MySQL Server using X Plugin.
The default
mysqlx_socket
path and file name is based on the default path and file name for the main socket file for MySQL Server, with the addition of anx
appended to the file name. The default path and file name for the main socket file is/tmp/mysql.sock
, therefore the default path and file name for the X Plugin socket file is/tmp/mysqlx.sock
.If you specify an alternative path and file name for the main socket file at server startup using the
socket
system variable, this does not affect the default for the X Plugin socket file. In this situation, if you want to store both sockets at a single path, you must set themysqlx_socket
system variable as well. For example in a configuration file:socket=/home/sockets/mysqld/mysql.sock mysqlx_socket=/home/sockets/xplugin/xplugin.sock
If you change the default path and file name for the main socket file at compile time using the
MYSQL_UNIX_ADDR
compile option, this does affect the default for the X Plugin socket file, which is formed by appending anx
to theMYSQL_UNIX_ADDR
file name. If you want to set a different default for the X Plugin socket file at compile time, use theMYSQLX_UNIX_ADDR
compile option.The
MYSQLX_UNIX_PORT
environment variable can also be used to set a default for the X Plugin socket file at server startup (see Section 4.9, “MySQL Environment Variables”). If you set this environment variable, it overrides the compiledMYSQLX_UNIX_ADDR
value, but is overridden by themysqlx_socket
value. -
Property Value Command-Line Format --mysqlx-ssl-ca=file_name
System Variable mysqlx_ssl_ca
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type File name This is the X Plugin equivalent of
ssl_ca
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-capath=dir_name
System Variable mysqlx_ssl_capath
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type Directory name This is the X Plugin equivalent of
ssl_capath
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-cert=name
System Variable mysqlx_ssl_cert
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type File name This is the X Plugin equivalent of
ssl_cert
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-cipher=name
System Variable mysqlx_ssl_cipher
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type String The SSL cipher to use for X Protocol connections. This is the X Plugin equivalent of
ssl_cipher
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-crl=file_name
System Variable mysqlx_ssl_crl
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type File name This is the X Plugin equivalent of
ssl_crl
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-crlpath=dir_name
System Variable mysqlx_ssl_crlpath
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type Directory name This is the X Plugin equivalent of
ssl_crlpath
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-ssl-key=file_name
System Variable mysqlx_ssl_key
Scope Global Dynamic No SET_VAR
Hint AppliesNo Type File name This is the X Plugin equivalent of
ssl_key
; see that variable for more information. -
Property Value Command-Line Format --mysqlx-wait-timeout=#
Introduced 8.0.4 System Variable mysqlx_wait_timeout
Scope Session Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 28800
Minimum Value 1
Maximum Value 2147483
The number of seconds that X Plugin waits for activity on a connection. After this time, if the read operation is not successful, the connection is aborted. If the client is noninteractive, the initial value of the session variable is copied from the global
mysqlx_wait_timeout
variable. For interactive clients, the initial value is copied from the sessionmysqlx_interactive_timeout
. -
Property Value Command-Line Format --mysqlx-write-timeout=#
Introduced 8.0.4 System Variable mysqlx_write_timeout
Scope Session Dynamic Yes SET_VAR
Hint AppliesNo Type Integer Default Value 60
Minimum Value 1
Maximum Value 2147483
The number of seconds that X Plugin waits for blocking write operations to complete. After this time, if the write operation is not successful, the connection is aborted.
Deutsche Übersetzung
Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.
Vielen Dank im Voraus.
Dokument erstellt 26/06/2006, zuletzt geändert 26/10/2018
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/mysql-rf-x-plugin-options-system-variables.html
Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.
Referenzen
Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.