Global variable for only one database

------=_NextPart_000_0083_01CA8A26.42DC3AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,=20

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

------=_NextPart_000_0083_01CA8A26.42DC3AC0--

Re: Global variable for only one database

--000e0cd729447e432a047c036bae
Content-Type: text/plain; charset=ISO-8859-1

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.ranjan@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
>

--000e0cd729447e432a047c036bae--