How to clear PHP memcache area from MySQL stored procedures?

[toplay]

This is a very specific question on how to go about clearing PHP memcache area from within MySQL stored procedures/functions. I'm not sure if it's possible or not.

 

I'm using PHP 5+ and MySQL 5+. The PHP memcache works fine. I can also use the MySQL memcache to set, get and delete it's own keys within MySQL fine. I'm setting the servers (IP's) used for caching the same on the PHP and MySQL side. However, the problem I'm having is trying to delete a memcache (key) that was created from PHP using MySQL stored procedure and it doesn't delete it. I know what the PHP key is, but when I use it in a SELECT memc_delete('key here'); it returns an integer of 16 and doesn't delete the PHP cache associated with that key.

 

It's like as if the PHP and MySQL caching mechanism have their own specific areas of memory (for caching) even though they both have the same caching server IP's set.

 

Any pointers/help would be appreciated.

 

Thank you.

 

FYI:

 

http://dev.mysql.com/doc/refman/5.0/en/ha-memcached-interfaces-mysqludf.html

 

http://us2.php.net/manual/en/ref.memcache.php