Global variable for only one database

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

Re: Global variable for only one database

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