MySQL Forums - memcached

NDB Memcache caching policy + external values problems (no replies)

Joshua Gigg — Tue, 14 May 2013 11:44:44 +0000

I'm attempting to use ndb memcache through a PHP API, and am having real problems doing so.

Can anyone confirm whether these are general issues, or whether it might be my setup (which only uses the config generator on severalnines).

In 7.2.7, using the caching policy crashes memcached when trying to get a value that is in the table, but not the local cache.

In 7.3.1 (latest RC), I no longer have the above problem, but I do have the following problems:
1) Caching policy works, but will return inconsistent data:
string(10) "blablablal"
string(14) "blablablal\r\n\000\000"
string(14) "blablablal\r\n\000\000"
string(10) "blablablal"
2) External Values are generated correctly, but when I try to read them all I get is an empty string
3) Any sort of compression that uses the ndb storage doesn't work. I can see the flags column being set correctly. (Using default demo_table_large).

Regarding no. 2, this is the output I see in memcached (-vvv with debug=true)

Write:

52 - Running task: (conn_listening)
<56 new auto-negotiating client connection
56 - Running task: (conn_new_cmd)
56: going from conn_new_cmd to conn_waiting
56 - Running task: (conn_waiting)
56: going from conn_waiting to conn_read
56 - Running task: (conn_read)
56: going from conn_read to conn_parse_cmd
56 - Running task: (conn_parse_cmd)
56: Client using the ascii protocol
<56 set b:largeValueAt1368531790 0 0 5000
56: going from conn_parse_cmd to conn_nread
56 - Running task: (conn_nread)
56 - Running task: (conn_nread)
Got notify from 56, status 0
>56 STORED
56: going from conn_nread to conn_write
56: going from conn_write to conn_swallow
56: going from conn_swallow to conn_new_cmd
56: going from conn_new_cmd to conn_waiting
56: going from conn_waiting to conn_read

Read:

56 - Running task: (conn_read)
56: going from conn_read to conn_parse_cmd
56 - Running task: (conn_parse_cmd)
<56 get b:largeValueAt1368531790
Got notify from 56, status 0
<56 get b:largeValueAt1368531790
>56 sending key b:largeValueAt1368531790

>56 END
56: going from conn_parse_cmd to conn_mwrite
56: going from conn_mwrite to conn_new_cmd
56: going from conn_new_cmd to conn_waiting
56: going from conn_waiting to conn_read
56 - Running task: (conn_read)
56: going from conn_read to conn_closing
56 - Running task: (conn_closing)
-1: going from conn_closing to conn_immediate_close
-1 - Running task: (conn_immediate_close)
Immediate close of 0x7fc57c0010d0

restrict memcache to 2 different IP (no replies)

tng - — Tue, 20 Nov 2012 10:19:57 +0000

Hi guys,

i have a memcache server up and running but i want to restrict the access to it by IP.

i know that i can use the memcached.conf file and set OPTIONS='-l 127.0.0.1'. but i have an other server that needs to connect to memcache on a different IP.

is there a way to do this?

SELECT DATA INTO OUTMCACHED.. LOAD DATA INMCACHE (1 reply)

Ueberbach JP — Sat, 17 Nov 2012 07:33:30 +0000

To enhance performance of some sites which depend heavily on select into outfile and load data infile, i would like to create the following feature:

SELECT INTO OUTMCACHED(mckey) select * from etc ....
LOAD DATA INMCACHED(mckey) into table....

Benefit of this is that i can specify expiry times and i do not need cache disks anymore which over time, when no of files is getting large, become slow.

I have been out of developing something for mysql for quite some time now but i want to pick it up again and this seems like a nice feature.

Or is there already an feature similar to this( which i missed )?

Bulk memcache reads causing WRITE ERRORs? (no replies)

Peter Go — Thu, 01 Nov 2012 17:02:58 +0000

Hello folks,

I'm in PHP doing a memcached->getMulti() of about 5000 keys. The read succeeds, but subsequent writes with memcached->set() of 1 key fails with:

error_code 47 (SERVER HAS FAILED AND IS DISABLED UNTIL TIMED RETRY)

When I remove the getMulti() calls altogether then I get no write errors. I've tried chunking the reads (read 100x @ 50 keys each) but to no avail. However if I introduce a sleep factor between chunk reads then the write errors do go away, but running this way is too slow for our required service level.

