HandlerSocket

You are viewing an old version of this article. View the current version here.

Handlersocket gives you direct access to InnoDB/XtraDB. It's included in MariaDB 5.3 as a ready-to use plugin.

The origin of the following is from the HandlerSocket's README file, Copyright © 2010 DeNA Co.,Ltd

What is handler socket

HandlerSocket is a NoSQL plugin for MySQL/MariaDB. It works as a daemon inside the mysqld process, accept tcp connections, and execute requests from clients. HandlerSocket does not support SQL queries. Instead, it supports simple CRUD operations on tables.

Because of the following reasons, HandlerSocket is much faster than the mysqld/libmysql pair in some circumstances:

  • HandlerSocket manipulates data without parsing SQL, which causes less CPU usage.
  • HandlerSocket reads many requests from clients and executes their requests in bulk, which causes less CPU and disk usage.
  • HandlerSocket client/server protocol is more compact than the mysql/libmysql pair, which causes less network usage.

Libraries

The current version of HandlerSocket only works with GNU/Linux. The source archive of HandlerSocket includes a C++ and a Perl client libraries. Here is a list of client libraries for other languages:

  • The home of HandlerSocket is here.
  • The story of handlersocket can be found here.
  • Comparison of HANDLER and HandlerSocket can be found here.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.