HandlerSocket plugin for MySQL - Replacement for memcache?

mikeytown2's picture

interesting benchmarks

                           approx qps     server CPU util
MySQL via SQL                105,000      %us 60%  %sy 28%
memcached                    420,000      %us  8%  %sy 88%
MySQL via HandlerSocket      750,000      %us 45%  %sy 53%


Verification of benchmarks

Percona Server now both SQL and NOSQL

Various PHP libraries via https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL

Anyway this seems like a major win. All the bits are in place for this to be used. Nice thing about HandlerSocket is it gets around some of the limitations of memcache; if it doesn't work then just use normal SQL commands.



I like the percona server.

bennos's picture

I like the percona server. Great performance after some tuning, better the standard mysql.

Percona NoSQL Feature could be a great caching solution.
How can we implement it? Can we adopt some code from existing NoSQL modules?

Among the list of cons

FiReaNGeL's picture

Among the list of cons: For HDD i/o bound workloads, a database instance can not execute thousands of queries per second, which normally results in only 1-10% CPU usage. In such cases, SQL execution layer does not become bottleneck, so there is no benefit to use Hanldersocket. We use HandlerSocket on servers that almost all data fit in memory.

Which is the case for many DB scenarios when you have limited RAM.

Buy more ram..

soltrinox's picture

I mean come on, if you can get serious performance with very little cost of RAM than do it.
Why wouldn't anyone put their Database on a server with less 24 to 36 gigs of RAM if they are doing thousands of queries per second? DUH!

I mean it makes sense, keep everything in memory, that is if your after performance.
I'll definitely give HandlerSocket a try.

what library is better for

podarok's picture

what library is better for us?
I can`t find any tests

The main trouble - that HandlerSocket not webhosting standard - it only for a hiload installations on VPS or VDS

Due to memcached module already in contrib what benefits we can get from it?

Andriy Podanenko
web: http://druler.com