<![CDATA[张宴的博客]]> http://zyan.cc/index.php zh-cn http://zyan.cc/post/357/ <![CDATA[MySQL Memcache_engine的安装与使用[原创]]]> 张宴 <net@s135.com> Sun, 20 Jul 2008 05:58:11 +0000 http://zyan.cc/post/357/ http://blog.zyan.cc/post/357/]

　　鉴于国内外还没有人撰写如何安装Memcache_engine的文章，于是，我根据自己的编译安装步骤，写下此文。

　　Memcache_engine是一个MySQL 5.1数据库的存储引擎，它能够让用户通过标准的SQL语句（SELECT/UPDATE/INSERTE/DELETE）访问Memcached（还支持新浪的Memcachedb、dbcached）中存放的数据。

　　限制：
　　1、Memcache表必须有主键。
　　2、只能使用主键去查询，即只能使用SELECT ... FROM ... WHERE id = ... 方式去查询。
　　3、不支持自增ID。

　　安装与使用：
　　1、编译安装memcache_engine的步骤：
cd /tmp
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.26-rc.tar.gz/from/http://mirror.x10.com/mirror/mysql/
tar zxvf mysql-5.1.26-rc.tar.gz
#安装、配置MySQL的步骤省略，注意不要以静态方式编译安装。

wget http://download.tangent.org/libmemcached-0.23.tar.gz
tar zxvf libmemcached-0.23.tar.gz
cd libmemcached-0.23/
./configure --prefix=/usr/local/memcache_engine
make
make install
cd ../

wget http://xmlsoft.org/sources/libxml2-2.6.32.tar.gz
tar zxvf libxml2-2.6.32.tar.gz
cd libxml2-2.6.32/
./configure --prefix=/usr/local/memcache_engine
make
make install
cd ../

wget http://download.tangent.org/libxmlrow-0.2.tar.gz
tar zxvf libxmlrow-0.2.tar.gz
cd libxmlrow-0.2/
export PKG_CONFIG_PATH=/usr/local/memcache_engine/lib/pkgconfig/
./configure --prefix=/usr/local/memcache_engine
make
make install
cd ../

wget http://download.tangent.org/memcache_engine-0.7.tar.gz
tar zxvf memcache_engine-0.7.tar.gz
cd memcache_engine-0.7/
sed -i "s#uint16_t#uint32_t#g" ./src/ha_memcache.cc
export PKG_CONFIG_PATH=/usr/local/memcache_engine/lib/pkgconfig/
./configure --prefix=/usr/local/memcache_engine --with-mysql=/tmp/mysql-5.1.26-rc
make
make install
cd ../

　　注意：红色标记部分为MySQL 5.1.22以上版本的源码路径。

............

Tags - , , , , , , , ]]> http://zyan.cc/post/357/#blogcomment1342 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> lphy <user@domain.com> Sun, 20 Jul 2008 15:35:24 +0000 http://zyan.cc/post/357/#blogcomment1342 http://zyan.cc/post/357/#blogcomment1343 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> apu <user@domain.com> Mon, 21 Jul 2008 00:02:40 +0000 http://zyan.cc/post/357/#blogcomment1343 http://zyan.cc/post/357/#blogcomment1344 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> yorkane <whyork@21cn.com> Mon, 21 Jul 2008 03:59:06 +0000 http://zyan.cc/post/357/#blogcomment1344 有没有测试过，这样的组合效率如何？
有没有谁用memcached_engine做过应用啊？ ]]> http://zyan.cc/post/357/#blogcomment1348 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> king'space <user@domain.com> Tue, 22 Jul 2008 06:43:28 +0000 http://zyan.cc/post/357/#blogcomment1348
很多都是关于性能优化。

张兄能否把自己的博客 优化的速度快些？或是我网通访问慢。 ]]> http://zyan.cc/post/357/#blogcomment1484 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> kevin <user@domain.com> Tue, 02 Sep 2008 11:48:17 +0000 http://zyan.cc/post/357/#blogcomment1484 创建一张memcache_engine表的SQL语句：
CREATE TABLE `table` (
`id` int(11) NOT NULL DEFAULT '0',
`a` int(11) DEFAULT NULL,
`b` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MEMCACHE DEFAULT CHARSET=latin1
CONNECTION='localhost:11211';

张老师，请问,这在mysql里使用哪个库呀？
我在按你所做的时候，出现如下错误：
mysql> CREATE TABLE `table` (
   -> `id` int(11) NOT NULL DEFAULT '0',
   -> `a` int(11) DEFAULT NULL,
   -> `b` int(11) DEFAULT NULL,
   -> PRIMARY KEY (`id`)
   -> ) ENGINE=MEMCACHE DEFAULT CHARSET=latin1
   -> CONNECTION='localhost:11211';
ERROR 1046 (3D000): No database selected

刚编译安装完的mysql数据库的表有：
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
+--------------------+
3 rows in set (0.00 sec)

请问，执行你的那段代码时，是使用哪个库或是新建一个库？ ]]> http://zyan.cc/post/357/#blogcomment1488 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> kevin <user@domain.com> Wed, 03 Sep 2008 01:33:52 +0000 http://zyan.cc/post/357/#blogcomment1488 http://zyan.cc/post/357/#blogcomment1489 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> kevin <user@domain.com> Wed, 03 Sep 2008 01:55:10 +0000 http://zyan.cc/post/357/#blogcomment1489
引用

