I have been trying to get these functions working all week to limited success. I've been starting over with a fresh install of Centos 5.4 i386, MySQL 5.1.45 and also testing with PHP 5.3.2. As suggested i have tried to limit the versions to libmemcached-0.31/libmemcached-devel-0.31/memcached_functions_mysql-0.8 however this only enabled me to create the UDFs but not to use them. Once installed at this version i can get some return from the functions, but simply get disconnected as follows:
mysql> SELECT memc_servers_set('192.168.4.211:11211');
+-----------------------------------------+
| memc_servers_set('192.168.4.211:11211') |
+-----------------------------------------+
| 0 |
+-----------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
ERROR 2013 (HY000): Lost connection to MySQL server during query
Oddly enough this error was not consistent and on some occasions i can do the following before it fails:
mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
+--------------------------------------------------------------------+
| memc_set('mykey', 'Getting this with SELECT means all works well') |
+--------------------------------------------------------------------+
| 20 |
+--------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> SELECT memc_get('mykey');
+-------------------+
| memc_get('mykey') |
+-------------------+
| NULL |
+-------------------+
1 row in set (0.00 sec)
I have a complete list of the packages installed along the way and the few config steps required to get to this stage if anyone is interested in reviewing the setup. I am really struggling to progress and since updating to UDFs 1.1 and libmemcached 0.38 i am now unable to use the functions at all. Please let me know if there is anything i can try to resolve these issues or provide further debug at this stage. Many thanks
I have been trying to get these functions working all week to limited success. I've been starting over with a fresh install of Centos 5.4 i386, MySQL 5.1.45 and also testing with PHP 5.3.2. As suggested i have tried to limit the versions to libmemcached- 0.31/libmemcach ed-devel- 0.31/memcached_ functions_ mysql-0. 8 however this only enabled me to create the UDFs but not to use them. Once installed at this version i can get some return from the functions, but simply get disconnected as follows:
mysql> SELECT memc_servers_ set('192. 168.4.211: 11211') ; ------- ------- ------- ------- ------- + set('192. 168.4.211: 11211') | ------- ------- ------- ------- ------- + ------- ------- ------- ------- ------- +
+------
| memc_servers_
+------
| 0 |
+------
1 row in set (0.00 sec)
mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well');
ERROR 2013 (HY000): Lost connection to MySQL server during query
Oddly enough this error was not consistent and on some occasions i can do the following before it fails:
mysql> SELECT memc_set('mykey', 'Getting this with SELECT means all works well'); ------- ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ------- ------- ------- ------- ------- ------- ------+ ------- ------- ------- ------- ------- ------- ------- ------- ------+
+------
| memc_set('mykey', 'Getting this with SELECT means all works well') |
+------
| 20 |
+------
1 row in set (0.00 sec)
mysql> SELECT memc_get('mykey'); ------- ------+ ------- ------+ ------- ------+
+------
| memc_get('mykey') |
+------
| NULL |
+------
1 row in set (0.00 sec)
I have a complete list of the packages installed along the way and the few config steps required to get to this stage if anyone is interested in reviewing the setup. I am really struggling to progress and since updating to UDFs 1.1 and libmemcached 0.38 i am now unable to use the functions at all. Please let me know if there is anything i can try to resolve these issues or provide further debug at this stage. Many thanks