Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

From InnoDB Memcached with Binlog Capability

In our earlier Labs release, we presented a MySQL NoSQL solution through InnoDB Memcached Daemon Plugin (see earlier Calvin’s and my posts). That earlier release allows the Memcached Plugin directly interacting with InnoDB, completely bypassing MySQL optimizer and QP layers. It differs with another popular MySQL NoSQL solution, HandlerSocket, by skipping even the Handler API layer and directly access the InnoDB through InnoDB APIs. Thus, in theory, it would be simpler and more efficient.

What is QP Layers?

Searching did not yield me any good results. The closest I came to was Query Path. Is this right?

share|improve this question
up vote 2 down vote accepted

QP most likely stands for Query Parsing.

MySQL Optimizer needs info from the Query Parser to ascertain table names and column names along with associated data types.

I made an earlier post in the DBA StackExchange about how the HandlerSocket bypasses MVCC and row-level locks. I would be a little leary about bypassing even the HandlerSocket. I say that because HandlerSocket has issues with doing reads while there are write operations interacting with the same data. Please make sure the Memcached Plugin does not have the same deficieny. Please check for any known bugs in this matter.

share|improve this answer
Thanks for the input. – ThinkingMonkey Dec 5 '11 at 13:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.