memcache as database

Fri Jun 13 07:41:57 UTC 2008

Can you describe what you want to do? We have found that the UDF's for  
MySQL can achieve anything the engine could.

Cheers,
	-Brian

On Jun 12, 2008, at 9:59 PM, Arun Singhal wrote:

> Hi,
>
> I am trying to install memcache_engine-0.7  on my system. I have  
> already installed libxml and libxmlrow. While installing engine I  
> got the following error. Can anybody help me to resolve this error?
>
>
>
> Making install in src
> make[1]: Entering directory `/memcache/memcache_engine-0.7/ 
> memcache_engine-0.7/src'
> /bin/sh ../libtool --preserve-dup-deps --tag=CXX   --mode=compile g+ 
> + -DHAVE_CONFIG_H -I. -I.. -DMYSQL_DYNAMIC_PLUGIN  - 
> DUNIV_MUST_NOT_INLINE -DFORCE_INIT_OF_VARS -I/usr/local/mysql/sql -I/ 
> usr/local/mysql/include -I/usr/local/mysql/regex -I/usr/local/mysql - 
> I/usr/local/include/libxml2 -I/usr/local/include/libxmlrow      -g - 
> O2 -fno-implicit-templates -fno-exceptions -fno-rtti -MT  
> ha_memcache.lo -MD -MP -MF .deps/ha_memcache.Tpo -c -o  
> ha_memcache.lo ha_memcache.cc
>  g++ -DHAVE_CONFIG_H -I. -I.. -DMYSQL_DYNAMIC_PLUGIN - 
> DUNIV_MUST_NOT_INLINE -DFORCE_INIT_OF_VARS -I/usr/local/mysql/sql -I/ 
> usr/local/mysql/include -I/usr/local/mysql/regex -I/usr/local/mysql - 
> I/usr/local/include/libxml2 -I/usr/local/include/libxmlrow -g -O2 - 
> fno-implicit-templates -fno-exceptions -fno-rtti -MT ha_memcache.lo - 
> MD -MP -MF .deps/ha_memcache.Tpo -c ha_memcache.cc  -fPIC -DPIC - 
> o .libs/ha_memcache.o
> ha_memcache.cc:30:24: error: mysql_priv.h: No such file or directory
> ha_memcache.cc:34:26: error: mysql/plugin.h: No such file or directory
> ha_memcache.h:41: error: 'THR_LOCK' does not name a type
> ha_memcache.h:53: error: expected class-name before '{' token
> ha_memcache.h:54: error: 'THR_LOCK_DATA' does not name a type
> ha_memcache.h:72: error: ISO C++ forbids declaration of 'Field' with  
> no type
> ha_memcache.h:72: error: expected ';' before '*' token
> ha_memcache.h:73: error: 'Field' has not been declared
> ha_memcache.h:76: error: expected `)' before '*' token
> ha_memcache.h:92: error: 'ulonglong' does not name a type
> ha_memcache.h:161: error: use of enum 'ha_rkey_function' without  
> previous declaration
> ha_memcache.h:164: error: 'ha_rows' does not name a type
> ha_memcache.h:167: error: expected ',' or '...' before '*' token
> ha_memcache.h:169: error: ISO C++ forbids declaration of 'key_range'  
> with no type
> ha_memcache.h:178: error: 'TABLE' has not been declared
> ha_memcache.h:179: error: 'HA_CREATE_INFO' has not been declared
> ha_memcache.h:181: error: ISO C++ forbids declaration of  
> 'THR_LOCK_DATA' with no type
> ha_memcache.h:181: error: expected ';' before '*' token
> ha_memcache.h: In member function 'ulong  
> ha_memcache::index_flags(uint, uint, bool) const':
> ha_memcache.h:110: error: 'HA_ONLY_WHOLE_INDEX' was not declared in  
> this scope
> ha_memcache.h: In member function 'uint  
> ha_memcache::max_supported_record_length() const':
> ha_memcache.h:132: error: 'HA_MAX_REC_LENGTH' was not declared in  
> this scope
> ha_memcache.h: In member function 'int  
> ha_memcache::index_next(unsigned char*)':
> ha_memcache.h:163: error: 'HA_ERR_END_OF_FILE' was not declared in  
> this scope
> /usr/local/mysql/include/my_dir.h: At global scope:
> /usr/local/mysql/include/my_dir.h:95: error: 'myf' has not been  
> declared
> /usr/local/mysql/include/my_dir.h:97: error: 'myf' has not been  
> declared
> /usr/local/mysql/include/my_dir.h:98: error: 'myf' has not been  
> declared
> ha_memcache.cc:41: error: expected initializer before '*' token
> ha_memcache.cc:45: error: 'handlerton' was not declared in this scope
> ha_memcache.cc:45: error: 'hton' was not declared in this scope
> ha_memcache.cc:46: error: 'THD' was not declared in this scope
> ha_memcache.cc:46: error: 'thd' was not declared in this  
> scop..............
>
> Thanks,
>
> Arun Singhal
> Software Engineer
> MPS Technologies (A Macmillan company)
>
> Email: a.singhal at mpstechnologies.com
> Web: www.mpstechnologies.com
>
> Mail: MPS Technologies, 3A, 4th & 5th Floors, DLF Corporate Park,  
> Gurgaon 122 002, Haryana, India
>
> -----Original Message-----
> From: Brian Aker [mailto:brian at tangent.org]
> Sent: Thursday, June 12, 2008 6:07 PM
> To: Henrik Schröder; Arun Singhal
> Cc: <memcached at lists.danga.com> list
> Subject: Re: memcache as database
>
> Hi!
>
> On Jun 12, 2008, at 5:08 AM, Henrik Schröder wrote:
>
> > ...and you can not load these rows directly into your application,
> > do the manipulation, and then store the results in another db table
> > because...? I'm totally not seeing what use you have for an external
> > cache like memcached in this case, where you only load the data from
> > the database once. Or am I missing something?
>
> It looks like just using a plain old memory table would be faster. The
> only reason I could think of to use memcached for this would be if the
> data set was so large that using a distributed table made sense (aka
> get more memory from aggregating multiple machines).
>
> But for ip's.... that would have to be more then what this person has.
>
> Cheers,
>       -Brian
>
>
> --
> _______________________________________________________
> Brian "Krow" Aker, brian at tangent.org
> Seattle, Washington
> http://krow.net/                     <-- Me
> http://tangent.org/                <-- Software
> _______________________________________________________
> You can't grep a dead tree.
>
>

--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.