MySQL :: MySQL 5.7 Reference Manual :: 14.21 InnoDB memcached Plugin (original) (raw)

The InnoDB memcached plugin (daemon_memcached) provides an integratedmemcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. Instead of formulating queries in SQL, you can use simpleget, set, andincr operations that avoid the performance overhead associated with SQL parsing and constructing a query optimization plan. You can also access the sameInnoDB tables through SQL for convenience, complex queries, bulk operations, and other strengths of traditional database software.

This “NoSQL-style” interface uses thememcached API to speed up database operations, letting InnoDB handle memory caching using itsbuffer pool mechanism. Data modified through memcached operations such asadd, set, andincr are stored to disk, inInnoDB tables. The combination ofmemcached simplicity andInnoDB reliability and consistency provides users with the best of both worlds, as explained inSection 14.21.1, “Benefits of the InnoDB memcached Plugin”. For an architectural overview, see Section 14.21.2, “InnoDB memcached Architecture”.