Does mysql query cache have to be off to use memcached? [closed]

by

How do you know if memcached is being used? Server has mysql query cache on and I believe it also has memcahced installed, but how do I know if memcached is being used?

Thanks!

Answer

memcache and sql query cache are independent of each other and both can be used without impacting each other. memcache needs to be installed as a separate server process and cache needs to be managed programatically.

  1. Check if memcache is listening on the port on which it was installed:

netstat -ap | grep selected_port

If it is listening on that port, means it has started

  1. To check if it is setting the cache or getting from cache, you start in verbose mode manually (use the following command) and observe for sometime for any data being cached or not:

memcached -vv

Attribution
Source : Link , Question Author : Brett , Answer Author : webstat

Leave a Comment