mysql> create database memcache;
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> use memcache;
Database changed
mysql>
mysql> CREATE TABLE `table` (
   -> `id` int(11) NOT NULL DEFAULT '0',
   -> `a` int(11) DEFAULT NULL,
   -> `b` int(11) DEFAULT NULL,
   -> PRIMARY KEY (`id`)
   -> ) ENGINE=MEMCACHE DEFAULT CHARSET=latin1
   -> CONNECTION='localhost:11211';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> show tables;
+--------------------+
| Tables_in_memcache |
+--------------------+
| table              |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1
mysql>
mysql> select * from table where id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table where id=1' at line 1


请问张老师，我这样的查询，是哪里出了问题了吗？ ]]> http://zyan.cc/post/357/#blogcomment1490 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> kevin <ldw21cn@hotmail.com> Wed, 03 Sep 2008 02:28:33 +0000 http://zyan.cc/post/357/#blogcomment1490
引用

mysql> create database memcache;
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> use memcache;
Database changed
mysql>
mysql> CREATE TABLE `table` (
  -> `id` int(11) NOT NULL DEFAULT '0',
  -> `a` int(11) DEFAULT NULL,
  -> `b` int(11) DEFAULT NULL,
  -> PRIMARY KEY (`id`)
  -> ) ENGINE=MEMCACHE DEFAULT CHARSET=latin1
  -> CONNECTION='localhost:11211';
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> show tables;
+--------------------+
| Tables_in_memcache |
+--------------------+
| table              |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1
mysql>
mysql> select * from table where id=1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table where id=1' at line 1
请问张老师，我这样的查询，是哪里出了问题了吗？


引用

找到解决方法了，如下所示：
先启动memcache
#memcached -d -p 11211 -u nobody -m 256 -c 1024 -P /tmp/memcached.pid
#mysql
mysql> use memcache;
Database changed
mysql>
mysql> create table `memdata` (
   ->   `id` int(11) not null default '0',
   ->   `name` char(50) default null,
   ->   `info` varchar(255) default null,
   ->   primary key (`id`)
   -> ) engine=memcache default charset=latin1
   -> connection='localhost:11211';
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql> insert into memdata (id, name, info) values (1, 'kevin', 'system');
Query OK, 1 row affected (0.01 sec)
mysql>
mysql> select * from memdata;
Empty set (0.00 sec)
mysql>
mysql> select * from memdata where id=1;
+----+-------+-----------+
| id | name  | info      |
+----+-------+-----------+
|  1 | kevin | system |
+----+-------+-----------+
1 row in set (0.00 sec)
mysql>quit;

从上面的实验可以看出：
只能使用主键去查询，即只能使用SELECT ... FROM ... WHERE id = ... 方式去查询。


呵，班门弄斧了一下，请张老师指点一下!
]]> http://zyan.cc/post/357/#blogcomment1611 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> 冰山 <user@domain.com> Sun, 28 Sep 2008 03:01:56 +0000 http://zyan.cc/post/357/#blogcomment1611 http://zyan.cc/post/357/#blogcomment1715 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> www <user@domain.com> Thu, 23 Oct 2008 08:39:24 +0000 http://zyan.cc/post/357/#blogcomment1715 http://zyan.cc/post/357/#blogcomment2147 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> lll0905 <user@domain.com> Sat, 06 Dec 2008 06:34:24 +0000 http://zyan.cc/post/357/#blogcomment2147
[root@dbmemcache /usr/src/memcache_engine-0.7]==>./configure --prefix=/usr/local/memcache_engine \
> --with-mysql=/usr/src/mysql-5.1.30

但是make时报错:

In file included from mysql_priv.h:652,
                from ha_memcache.cc:30:
/usr/src/mysql-5.1.30/sql/table.h:502: error: use of enum 'enum_table_ref_type' without previous declaration
/usr/src/mysql-5.1.30/sql/table.h: In member function 'int st_table_share::get_table_ref_type() const':
/usr/src/mysql-5.1.30/sql/table.h:505: error: 'TABLE_REF_VIEW' was not declared in this scope
/usr/src/mysql-5.1.30/sql/table.h:508: error: 'TABLE_REF_BASE_TABLE' was not declared in this scope
/usr/src/mysql-5.1.30/sql/table.h:510: error: 'TABLE_REF_I_S_TABLE' was not declared in this scope
/usr/src/mysql-5.1.30/sql/table.h:512: error: 'TABLE_REF_TMP_TABLE' was not declared in this scope
/usr/src/mysql-5.1.30/sql/table.h: At global scope:
/usr/src/mysql-5.1.30/sql/table.h:1370: error: 'enum_query_type' has not been declared
/usr/src/mysql-5.1.30/sql/table.h:1488: error: use of enum 'enum_table_ref_type' without previous declaration
In file included from mysql_priv.h:670,
                from ha_memcache.cc:30:
