The HandlerSocket plugin has the following options.
See also the Full list of MariaDB options, system and status variables.
Add the options to the [mysqld] section of your my.cnf file.
handlersocket_accept_balance
0
'), handlersocket will try to balance accepted connections among threads. Default is 0
but if you use persistent connections (for example if you use client-side connection pooling) then a non-zero value is recommended. --handlersocket-accept-balance="value"
0
to 10000
0
MariaDB 5.3
handlersocket_address
--handlersocket-address="value"
0.0.0.0
MariaDB 5.3
handlersocket_backlog
--handlersocket-backlog="value"
5
to 1000000
32768
MariaDB 5.3
handlersocket_epoll
--handlersocket-epoll="value"
0
1
1
MariaDB 5.3
handlersocket_plain_secret
--handlersocket-plain-secret="value"
handlersocket_plain_secret_wr
--handlersocket-plain-secret-wr="value"
handlersocket_port
--handlersocket-port="value"
9998
MariaDB 5.3
handlersocket_port_wr
--handlersocket-port-wr="value"
9999
MariaDB 5.3
handlersocket_rcvbuf
--handlersocket-rcvbuf="value"
0
to 1677216
0
MariaDB 5.3
handlersocket_readsize
--handlersocket-readsize="value"
0
to 1677216
0
(possibly 4096
) MariaDB 5.3
handlersocket_sndbuf
--handlersocket-sndbuf="value"
0
to 1677216
0
MariaDB 5.3
handlersocket_threads
--handlersocket-threads="value"
1
to 3000
16
MariaDB 5.3
handlersocket_threads_wr
--handlersocket-threads-wr="value"
1
to 3000
1
MariaDB 5.3
handlersocket_timeout
--handlersocket-timeout="value"
30
to 3600
300
MariaDB 5.3
handlersocket_verbose
--handlersocket-verbose="value"
0
10000
10
MariaDB 5.3
handlersocket_wrlock_timeout
--handlersocket-wrlock-timeout="value"
0
to 3600
MariaDB 5.3
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/handlersocket-configuration-options/