Hello, you cannot change it in database level, it applies only to instance level.
else if you dont want to use query cache for certain queries you can include "SQL_NO_CACHE" in your query .. ex .. SELECT SQL_NO_CACHE ID,NAME FROM EMPLOYEE; --> your query result will not be cached here .. SELECT SQL_CACHE ID,NAME FROM EMPLOYEE; --- > your query result will be cached here if the query_cache variable is set to ON. Hope this will clear your doubt.. Regards Anand S On Thu, Dec 31, 2009 at 2:33 PM, Jeetendra Ranjan < jeetendra.ran...@sampatti.com> wrote: > Hi, > > We have number of mysql database in one box. > > How can we set the variables that applies to only one database. Like when i > set the query_cache_size it should be used by only those queries for which > the parameter is set ? > > > Thanks >
