depending on the operating system, you might use apt-get , yum , or port install . For example, on Ubuntu Linux, use: 

sudo apt-get install libevent-dev 

•If you installed MySQL from a source code release, libevent 1.4.12 is bundled with the package and is located at the top level of the MySQL source code directory. If you use the bundled version of libevent , no action is required. If you want to use a local system version of libevent , you must build MySQL with the -DWITH_LIBEVENT  build option set to system  or yes . 

## Installing and Configuring the InnoDB memcached Plugin 

1. Configure the daemon_memcached  plugin so it can interact with InnoDB  tables by running the innodb_memcached_config.sql  configuration script, which is located in MYSQL_HOME /share . This script installs the innodb_memcache  database with three required tables ( cache_policies , config_options , and containers ). It also installs the demo_test  sample table in the test database. 

mysql> source MYSQL_HOME /share/innodb_memcached_config.sql 

Running the innodb_memcached_config.sql  script is a one-time operation. The tables remain in place if you later uninstall and re-install the daemon_memcached  plugin. 

mysql> USE innodb_memcache; mysql> SHOW TABLES; +---------------------------+ | Tables_in_innodb_memcache | +---------------------------+ | cache_policies | | config_options | | containers | +---------------------------+ mysql> USE test; mysql> SHOW TABLES; +----------------+ | Tables_in_test | +----------------+ | demo_test | +----------------+ 

Of these tables, the innodb_memcache.containers  table is the most important. Entries in the containers  table provide a mapping to InnoDB  table columns. Each InnoDB  table used with the daemon_memcached  plugin requires an entry in the containers  table. 

The innodb_memcached_config.sql  script inserts a single entry in the containers  table that provides a mapping for the demo_test  table. It also inserts a single row of data into the demo_test table. This data allows you to immediately verify the installation after the setup is completed. 

mysql> SELECT * FROM innodb_memcache.containers\G *************************** 1. row *************************** name: aaa db_schema: test db_table: demo_test key_columns: c1 value_columns: c2 flags: c3 cas_column: c4 expire_time_column: c5 unique_idx_name_on_key: PRIMARY mysql> SELECT * FROM test.demo_test; 

