content_image/703709.jpg content_image/703710.jpg
<img src='content_image/703709.jpg'>

## InnoDB memcached Plugin Configuration Tables 

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. 

## cache_policies Table 

mysql> USE innodb_memcache; Database changed mysql> SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ 

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 . 

• innodb_only : Use InnoDB  as the data store. 

• cache_only : Use the memcached  engine as the data store. 

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

• disable : Disable caching. 

## Table 15.28 cache_policies Columns 

<img src='content_image/703710.jpg'>

## config_options Table 

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 . 

