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 ..
SELE
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