It almost appears like ndbcluster is being inundated by the bulk reads and actually isn't "done" when getMulti() returns? When I turn on debugging in memcache I see screens and screens of trace data spewing way long after getMulti() has returned. But this may just be due to I/O delay?

Is there a practical limit on max no. of keys to read with getMulti()? Is it non-blocking by default? How can I get more specific cause info for error 47?

I can certainly come up with more techniques to mitigate large bulk reads, but I'm afraid I may be treating the sympton and not the root problem. By the way I never had this write issue before - code was running reliably for days with getMulti() retrieving 6000 keys at a time with no write errors, and the MySQL Cluster setup has not changed!

Thanks in advance for ANY help!
Peter

Problem with memcached on MySQL Cluster (no replies)

Maxime Thébault — Thu, 04 Oct 2012 10:49:42 +0000

Hello,

I try to configure memcached on my mysql cluster but i have an error.

Result of ndb_mgm -e show :
ndb_mgm -e show
Connected to Management Server at: 3.3.3.3:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)
id=4 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 2 node(s)
id=1 @3.3.3.3 (mysql-5.5.22 ndb-7.2.6)
id=2 @4.4.4.4 (mysql-5.5.22 ndb-7.2.6)

[mysqld(API)] 14 node(s)
id=5 @2.2.2.2 (mysql-5.5.22 ndb-7.2.6)
id=6 @1.1.1.1 (mysql-5.5.22 ndb-7.2.6)
id=7 (not connected, accepting connect from any host)
id=8 (not connected, accepting connect from any host)
id=9 (not connected, accepting connect from any host)
id=10 (not connected, accepting connect from any host)
id=11 (not connected, accepting connect from any host)
id=12 (not connected, accepting connect from any host)
id=13 (not connected, accepting connect from any host)
id=14 (not connected, accepting connect from any host)
id=15 (not connected, accepting connect from any host)
id=16 (not connected, accepting connect from any host)
id=17 (not connected, accepting connect from any host)
id=18 (not connected, accepting connect from any host)

But when i execute the command from 1.1.1.1 (api node) :
memcached -E /usr/local/mysql/lib/ndb_engine.so -u mysql -e "connectstring=3.3.3.3:1186;role=db-only;debug=true" -vv -c 20
(3.3.3.3 is the manager)

The result is :

main --> ndb_initialize()
main --> connect_to_primary_cluster()
04-Oct-2012 10:54:42 CEST NDB Memcache 5.5.22-ndb-7.2.6 started [NDB 7.2.6; MySQL 5.5.22]
Contacting primary management server (3.3.3.3:1186) ...
main --> ClusterConnectionPool::connect()
FAILED.
Could not connect to NDB. Shutting down.
main --> ndb_destroy()
Failed to initialize instance. Error code: 255

I try with localhost, without connectstring...

Can you help me?

Many thanks!

MySQL Error log configuration (no replies)

Asad Raza — Thu, 02 Aug 2012 07:03:27 +0000

Hi guys,

I am running MySQL 5.5.21 (64 bit) in a production server. I can notice that MySQL error logs (/var/lib/mysq/hostname.err) grows in GBs. I have some EVENTs scheduled and MySQL error log file also shows following entry.

"120801 16:29:00 [ERROR] Event Scheduler: [zaeeem@%][advoss.EVT_CalculateProfit] No data - zero rows fetched, selected, or processed"

As you can see this is not the ERROR actually. How to configure MySQL only to write geniune errors into log file. Any help will be appreciated on this.

Extraneous characters returned when reading date field (no replies)

Peter Go — Wed, 01 Aug 2012 22:06:22 +0000

I'm *very* new to mysql cluster ndb-memcache so please bear with me. I have a table (engine=ndbcluster) with a datetime column and I successfully insert data into it via ndb-memcache. I can query the data thru SQL and everything looks good, including the date field data. But if I query using memcached I get extraneous characters in the date returned. Commands below show the problem - notice the "u" character strewn about in the returned date string:

[08:25 PM] ~ > telnet localhost 11212
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
get r:70ba3154a0255c34b4ce
VALUE r:70ba3154a0255c34b4ce 0 74
Streaming & Downloadable Video Unmoderated-UGC 0 2012u-07u-08u 02u:30u:00u
END

Thanks in advance for any help!
Peter

Demo tabs: how to change the default char separator (no replies)

paulo lellis — Sat, 14 Jul 2012 01:22:31 +0000

