?? readme
字號:
Hi!First things, first. This should not even be considered Alpha. The 5.1 forthe mysql server at the point that I am writing this is not stable. Do not use this in production. There are many bugs, and I suspect that quite a bitof SQL is not working. The basics of INSERT/UPDATE/SELECT all work.Second thing, I am actively looking for others to contribute code and ideas.If this just me, then it will fit just my needs, and I will most likely getbored with publishing it. If you use it, you ought to tell me. I've beenasked about writing this dozens of times over the years, and I decided tosit down one Saturday morning and write it.Third, you will need to install the following libraries to make this work:http://tangent.org/552/libmemcached.htmlhttp://tangent.org/578/libxmlrow.htmlLimitations:You must have a key to do a read, aka scan reads do not work.Schema requires a primary key.No autoincrement supportI will be posting comments about it to my blog. That is the best place tolearn about how to extend it. The address is:http://krow.livejournal.com/You can watch commits based on RSS via:http://hg.tangent.org/memcache_engine?cl=tip;style=rssTo install, first install memcache and libmemcached then do a ./configure --with-mysql=/home/brian/mysql-5.1/ --libdir=/usr/local/lib/mysql/make installAnd then inside of MySQL:mysql> INSTALL PLUGIN memcache SONAME 'libmemcache_engine.so';mysql> INSTALL PLUGIN memcache_servers SONAME 'libmemcache_engine.so';mysql> CREATE TABLE `d` (`a` varchar(125), b text, primary key(a)) ENGINE=memcache DEFAULTCHARSET=latin1 CONNECTION='localhost:6666' ;Query OK, 0 rows affected (0.01 sec)The syntax for multiple servers is:CREATE TABLE `a` ( `a` int(11) NOT NULL DEFAULT '0', `b` int(11) DEFAULT NULL, `c` int(11) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=MEMCACHE DEFAULT CHARSET=latin1CONNECTION='localhost:6666\;localhost:6688';You can get information on the state of the memcached engines by doing this:mysql> select * from information_schema.memcache_servers;You will probably need to edit the Makefile.am in the src/ tree if you wantto build on anything other then Linux (and the Makefile assumes that theserver was not compiled for debug).Have fun!Cheers, -Brian
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -