1

http://dev.mysql.com/doc/refman/5.5/en/handler.html

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?

0

1 Answer 1

1

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).

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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