I'm pleased to announce the release of Memcached Functions for MySQL version 1.1. I realized in the past few weeks, while writing my latest book "Expert PHP and MySQL", that there was no way to obtain the CAS value of a cached item in order to successfully use the function memc_cas(). So, I decided to create a new function, memc_get_cas(), which obtains the CAS value for an item so you can subsequently use this value in a memc_cas() call, which is shown in the example below:

mysql> select memc_get_cas('t1');
+--------------------+
| memc_get_cas('t1') |
+--------------------+
|                  3 | 
+--------------------+
1 row in set (0.00 sec)

mysql> select memc_get('t1');
+----------------+
| memc_get('t1') |
+----------------+
| new value      |

  [Read more...]

I have a talk scheduled tonight, for anyone who's in the Southern New Hampshire area (or greater Northern New England area): http://permalink.gmane.org/gmane.org.user-groups.linux.gnhlug.announce/743

I'll be going over a number of things, time permitting:

* memcached (in general)
* NorthScale's memcached Amazon Machine Images and Virtual Appliance
* moxi - memcached proxy
* memcached Functions for MySQL

I'll run a couple demonstrations with each, first simple memcached usage, then using two memcached instances through moxi, then I'll throw in using them with the UDFs.

I intend to see if the Boston MySQL Users Group would be interested in this talk soon as well.

I realized the other day that I need the sleep() function, which up until this morning, Drizzle did not have, for testing the memcached Drizzle UDFs. Well, now it does:

drizzle> select sleep(3);
+----------+
| sleep(3) |
+----------+
| 0 |
+----------+
1 row in set (3 sec)

drizzle> select sleep(0);
+----------+
| sleep(0) |
+----------+
| 0 |
+----------+
1 row in set (0 sec)

drizzle> select sleep(20);
+-----------+
| sleep(20) |
+-----------+
| 0 |
+-----------+
1 row in set (20 sec)

As you see, it returns zero, just as the MySQL sleep() function does.

The code can be had at:

lp:~capttofu/drizzle/sleep

Hi all,

This is a quick post to let you know that the memcached functions for MySQL have been moved to Launchpad. The project page is: https://launchpad.net/memcached-udfs

I think this will help to get the project more exposure, as well as making it easier for people to contribute to the project. I've found Launchpad to be quite useful for managing projects and so decided to move the UDFs there.

I'm working on getting out another version soon. I just fixed a bug the deals with user-defined variables that were set to NULL causing the UDFs to crash the server. It was a bug in the length of the argument being set to 8192


For instance, the first explicitly:

mysql> select memc_set('nullval', null);

(gdb) p args->args[1]
$3 = 0x0
(gdb) p args->lengths[1]
$4 = 0

















  [Read more...]