/usr/src/mysql-5.1.30/sql/item.h:783: error: 'enum_query_type' has not been declared
还有很多..............................省略.

研究了一会.无奈.
求助! ]]> http://zyan.cc/post/357/#blogcomment2797 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> 黑糊糊 <user@domain.com> Sun, 15 Mar 2009 13:06:05 +0000 http://zyan.cc/post/357/#blogcomment2797 http://zyan.cc/post/357/#blogcomment5948 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> wolf <wangxuliangboy@163.com> Thu, 20 May 2010 02:38:55 +0000 http://zyan.cc/post/357/#blogcomment5948 我在配置mysql memcache_engine时。出现mysql crashing
http://bugs.mysql.com/bug.php?id=43892  这个里面推荐使用libmemcache-0.26。但我换了还一样。。


key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=1
max_threads=151
threads_connected=1
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338299 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd: 0xebbb060
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x4157e0e0 thread_stack 0x40000
/app/java/mysql/libexec/mysqld(my_print_stacktrace+0x24) [0x756ce4]
/app/java/mysql/libexec/mysqld(handle_segfault+0x322) [0x587772]
/lib64/libpthread.so.0 [0x366000e7c0]
/app/java/mysql/libexec/mysqld [0x768a73]
/app/java/mysql/libexec/mysqld(my_hash_insert+0x229) [0x74be99]
/app/java/mysql/lib/mysql/plugin/libmemcache_engine.so(ha_memcache::open(char const*, int, unsigned int)+0x189) [0x2aaaab3b4959]
/app/java/mysql/libexec/mysqld(handler::ha_open(st_table*, char const*, int, int)+0x3f) [0x671d6f]
/app/java/mysql/libexec/mysqld(open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool)+0x4dc) [0x5de2bc]
/app/java/mysql/libexec/mysqld [0x5d7ad0]
/app/java/mysql/libexec/mysqld(open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int)+0x79a) [0x5da37a]
/app/java/mysql/libexec/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int)+0x64a) [0x5daf6a]
/app/java/mysql/libexec/mysqld(open_normal_and_derived_tables(THD*, TABLE_LIST*, unsigned int)+0x1e) [0x5db22e]
/app/java/mysql/libexec/mysqld(mysqld_list_fields(THD*, TABLE_LIST*, char const*)+0x22) [0x68de82]
/app/java/mysql/libexec/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x834) [0x59dd54]
/app/java/mysql/libexec/mysqld(do_command(THD*)+0xe4) [0x59ea84]
/app/java/mysql/libexec/mysqld(handle_one_connection+0x5d7) [0x58f727]
/lib64/libpthread.so.0 [0x36600064a7]
/lib64/libc.so.6(clone+0x6d) [0x365f8d3c2d]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xec11758 =
thd->thread_id=1
thd->killed=NOT_KILLED
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
servers localhost:11211
        localhost : 11211


请问你有遇到过类似问题吗？？ ]]> http://zyan.cc/post/357/#blogcomment5952 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> xiaogt <user@domain.com> Thu, 20 May 2010 09:11:15 +0000 http://zyan.cc/post/357/#blogcomment5952 转的时候报这样错请大虾们帮忙分析一下  
也可以把数据导出在导进去。不过试了也不行。有没有什么好的办法和思路？


mysql> alter table t engine=MEMCACHE;
ERROR 1005 (HY000): Can't create table 'zhu.#sql-baa_3' (errno: 1429)


引擎是安装了
mysql> SHOW PLUGINS;
+------------+----------+----------------+-----------------------+---------+
| Name       | Status   | Type           | Library               | License |
+------------+----------+----------------+-----------------------+---------+
| binlog     | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| partition  | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| ARCHIVE    | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| BLACKHOLE  | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| CSV        | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| FEDERATED  | DISABLED | STORAGE ENGINE | NULL                  | GPL     |
| MEMORY     | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| InnoDB     | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| MyISAM     | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| MRG_MYISAM | ACTIVE   | STORAGE ENGINE | NULL                  | GPL     |
| ndbcluster | DISABLED | STORAGE ENGINE | NULL                  | GPL     |
| MEMCACHE   | ACTIVE   | STORAGE ENGINE | libmemcache_engine.so | GPL     |
+------------+----------+----------------+-----------------------+---------+
12 rows in set (0.00 sec) ]]> http://zyan.cc/post/357/#blogcomment7374 <![CDATA[[评论] MySQL Memcache_engine的安装与使用[原创]]]> xueli101068 <xueli101068@163.com> Tue, 30 Nov 2010 03:35:12 +0000 http://zyan.cc/post/357/#blogcomment7374 www.lovexueli.com


办学历 办上网学历   办专科学历  办理本科及研究生学历   北京办统招学历 真学历 办北京上网学历； 可在教育网上查询 www.chsi.com.cn         有意者请登录我们的网址www.lovexueli.com 、具体流程请在网站查看 ]]>