Does anyone knows if it's possible to change the default column separators in memcached?

Up to the 7.2.6 release, it was only possible using the '\t' char.

How can I use my own charsep/csv event?

Thanks in advance,
Paulo

Maximum columns exceeded (no replies)

paulo lellis — Sat, 14 Jul 2012 01:20:17 +0000

Hello to all.

I am trying to adapt my application to the ndbmemcluster and so far everything went just perfect and beyond dreams.

However, I was playing around Today and got the following issue starting the memcached daemon for a new server role:

root@/root/work/bin$ memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=localhost:1186;role=teste;" -u mysql -d -vvv -p 11212

root@/root/work/bin$ 13-Jul-2012 21:46:43 BRT NDB Memcache 5.5.22-ndb-7.2.6 started [NDB 7.2.6; MySQL 5.5.22]
Contacting primary management server (localhost:1186) ...
Connected to "localhost:1186" as node id 7.
Retrieved 3 key prefixes for server role "teste".
The default behavior is that:
GET uses NDB with local cache
SET uses NDB with local cache
DELETE uses NDB with local cache.
The 2 explicitly defined key prefixes are "GPLAN.AVERAGEN." (atlan_averagen_table) and "GPLAN.GCANDLE." (atlan_gbolsa_table)
Server started with 4 threads.
Priming the pump ...
memcached: /pb2/build/sb_0-5685222-1336648962.68/mysql-cluster-gpl-7.2.6/storage/ndb/memcache/src/Record.cc:69: void Record::addColumn(short int, const NdbDictionary::Column*): Assertion `nvalues <= 16' failed.

The table with the error's ddl:
DROP TABLE atlan_bigd.atlan_averagen_table;
CREATE TABLE atlan_bigd.atlan_averagen_table (
mkey varchar(64) not null default '',
plan_name varchar(8) default null,
element varchar(32) default null,
atribute varchar(32) default null,
period varchar(8) default null,
stock varchar(32) default null,
refdate varchar(14) default null,
quanta varchar(14) default null,
count int default 0,
cls float default null,
var float default 1.0,
sum float default null,
avg float default null,
ema1 float default null,
ema2 float default null,
ema3 float default null,
ema4 float default null,
ema5 float default null,
ema6 float default null,
PRIMARY KEY (`mkey`)) ENGINE=ndbcluster DEFAULT CHARSET=latin1;

Does anyone knows how to increase the number of columns a given event must have? I mean, I'm pretty sure I could patch the Record.cc file, but does it bring any downsizes/ issues?

Thanks in advance,
Paulo Lellis

ConcurrentModificationException using spymemcached with spring integration (no replies)

michal singer — Tue, 10 Jul 2012 07:07:39 +0000

hi, I use mecached and java spymemcached client version2.8.1
when i use the spymemcached integerated with Spring
I get:
java.util.ConcurrentModificationException
in the AbstractLog:
java.util.ConcurrentModificationException
at java.util.HashMap$HashIterator.nextEntry(HashMap.java:793)
at java.util.HashMap$KeyIterator.next(HashMap.java:828)
at net.spy.memcached.util.StringUtils.join(StringUtils.java:41)
at net.spy.memcached.protocol.ascii.BaseGetOpImpl.toString(BaseGetOpImpl.java:227)
at java.lang.String.valueOf(String.java:2826)
at java.lang.StringBuilder.append(StringBuilder.java:115)
at net.spy.memcached.protocol.TCPMemcachedNodeImpl.toString(TCPMemcachedNodeImpl.java:469)
at java.util.Formatter$FormatSpecifier.printString(Formatter.java:2794)
at java.util.Formatter$FormatSpecifier.print(Formatter.java:2677)
at java.util.Formatter.format(Formatter.java:2433)
at java.util.Formatter.format(Formatter.java:2367)
at java.lang.String.format(String.java:2769)
at net.spy.memcached.compat.log.AbstractLogger.debug(AbstractLogger.java:98)

I checked this using spymemcached without spring integration and it worked fine.
I used the same code the spring wrapper for MemcachedClient uses and it worked.
Any ideas whyt this happends, are there any known issues with this integeration?
thnks

Different clients don't see the same data (no replies)

michal singer — Tue, 26 Jun 2012 07:21:14 +0000

Hi.
I have 2 clients and 2 memcached instances (though the same problem exists with one).
When i add data from 1 client, the other client does not see the data.
When i attempt adding from the other client, it fails since the data exists but get fails.

Any idea why this happens?
thanks

How to append block data into demo_large_table (1 reply)

paulo lellis — Wed, 06 Jun 2012 21:21:26 +0000

Hello all,

I'm using the large role, its 'demo_table_large' and 'external_values' for storaging, as shipped with the 7.2.6 release mysql cluster with memcached. I have my own configured prefixes/ containers as well.

Does anyone knows how to append data to a given key? I though something like a new 'append'/'prepend' policy, would be great. I mean, really at the column 'set_policy' under the 'cache_policies' table. Everytime I set a given key, the data is automatically prepend or appended. It's an user duty to clean the mess or use the libevent expiration flag.

So far, I have to 'get' the block via libmemcache, append the data in-app-memory and only then (re) set the block, with the new data prepended.

The append method from libmemcache method or even the protocol seems to not be working.

Does anyone knows how this append/prepend data could be done?

Best regards,
Paulo Lellis

Can't get data using memcached with multi-part key? (no replies)

Peng Shu — Fri, 04 May 2012 07:48:13 +0000

Hi:
I'm using memcached to read data from a table with two primary key.

The table is created by:
create table clusterdb.test_table (
key1 int not null,
key2 int not null,
val varchar(64) not null,
cas_v bigint unsigned,
primary key(key1, key2)
) engine=ndbcluster;

mysql> select * from clusterdb.test_table;
+------+------+------+-------+
| key1 | key2 | val | cas_v |
+------+------+------+-------+
| 1 | 2 | orz | NULL |
+------+------+------+-------+

and the ndbmemcache.containers/key_prefixes are configured like this:

mysql> select * from containers where name='test_mul_key';
+--------------+-----------+------------+-------------+---------------+-------+------------------+------------+--------------------+--------------------+
| name | db_schema | db_table | key_columns | value_columns | flags | increment_column | cas_column | expire_time_column | large_values_table |
+--------------+-----------+------------+-------------+---------------+-------+------------------+------------+--------------------+--------------------+
| test_mul_key | clusterdb | test_table | key1,key2 | val | 0 | NULL | cas_v | NULL | NULL |
+--------------+-----------+------------+-------------+---------------+-------+------------------+------------+--------------------+--------------------+

mysql> select * from key_prefixes where container='test_mul_key';
+----------------+------------+------------+----------+--------------+
| server_role_id | key_prefix | cluster_id | policy | container |
+----------------+------------+------------+----------+--------------+
| 3 | mk: | 0 | caching | test_mul_key |
+----------------+------------+------------+----------+--------------+

Then I run GET from telnet, but got no value.
get mk:1 2 <----1 and 2 seperated by a tab
END

The debug output is:
<63 get mk:1 2
worker.0 ndb_get(): cache miss
worker.0 ndb_get():creating workitem 0.2
worker.0 schedule():SchedulerWorker / config gen. 1
worker.0 worker_set_ext_flag(): 0.2: F
worker.0 --> do_read()
worker.0 --> setKeyForReading()
worker.0 workitem_allocate_rowbuffer_1(): 148 [cls 8]
worker.0 schedule():0.2 placed on send queue.
cl0.conn0.send run_ndb_send_thread():Sent 0.2
cl0.conn0.poll run_ndb_poll_thread(): ** adding 0.2 to wait group **
cl0.conn0.poll run_ndb_poll_thread():Polling 0.2
cl0.conn0.poll callback_main():NoDataFound [626].
cl0.conn0.poll worker_close():0.2
Got notify from 63, status 0
<63 get mk:1 2
worker.0 ndb_get():Got read callback on workitem 0.2: Item Not Found
worker.0 release_and_free():Releasing workitem 0.2.
worker.0 --> release()
worker.0 release():Returned NdbInstance to freelist.
>63 END

Also tried:
get mk:1,2
get mk:1 2
get mk:1:2
but none of these works.

If I run SET, it will say failure:
set mk:1 2 0 0 1
a
SERVER_ERROR failure

Why I can't read the data? Have I got any step wrong?

Thanks.

The expire time of the cached data (no replies)

Peng Shu — Fri, 27 Apr 2012 10:10:42 +0000

Hi

I'm using memcached, with caching policy on GET.
I see the ndb engine will load the data into cache if the data is only in ndb, but the lifetime is only 5s, which is hard-coded in ExpireTime.cc
Will this value be configurable in the future releases? e.g. put it somewhere in ndb.

Thanks.
Peng Shu

memcached-tool with dump not working properly with memcached 1.6 (no replies)

deepak m — Wed, 28 Mar 2012 05:31:53 +0000

hi

i am working on mysql cluster 7.2 with memcached 1.6

in the previous version of memcached memcached tool is working fine with dump
but in this version i am faceing problem with dump.

please correct me if i am wrong

i started with memcached service with command

[root@cent2 ~]# memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=mc-only;debug=true" -vv -c 20 -u root

and using telnet i inserted a key with values

telnet localhost 11211

Escape character is '^]'.
set new 0 0 1
a
STORED
get new
VALUE new 0 1
a
END

but while using memcached tool its just telling how many records there in cache...it is not dumping the key with values...

like
[root@cent2 ~]# /usr/local/memcached-1.6.0_beta1/scripts/memcached-tool localhost:11211 dump
Dumping memcache contents
Number of buckets: 1
Number of items : 1
Dumping bucket 1 - 1 total items

is this problem with version or i am wrong anywhere

thanks in advance

Deepak M

memcached service stoped unexpectedly (no replies)

deepak m — Wed, 28 Mar 2012 04:56:26 +0000

hi

i am working with mysql cluster 7.2.4 with memcached 1.6

i started memcached service with ndb-caching option as shown below
memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=ndb-caching;debug=true" -vv -c 20 -u root

mysql> SELECT * FROM memcache_server_roles where role_name='ndb-caching';
+-------------+---------+---------+---------------------+
| role_name | role_id | max_tps | update_timestamp |
+-------------+---------+---------+---------------------+
| ndb-caching | 3 | 100000 | 2012-03-21 17:53:45 |
+-------------+---------+---------+---------------------+

with role id 3

mysql> SELECT * FROM key_prefixes where server_role_id=3;
+----------------+------------+------------+---------+-------------+
| server_role_id | key_prefix | cluster_id | policy | container |
+----------------+------------+------------+---------+-------------+
| 3 | b: | 0 | caching | demo_ext |
| 3 | t: | 0 | caching | demo_tabs |
| 3 | | 0 | caching | demo_table |
| 3 | d: | 0 | caching | deepak_new |
| 3 | dee: | 0 | caching | deepak_new1 |
+----------------+------------+------------+---------+-------------+

i just looked into demo_tabs container

mysql> SELECT * FROM containers where name='demo_tabs';
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+
| name | db_schema | db_table | key_columns | value_columns | flags | increment_column | cas_column | expire_time_column | large_values_table |
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+
| demo_tabs | ndbmemcache | demo_table_tabs | mkey | val1,val2,val3 | flags | NULL | NULL | expire_time | NULL |
+-----------+-------------+-----------------+-------------+----------------+-------+------------------+------------+--------------------+--------------------+

now i saw the contents in the ndbmemcache.demo_table_tabs table

select * from ndbmemcache.demo_table_tabs;

mysql> select * from ndbmemcache.demo_table_tabs;
+------+--------------+------+------+-------+-------------+
| mkey | val1 | val2 | val3 | flags | expire_time |
+------+--------------+------+------+-------+-------------+
| 2 | abcdefghijlk | NULL | NULL | NULL | NULL |
+------+--------------+------+------+-------+-------------+

i expect for the key t:2 values abcdefghijlk
but this value is not there in cache its there only in database

but still i run get t:2 in telnet the connection closes unexpectedly

like

[root@cent2 ~]# telnet localhost 11211
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
get t:2
Connection closed by foreign host.
[root@cent2 ~]#

in memcached service stoped with error message

[root@cent2 ~]#memcached -E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.12.200.117:1186;role=ndb-caching;debug=true" -vv -c 20 -u root
..........................
..........................
worker.1 schedule():1.0 placed on send queue.
cl0.conn1.send run_ndb_send_thread():Sent 1.0
cl0.conn1.poll run_ndb_poll_thread(): ** adding 1.0 to wait group **
cl0.conn1.poll run_ndb_poll_thread():Polling 1.0
cl0.conn1.poll callback_main():Success.
cl0.conn1.poll worker_finalize_read():1.0
cl0.conn1.poll --> build_hash_item()
cl0.conn1.poll build_hash_item():nbytes: 21 ncopied: 16
Segmentation fault
[root@cent2 ~]#

can any one tell me why this service closeing unexpectedly

thanks in adv

Deepak M

how to load data from table to memcached cache (2 replies)

deepak m — Wed, 28 Mar 2012 06:30:23 +0000

hi

i am using memcached 1.6 ,i have started service using -E option to load ndb engine

when working with caching policy from ndbmemcache database will write to the database as well as cache
i have exicuted flush_all command from telnet , now there is no data in memcache,
How do i reload the data from table back to cache

thanks in advance

Regards
Deepak M

need memcached example to show its fast compared to other (no replies)

deepak m — Fri, 09 Mar 2012 08:08:27 +0000

hi
i am working with memcached with mysql cluster 7.2.
i installed memcached and memcached functions, but while working with memcached its giving result same time as the usual case. can any one having good example for memcahed to prove its fast

thanks in advance

memcached parameter to access engine (1 reply)

deepak m — Tue, 20 Mar 2012 09:07:26 +0000

hi

i am working on memcached implementation with mysql cluster 7.2
i have installed memcached and configured with following parameters

PORT="11211"
USER="mysql"
MAXCONN="1024"
CACHESIZE="1024"
OPTIONS=""

but memcached is worked irrespective to the mysql engine

can any one help me out giving parameter so that it will access the ndb engine and store the values in both memcache and also in database.

memcached error Could not connect to NDB (8 replies)

deepak m — Tue, 27 Mar 2012 09:25:10 +0000

hi
i am installed memcached library by following the steps in the internet.
now there is a binary file created in bin folder of mysql

now i exicuting the command memcached i am getting error like this

[root@centos1 ~]# /usr/local/mysql/bin/memcached E /usr/local/mysql/lib/ndb_engine.so -e "connectstring=10.10.111.111:1186;role=db_only" -vv -c 20 -u root
24-Feb-2012 15:21:06 IST NDB Memcache 5.5.19-ndb-7.2.4 started [NDB 7.2.4; MySQL 5.5.19]
Contacting primary management server (10.10.111.111:1186) ...
FAILED.
Could not connect to NDB. Shutting down.
Segmentation fault

please help me to resolve this problem

Error installing: memcached_functions_mysql-1.1 (3 replies)

Roni Alboim — Tue, 20 Mar 2012 09:20:02 +0000

I installed: libmemcached-1.0.3

And then tryied to installed: memcached_functions_mysql-1.1

While "configure" run fine, the make failed with:

make[2]: Entering directory `/root/Install/mysql_memcach/memcached_functions_mysql-1.1/src'
/bin/sh ../libtool --preserve-dup-deps --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I../include -I/opt/mysql/mysql/include -g -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT util.lo -MD -MP -MF .deps/util.Tpo -c -o util.lo util.c
libtool: compile: gcc -DHAVE_CONFIG_H -I. -I../include -I/opt/mysql/mysql/include -g -DUNIV_LINUX -DUNIV_LINUX -g -O2 -MT util.lo -MD -MP -MF .deps/util.Tpo -c util.c -fPIC -DPIC -o .libs/util.o
util.c: In function 'string_create':
util.c:172: error: invalid application of 'sizeof' to incomplete type 'my_string_st'
util.c:173: error: dereferencing pointer to incomplete type
util.c:174: error: dereferencing pointer to incomplete type
util.c:175: error: dereferencing pointer to incomplete type
util.c:176: error: dereferencing pointer to incomplete type
util.c:177: error: dereferencing pointer to incomplete type
util.c:178: error: dereferencing pointer to incomplete type
util.c:178: error: dereferencing pointer to incomplete type
util.c: In function 'string_append':
util.c:185: error: dereferencing pointer to incomplete type
util.c:185: error: dereferencing pointer to incomplete type
util.c:188: error: dereferencing pointer to incomplete type
util.c:190: error: dereferencing pointer to incomplete type
util.c:197: error: dereferencing pointer to incomplete type
util.c:202: error: dereferencing pointer to incomplete type
util.c:202: error: dereferencing pointer to incomplete type
util.c:202: error: dereferencing pointer to incomplete type
util.c:204: error: dereferencing pointer to incomplete type
util.c:207: error: dereferencing pointer to incomplete type
util.c:208: error: dereferencing pointer to incomplete type
util.c:209: error: dereferencing pointer to incomplete type
util.c: In function 'free_string':
util.c:216: error: dereferencing pointer to incomplete type
util.c: In function 'string_reset':
util.c:222: error: dereferencing pointer to incomplete type
util.c:222: error: dereferencing pointer to incomplete type
util.c:223: error: dereferencing pointer to incomplete type
util.c:224: error: dereferencing pointer to incomplete type
util.c:224: error: dereferencing pointer to incomplete type
make[2]: *** [util.lo] Error 1
make[2]: Leaving directory `/root/Install/mysql_memcach/memcached_functions_mysql-1.1/src'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/root/Install/mysql_memcach/memcached_functions_mysql-1.1/src'
make: *** [all-recursive] Error 1

Memcached Error in "Make" (2 replies)

Stelios Doulakis — Tue, 20 Mar 2012 09:15:00 +0000

Hello,

When i try "make" i get this error:
servers.c:263:28: error: 'memcached_st' has no member named 'hosts'

Can you help me?

Thanks.

spymemcached (java) and libmemcached (c/c++) clients compatibility (no replies)

tianning zhang — Wed, 07 Dec 2011 15:50:15 +0000

I have an environment in which a libmemcached (c/c++ client) has to read cached items from spymemcached client.

It seems not to work. One client can not find the items written by the other clients. I tried different settings for the hashing algorithms - with no success.

Anyone has experiences with such a scenario? What kind of configuration can be used to make libmemcached to worked with spymemcached?

Error using memcached (no replies)

Sven Rissmann — Tue, 30 Nov 2010 11:34:48 +0000

Hello,
I'm retreivig errors when trying to install memcached_functions:

Output from SQL commands in file /tmp/memcached_functions_mysql-1.1/sql/install_functions.sql ..

ERROR 1126 (HY000) at line 38: Can't open shared library 'libmemcached_functions_mysql.so' (errno: 0 /usr/local/mysql/lib/plugin/libmemcached_functions_mysql.so: undefined symbol: memcached_string_append)

MySQL Version: 5.5.7
libmemcached: 0.44
memcached functions: 1.1

Regards
Sven

Monitoring Memcached w/ Evident ClearStone (no replies)

Tim Sneed — Wed, 13 Oct 2010 14:12:59 +0000

To Fellow Memcached Users,

Evident Software would like to invite you to the following webinar.
Date/Time: October 21, 2010 (Thursday) – 2pm EST

Duration: 45 minutes

Webinar Topic

Attendees will learn how Evident ClearStone can be used to monitor and manage your Cassandra, Memcached, or Oracle Coherence application environments.

Who should attend?
Anyone who is responsible for developing, testing, or supporting applications that use NoSQL products like Cassandra or distributed caching technologies like Oracle Coherence, Memcached.

Sign-up
Go to http://www.evidentsoftware.com/category/news-events/events and sign up today.
Inform your colleagues about this event.

Website: www.evidentsoftware.com
Email: info@evidentsoftware.com
Twitter: @evidentsoftware

Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached (no replies)

Edwin DeSouza — Mon, 24 May 2010 15:12:52 +0000

Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached
http://www.clusterdb.com/mysql-cluster/scaling-web-services-with-mysql-cluster-an-alternative-approach-to-mysql-memcached/

MySQL, Memcached, NoSQL (no replies)

Edwin DeSouza — Mon, 01 Mar 2010 18:19:10 +0000

MySQL, Memcached, NoSQL
http://mysqlha.blogspot.com/2010/03/plays-well-with-others.html

Memcached UDFs for MySQL: Verson 1.1 available! (no replies)

Edwin DeSouza — Sun, 15 Nov 2009 22:48:27 +0000

Memcached UDFs for MySQL:
https://launchpad.net/memcached-udfs

Memcached UDFs for MySQL: Verson 1.1 available!
http://capttofu.livejournal.com/25044.html

caching query results (1 reply)

Robin Hughes — Tue, 22 Dec 2009 03:13:31 +0000

I would like to start using the memcached MySQL UDFs, but I am having trouble getting past the very simple tutorial cases.

How does one cache the results of a complicated query where the key of the results are not known in advance? Would you just use the text of the query as the key?

If so, how does one invalidate the cached results when there is no obvious binding between the query text and the tables involved in the query?

Also, can anyone comment on whether or not or how the memcached can be used for quereis that may return a very large result set.

libmemcached, protocol handlers, rolling your own server! (no replies)

Edwin DeSouza — Thu, 15 Oct 2009 18:58:46 +0000

libmemcached, protocol handlers, rolling your own server!
http://krow.livejournal.com/672179.html