The HandlerSocket plugin is included with MariaDB, but like other optional plugins, it is not enabled or configured by default.
Launch the
mysql
command-line client and connect to our MariaDB database.Install the HandlerSocket plugin using the following command:
INSTALL SONAME 'handlersocket';
Open our
my.cnf
ormy.ini
file and add the following command to the[mysqld]
section:# # * HandlerSocket # handlersocket_address="127.0.0.1" handlersocket_port="9998" handlersocket_port_wr="9999"
Stop and restart MariaDB.
Reconnect to MariaDB using the
mysql
command-line client and see the HandlerSocket worker threads using the following statement:SHOW PROCESSLIST;