Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.0Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 37.3Mb
HTML Download (TGZ) - 10.2Mb
HTML Download (Zip) - 10.2Mb
HTML Download (RPM) - 8.9Mb
Man Pages (TGZ) - 216.6Kb
Man Pages (Zip) - 329.3Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  X Plugin System Variables and Options

19.7.2.2 X Plugin System Variables and Options

The following command options configure X Plugin:

  • --mysqlx_port[=value]

    Command-Line Format--mysqlx-port=#
    System VariableNamemysqlx_port
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypeinteger
    Default33060
    Min Value1
    Max Value65535

    Specifies the port where the X Plugin listens for connections. This option is only read at start up, therefore to change it on a running server requires a restart.

  • --mysqlx_port_open_timeout[=value]

    Command-Line Format--mysqlx-port-open-timeout=#
    System VariableNamemysqlx_port_open_timeout
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypeinteger
    Default0
    Min Value1
    Max Value120

    Specifies how long X Plugin should wait to use a port when the port is already allocated. By default no retries are attempted. Set the value to the number of seconds X Plugin should wait before retrying to use the port.

  • --mysqlx_bind_address[=value]

    Command-Line Format--mysqlx-bind-address=#
    System VariableNamemysqlx_bind_address
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypestring
    Default*

    By default X Plugin listens for connections on a single IPv4 TCP/IP network socket. Use this option to configure changes to where X Plugin listens for connections, such as binding to an IPv6 address, all IPv4 and IPv6 addresses or a default IPv6 address with a fallback IPv4 address.

    X Plugin treats different types of addresses as follows:

    • If the address is *, X Plugin accepts TCP/IP connections on all server host IPv6 and IPv4 interfaces if the server host supports IPv6, or accepts TCP/IP connections on all IPv4 addresses otherwise. Use this address to permit both IPv4 and IPv6 connections on all server interfaces. 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. This value is the default.

    • If the address is ::, X Plugin accepts TCP/IP connections on all server host IPv4 and IPv6 interfaces.

    • If the address is *, X Plugin accepts TCP/IP connections on all server host IPv6 and IPv4 interfaces if the server host supports IPv6, or accepts TCP/IP connections on all IPv4 addresses otherwise. Use this address to permit both IPv4 and IPv6 connections for X Plugin.

    • 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.

  • --mysqlx_connect_timeout[=value]

    Command-Line Format--mysqlx-connect-timeout=#
    System VariableNamemysqlx_connect_timeout
    Variable ScopeGlobal
    Dynamic VariableYes
    Permitted ValuesTypeinteger
    Default30
    Min Value1
    Max Value18446744073709551615

    Number of seconds to wait for the first packet to be received from newly connected clients. This option is dynamically changeable.

  • mysqlx_idle_worker_thread_timeout[=value]

    Command-Line Format--mysqlx-idle-worker-thread-timeout=#
    Permitted ValuesTypeinteger
    Default60
    Min Value0
    Max Value18446744073709551615

    Time in seconds after which an idle worker thread is terminated.

  • mysqlx_max_allowed_packet[=value]

    Command-Line Format--mysqlx-max-allowed-packet=#
    Permitted ValuesTypeinteger
    Default1048576
    Min Value0
    Max Value18446744073709551615

    Maxmum size of a network packet that X Plugin can process. This option is dynamically changeable.

  • mysqlx_max_connections[=value]

    Command-Line Format--mysqlx-max-connections=#
    System VariableNamemysqlx_max_connections
    Variable ScopeGlobal
    Dynamic VariableYes
    Permitted ValuesTypeinteger
    Default100
    Min Value1
    Max Value18446744073709551615

    Maximum number of concurrent client connections the X Plugin can accept. This option is dynamically changeable. When modifying this variable, if the new value is smaller than the current number of connections, the new limit is only taken into account for new connections.

  • mysqlx_min_worker_threads[=value]

    Command-Line Format--mysqlx-min-worker-threads=#
    Permitted ValuesTypeinteger
    Default2
    Min Value1
    Max Value18446744073709551615

    The minimum number of worker threads the X Plugin uses for handling client requests. The maximum number of worker threads is limited implicitly by --mysqlx_max_connections. This option is dynamically changeable.

  • --mysqlx-socket[=value]

    Introduced5.7.15
    Command-Line Format--mysqlx-socket=file_name
    System VariableNamemysqlx_socket
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypestring
    Default/tmp/mysqlx.sock

    The path to a Unix socket file which X Plugin uses for connections. Only used by MySQL Server when running on Unix operating systems. Clients can then use this socket to connect to MySQL Server using the X Plugin.

    The value of mysqlx_socket depends on the value of socket. By default socket is /tmp/mysql.sock and therefore mysqlx_socket is /tmp/mysqlx.sock. If socket is set to /sockets/mysql.sock and mysqlx_socket has not been manually configured, then mysqlx_socket is set to /sockets/mysqlx.sock. In other words the path and filename of socket is used and an x is appended to the filename, this enables you to conveniently store the sockets used by MySQL server at a single path. To define separate paths or unique filenames for the MySQL and X Plugin sockets, configure both the socket and the mysqlx_socket system variables. For example in a configuration file:

    socket=/home/sockets/mysqld/mysql.sock
    mysqlx_socket=/home/sockets/xplugin/xplugin.sock

    Alternatively, X Plugin can be configured at compile time to use a specific socket with the MYSQLX_UNIX_ADDR option. If the X Plugin MYSQLX_UNIX_ADDR compile option is not set, the value is based on the MYSQL_UNIX_ADDR and adds an x to the file name, for example resulting in /tmp/mysqlx.sock.

  • --mysqlx_ssl[=value]

    Command-Line Format--mysqlx-ssl=#
    System VariableNamemysqlx_ssl
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypeinteger

    The equivalent of ssl for X Plugin, see that variable for more information.

  • --mysqlx_ssl_ca[=value]

    Command-Line Format--mysqlx-ssl-ca=file_name
    System VariableNamemysqlx_ssl_ca
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypefile name

    The equivalent of ssl_ca for X Plugin, see that variable for more information.

  • --mysqlx_ssl_capath[=value]

    Command-Line Format--mysqlx-ssl-capath=dir_name
    System VariableNamemysqlx_ssl_capath
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypedirectory name

    The equivalent of ssl_capath for X Plugin, see that variable for more information.

  • --mysqlx_ssl_cert[=value]

    Command-Line Format--mysqlx-ssl-cert
    System VariableNamemysqlx_ssl_key
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypefile name

    The equivalent of ssl_cert for X Plugin, see that variable for more information.

  • --mysqlx_ssl_cipher[=value]

    Command-Line Format--mysqlx-ssl-cipher=name
    Permitted ValuesTypestring

    The equivalent of ssl_cipher for X Plugin, see that variable for more information.

  • --mysqlx_ssl_crl[=value]

    Command-Line Format--mysqlx-ssl-crl=file_name
    System VariableNamemysqlx_ssl_crl
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypefile name

    The equivalent of ssl_crl for X Plugin, see that variable for more information.

  • --mysqlx_ssl_crlpath[=value]

    Command-Line Format--mysqlx-ssl-crlpath=directory_name
    System VariableNamemysqlx_ssl_crlpath
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypedirectory name

    The equivalent of ssl_crlpath for X Plugin, see that variable for more information.

  • --mysqlx_ssl_key[=value]

    Command-Line Format--mysqlx-ssl-key=file_name
    System VariableNamemysqlx_ssl_key
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypefile name

    The equivalent of ssl_key for X Plugin, see that variable for more information.

The following system variables control X Plugin.

  • mysqlx_socket

    Introduced5.7.15
    Command-Line Format--mysqlx-socket=file_name
    System VariableNamemysqlx_socket
    Variable ScopeGlobal
    Dynamic VariableNo
    Permitted ValuesTypestring
    Default/tmp/mysqlx.sock

    The socket where X Plugin listens for connections.


User Comments
Sign Up Login You must be logged in to post a comment.