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

This“NoSQL-style”interface uses thememcachedAPI to speed up database operations, lettingInnoDBhandle memory caching using itsbuffer poolmechanism. Data modified throughmemcachedoperations such asadd,set, andincrare stored to disk, inInnoDBtables. The combination ofmemcachedsimplicity andInnoDBreliability and consistency provides users with the best of both worlds, as explained inSection 15.20.1, “Benefits of the InnoDB memcached Plugin”. For an architectural overview, seeSection 15.20.2, “InnoDB memcached Architecture”.