toplay Posted January 25, 2009 Share Posted January 25, 2009 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.