Navigation

HandlerSocket is a MySQL plugin that implements a NoSQL protocol for MySQL. This allows applications to communicate more directly with MySQL storage engines, without the overhead associated with using SQL. This includes operations such as parsing and optimizing queries, as well as table handling operations (opening, locking, unlocking, closing). As a result, using HandlerSocket can provide much better performance for certain applications that using normal SQL application protocols.

Complete documentation on the HandlerSocket plugin, including installation and configuration options, is located here.

The plugin is disabled by default. To enable it in Percona Server with XtraDB, see below.

Once HandlerSocket has been downloaded and installed on your system, there are two steps required to enable it.

First, add the following lines to the [mysqld] section of your my.cnf file:

loose_handlersocket_port=9998# the port number to bind to for read requestsloose_handlersocket_port_wr=9999# the port number to bind to for write requestsloose_handlersocket_threads=16# the number of worker threads for read requestsloose_handlersocket_threads_wr=1# the number of worker threads for write requestsopen_files_limit=65535# to allow handlersocket to accept many concurrent# connections, make open_files_limit as large as# possible.

This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.