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

Seems to be very useful for PK lookups, but I haven't seen much information regarding this. What's the pros and cons of the handler syntax vs. ordinary SQL select for simple key-value queries? How does it compare (performance- and consistence-wise) to HandlerSocket?

share|improve this question
It looks like that the end of your question is lost in transmission. Could you fix it? – dezso Nov 22 '12 at 20:16
-1 for a subjective question. You'll get better answers by asking for specifics, and mentioning what you've tried, and why it didn't work (or did work). – Max Vernon Nov 22 '12 at 20:59
You should have searched for HANDLER with the DBA.SE before asking the question. I'll give you a +1 anyway because it is a legitimate subject in the MySQL realm. – RolandoMySQLDBA Nov 22 '12 at 22:33

This was a weird question. I say was because I addressed this in the past

Basically, the HANDLER syntax is kind of handy if you want to read table data from table while bypassing locking and transactional isolation levels (Yes, this means you should be able to bypass InnoDB's MVCC protocols).

share|improve this answer
How do you compare the SQL handler syntax to HandlerSocket? Fundamentally they expose the same storage interface via different protocols, but what's the difference in performance, etc between the two? – Rio Nov 23 '12 at 19:47

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.