Hi pals,
here i have given few commands about memcache

Memcache

Memcache is high performance, distributed memory caching system. it improves or alleviating database load.

Thanks,
Prasath.K

Hi techies,

Working principle of memcache

First, you start up the memcached daemon on as many spare machines as you have. The daemon has no configuration file, just a few command line options, only 3 or 4 of which you'll likely use:

# ./memcached -d -m 2048 -l 10.0.0.40 -p 11211

This starts memcached up as a daemon, using 2GB of memory, and listening on IP 10.0.0.40, port 11211. Because a 32-bit process can only address 4GB of virtual memory (usually significantly less, depending on your operating system), if you have a 32-bit server with 4-64GB of memory using PAE you can just run multiple processes on the machine, each using 2 or 3GB of memory

Thanks,
Prasath.K

Hi,
Another tips

Advantages

Very fast. It uses libevent to scale to any number of open connections (using epoll on Linux, if available at runtime), uses non-blocking network I/O, refcounts internal objects (so objects can be in multiple states to multiple clients), and uses its own slab allocator and hash table so virtual memory never gets externally fragmented and allocations are guaranteed O(1).

Thanks,
Prasath.K

Hi,
Here another tricks...

Mysql triggers and Memcache

Mysql has certain user defined function that interactive with memcache.here how to automative the cache maintenance by calling these functions from triggers.
This all requires running MySQL 5 with dynamically loaded UDF code -- but of course you don't have to upgrade the whole database farm to MySQL 5, just a single replication slave to run the triggers. On this one slave, create AFTER DELETE and AFTER UPDATE triggers that will delete a record from memcache whenever it gets changed or deleted in the database, like this:

CREATE trigger cache_expire_delete AFTER DELETE on table1 FOR EACH ROW DO memcache_delete("memcache_host:11211",OLD.pk) ;

Here are the details.

First, build Sean Chittenden's libmemcache. (On a GNUish operating system, you need to use BSD make rather than GNU make for this). Then build Jan's UDF (there are notes on doing this in my previous post), and place the udf_memcache.so loadable shared object file into /usr/local/lib/.

Next, log into a dynamically-linked MySQL server (e.g. the mysql-max distribution) as root, and execute Jan's create-function-memcache script. The script contains four CREATE FUNCTION statements, like this:

CREATE FUNCTION memcache_delete RETURNS INTEGER SONAME 'udf_memcache.so';
CREATE FUNCTION memcache_set RETURNS INTEGER SONAME 'udf_memcache.so';

CREATE FUNCTION loads in the shared object file, links the SQL function to the UDF code, and creates a record in the mysql.func system table. If you get error 1126 here, it means that the server could not find the .so file.

Thanks,
Prasath.K

Hi,
Another tips

Working Flow of Memcache

Steps:
 The application requests keys foo, bar and baz using the client library, which calculates key hash values, determining which Memcached server should receive requests.
 The Memcached client sends parallel requests to all relevant Memcached servers.
 The Memcached servers send responses to the client library.
 The Memcached client library aggregates responses for the application.

Refer the below link u can understand the above steps....
http://www.linuxjournal.com/articles...451/7451f1.png

Thanks,
Prasath.K