InnoDB memcached Plugin Internals InnoDB memcached Plugin Configuration Tables cache_policies Table Table 15.28 cache_policies Columns config_options Table This section describes configuration tables used by the  daemon_memcached  plugin. The cache_policies  table,  config_options  table, and  containers  table are created by the innodb_memcached_config.sql  configuration script in the  innodb_memcache  database. The  cache_policies  table defines a cache policy for the  InnoDB memcached  installation. You can specify individual policies for  get ,  set ,  delete , and  flush  operations, within a single cache policy. The default setting for all operations is  innodb_only . The  config_options  table stores  memcached -related settings that can be changed at runtime using SQL. Supported configuration options are  separator  and  table_map_delimiter . • disable : Disable caching. • caching : Use both  InnoDB  and the  memcached  engine as data stores. In this case, if  memcached cannot find a key in memory, it searches for the value in an  InnoDB  table. • cache_only : Use the  memcached  engine as the data store. • innodb_only : Use  InnoDB  as the data store. mysql>  USE innodb_memcache; Database changed mysql>  SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ memcached Command DML or DDL Operations flush_all TRUNCATE TABLE  (DDL) Column Description policy_name Name of the cache policy. The default cache policy name is  cache_policy . get_policy The cache policy for get operations. Valid values are  innodb_only ,  cache_only ,  caching , or disabled . The default setting is  innodb_only . set_policy The cache policy for set operations. Valid values are  innodb_only ,  cache_only ,  caching , or disabled . The default setting is  innodb_only . delete_policy The cache policy for delete operations. Valid values are  innodb_only ,  cache_only ,  caching , or disabled . The default setting is  innodb_only . flush_policy The cache policy for flush operations. Valid values are  innodb_only ,  cache_only ,  caching , or disabled . The default setting is  innodb_only . 3384