On 2015-03-24 15:52, Colin Charles wrote:
Would that not reduce the performance that the InnoDB memcached plugin now offers?
It is an interesting question. For some reason original plugin authors decided to build it directly on InnoDB API, rather than on Handler API. I think it's all a matter of trade-offs. Having direct interfaces using engine-specific APIs (like MySQL plugin does it now): + (probably) higher performance can be achieved + will explore different approach then MariaDB HandlerSocket plugin - requires creating interface for every engine Having universal Handler API interface: + requires a lot less work to introduce support for a new engine - (probably) lower performance can be achieved - makes Memcached plugin in fact duplicate of HandlerSocket plugin, but speaking different wire protocol It is possible to combine the best of both worlds: 1. Leave InnoDB memcached plugin interface, as it is already done. (And eventually port it to XtraDB, as it would be relatively straightforward.) 2. Create Handler API memcached plugin interface. As a result, InnoDB tables will be accessible using InnoDB API or Handler API (configurable in containers table?) Other engines tables will be accessible only using Handler API. This will allow performance comparisons between these two approaches in case of InnoDB tables. After some time it would eventually clarify which approach is better. Piotr