您好, 欢迎来到 !    登录 | 注册 | | 设为首页 | 收藏本站

Mysql:as of 8.0.14+:--admin-address、--admin-port、--create-admin-listener-thread

bubuko 2022/1/25 20:05:21 mysql 字数 12319 阅读 806 来源 http://www.bubuko.com/infolist-5-1.html

【不指定】该--admin-address选项(系统变量),则不会起该管理监听!!! admin_address PropertyValue Command-Line Format --admin-address=addr Introduced 8.0.14 System Variable admi ...

 

【不指定】该--admin-address选项(系统变量),则不会起该管理监听!!!

 

  • admin_address

    Property Value
    Command-Line Format --admin-address=addr
    Introduced 8.0.14
    System Variable admin_address
    Scope Global
    Dynamic No
    SET_VAR Hint Applies No
    Type String

    The IP address on which to listen for TCP/IP connections on the administrative network interface (see Section 8.12.4.1, “How MySQL Handles Client Connections”). There is no default admin_address value. If this variable is not specified at startup, the server maintains no administrative interface. The server also has a bind_address system variable for configuring regular (nonadministrative) client TCP/IP connections. See Section 8.12.4.1, “How MySQL Handles Client Connections”.

    If admin_address is specified, its value must satisfy these requirements:

    • The value must be a single IPv4 address, IPv6 address, or host name.

    • The value cannot specify a wildcard address format (*, 0.0.0.0, or ::).

    An IP address can be specified as an IPv4 or IPv6 address. If the value is a host name, the server resolves the name to an IP address and binds to that address. If a host name resolves to multiple IP addresses, the server uses the first IPv4 address if there are any, or the first IPv6 address otherwise.

    The server treats different types of addresses as follows:

    • If the address is an IPv4-mapped address, the server accepts TCP/IP connections for that address, in either IPv4 or IPv6 format. For example, if the server is bound to ::ffff:127.0.0.1, clients 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), the server accepts TCP/IP connections only for that IPv4 or IPv6 address.

    If binding to the address fails, the server produces an error and does not start.

    The admin_address system variable is similar to the bind_address system variable that binds the server to an address for ordinary client connections, but with these differences:

  • admin_port

    Property Value
    Command-Line Format --admin-port=port_num
    Introduced 8.0.14
    System Variable admin_port
    Scope Global
    Dynamic No
    SET_VAR Hint Applies No
    Type Integer
    Default Value 33062
    Minimum Value 0
    Maximum Value 65535

    The TCP/IP port number to use for connections on the administrative network interface (see Section 8.12.4.1, “How MySQL Handles Client Connections”). Setting this variable to 0 causes the default value to be used.

    Setting admin_port has no effect if admin_address is not specified because in that case the server maintains no administrative network interface.

  • create_admin_listener_thread

    Property Value
    Command-Line Format --create-admin-listener-thread[={OFF|ON}]
    Introduced 8.0.14
    System Variable create_admin_listener_thread
    Scope Global
    Dynamic No
    SET_VAR Hint Applies No
    Type Boolean
    Default Value OFF

    Whether to use a dedicated listening thread for client connections on the administrative network interface (see Section 8.12.4.1, “How MySQL Handles Client Connections”). The default is to implement the administrative interface using the listener thread used for ordinary connections.

    Depending on factors such as platform type and workload, you may find one setting for this variable yields better performance than the other setting.

    Setting create_admin_listener_thread has no effect if admin_address is not specified because in that case the server maintains no administrative network interface.

 

Mysql:as of 8.0.14+:--admin-address、--admin-port、--create-admin-listener-thread

原文:https://www.cnblogs.com/jinzhenshui/p/12499449.html


如果您也喜欢它,动动您的小指点个赞吧

除非注明,文章均由 laddyq.com 整理发布,欢迎转载。

转载请注明:
链接:http://laddyq.com
来源:laddyq.com
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。


联系我
置顶