List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:December 3 2008 6:21am
Subject:Could somebody tell me how to use the memcache engine inside mysql?
View as plain text  
Although I set up memcache engine successfully on my computer, I didn't know
how to use it?
I can not find where the document is.

Here is my result of engines.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.1.30 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show engines;
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| Engine     | Support |
Comment                                                        |
Transactions | XA  | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| InnoDB     | YES     | Supports transactions, row-level locking, and
foreign keys     | YES          | YES | YES        |
| MEMCACHE   | YES     | Simple Interface for working with memcache as a
storage engine | NO           | NO  | NO         |
| CSV        | YES     | CSV storage
engine                                             | NO           | NO  |
NO         |
| BLACKHOLE  | YES     | /dev/null storage engine (anything you write to it
disappears) | NO           | NO  | NO         |
| MRG_MYISAM | YES     | Collection of identical MyISAM
tables                          | NO           | NO  | NO         |
| MEMORY     | YES     | Hash based, stored in memory, useful for temporary
tables      | NO           | NO  | NO         |
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23 with great
performance         | NO           | NO  | NO         |
| ARCHIVE    | YES     | Archive storage
engine                                         | NO           | NO  |
NO         |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
8 rows in set (0.00 sec)

mysql> Aborted

Any reply is appreciated.
-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Thread
Could somebody tell me how to use the memcache engine inside mysql?Moon's Father3 Dec
Re: Could somebody tell me how to use the memcache engine inside mysql?Moon's Father5 Dec